| Author |
Message
|
| sv |
 Posted: Wed Aug 03, 2016 8:16 pm Post subject: i have two tables A and B and need to join these two table |
 |
|
Newbie
Joined: 03 Aug 2016
Posts: 3
|
Hi All,
Please help me urgent basis
I have two tables A and B .i have to join these tables using ESQL with join
Can any write a ESQL join syntax |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Aug 04, 2016 3:19 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Can you write the SQL to do the query?
If so then put that into a CHAR variable and use the PASSTHRU function.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 04, 2016 3:34 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You mean you want to select from both tables?
like
| Code: |
| SELECT A.*, B* from Table1 as A, Table2 as B |
?
Basic function of the ESQL Select statement... at least shown as an example in the docs, if not actually explained further.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| sv |
| Posted: Thu Aug 04, 2016 4:42 am Post subject: i need to select both two tables |
|
|
Newbie
Joined: 03 Aug 2016
Posts: 3
|
Main Requirement :i have one error table,it has some error message .Ever 12 hours I need to send these errors to another table .
How to do that with joins.
IF possibule can you please provide the sample syntax errors. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 04, 2016 4:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Do you need to transform the error messages?
If not, don't bother, configure the database to do it.
Otherwise it's a straightforward use of database operations, with ESQL logic to do the transformation.
Hint - you want to "read" the data from one table, transform it, and then "write" it to another table.
But ask yourself how you are going to handle "every 12 hours".
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 04, 2016 4:51 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
Do you need to transform the error messages?
If not, don't bother, configure the database to do it. |
| mqjeff wrote: |
| But ask yourself how you are going to handle "every 12 hours". |
How are you going to start this proposed flow every 12 hours? How are you going to handle all the possible exceptions when it can't be started?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| sv |
| Posted: Thu Aug 04, 2016 4:55 am Post subject: |
|
|
Newbie
Joined: 03 Aug 2016
Posts: 3
|
| Every 12 hours i have logic, I am bothering about Select from frist table and update to second table. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 04, 2016 5:04 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sv wrote: |
| Every 12 hours i have logic |
What logic? How does it handle the possible exceptions and failures?
(If you say "Timer nodes" I'm going to laugh at you)
And why IIB rather than one of the more logical tool choices for this requirement?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 04, 2016 5:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
How will you know when 12 hours have elapsed?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
|
|
