| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Seq Number in MB |
« View previous topic :: View next topic » |
| Author |
Message
|
| sasanka_n |
 Posted: Mon Sep 22, 2008 10:22 pm Post subject: Seq Number in MB |
 |
|
Newbie
Joined: 22 Sep 2008
Posts: 1
|
Hi,
how to get the sequence number from the database in the compute node .esql file i have tried with SET Environment.Variables.ID=(SELECT SEQORDERNO.NEXTVAL FROM Database.DB.DUAL);
but i am getting the error as
The correlation name 'SEQORDERNO.NEXTVAL' is not valid. Those in scope are: Environment, InputLocalEnvironment, OutputLocalEnvironment, InputRoot, InputBody, InputProperties, OutputRoot, InputExceptionList, OutputExceptionList, InputDestinationList, OutputDestinationList, source, target, pattern, ID, DUAL. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Sep 22, 2008 10:39 pm Post subject: Re: Seq Number in MB |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sasanka_n,
| sasanka_n wrote: |
how to get the sequence number from the database in the compute node .esql file i have tried with SET Environment.Variables.ID=(SELECT SEQORDERNO.NEXTVAL FROM Database.DB.DUAL);
but i am getting the error as
The correlation name 'SEQORDERNO.NEXTVAL' is not valid. Those in scope are: Environment, InputLocalEnvironment, OutputLocalEnvironment, InputRoot, InputBody, InputProperties, OutputRoot, InputExceptionList, OutputExceptionList, InputDestinationList, OutputDestinationList, source, target, pattern, ID, DUAL. |
SEQORDERNO.NEXTVAL is not the name of the column, is it ?
Could you please give a little more details about the table and this sequence that your are querying. what are you trying to achieve ?
Regards. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Sep 22, 2008 11:20 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Sequence Variable will be created by a DBA or some one else, and can be retirieved from ESQL by using PASSTHRU functionality.
Environment.Variables.ID=PASSTHRU('SELECT SEQORDERNO.NEXTVAL FROM DUAL')
Assuming SEQORDERNO.NEXTVAL is been created at Database side, if not;create it
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
