MQSeries.net :: View topic - switching tables using esql

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » switching tables using esql

switching tables using esql

« View previous topic :: View next topic »

Author

Message

Rockon

Posted: Wed Dec 07, 2005 7:53 am Post subject: switching tables using esql

Apprentice

Joined: 24 May 2004
Posts: 43

Hi,
Just curious to find out if we can switch across tables in a single query statement in a Compute Node.
example:
Set Environemnt.Variables.getv_id=THE(......) the sql statement being

Code:

SELECT MIN(A.V_ID) FROM schemaA.tableXX N
WHERE N.PART_NUMBER = '9999'
AND N.VENDOR_ID = 'ABC9999'
exception
when no_data_found then
SELECT MIN(A.V_ID) FROM schemaA.tableYY M
WHERE M.PART_NUMBER = '9999'
AND M.VENDOR_ID = 'ABC9999'

The alternate method would ofcourse be to catch it as an exception using the SQLCODE value.

FYI "If PL/SQL raises the NO_DATA_FOUND exception, then SQLCODE returns a value of +100"

Thankyou,
Cheers

shrek

Posted: Wed Dec 07, 2005 9:03 am Post subject:

Acolyte

Joined: 19 Feb 2005
Posts: 61
Location: Gudivada,India

One other way of doing it is executing the two SQL with in a COALESCE.

Code:

Set Environemnt.Variables.getv_id = COALESCE(SQL1, SQL2);

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » switching tables using esql

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP