| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMB 6.1: Select from Oracle Sequence - DUAL |
« View previous topic :: View next topic » |
| Author |
Message
|
| scravr |
 Posted: Wed Nov 12, 2008 8:44 am Post subject: WMB 6.1: Select from Oracle Sequence - DUAL |
 |
|
Partisan
Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021
|
In ESQL: I have this select from oracle sequence:
SET Environment.Variables.IntegData[] = SELECT WMB.IMADSEQ.NEXTVAL FROM Database.DUAL;
geting deploy error:
BIP2432E: The correlation name 'WMB.IMADSEQ.NEXTVAL' is not valid. Those in scope are: Environment, InputLocalEnvironment, OutputLocalEnvironment, InputRoot, InputBody, InputProperties, OutputRoot, InputExceptionList, OutputExceptionList, InputDestinationList, OutputDestinationList, P1, P2, T2, GT, MsgProc, temp1, temp2, temp3, DUAL.
The first element of a field reference must be a valid correlation name, from those in scope. This message may sometimes be due to an incorrectly formed or spelled expression which is not intended to be a field reference being parsed as if it were a field reference because the parser does not recognize it.
This works when runing in oracle directly.
SELECT WMB.IMADSEQ.NEXTVAL FROM DUAL;
How do I get NEXTVAL in ESQL? |
|
| Back to top |
|
 |
| sridhsri |
| Posted: Wed Nov 12, 2008 9:03 am Post subject: |
|
|
Master
Joined: 19 Jun 2008
Posts: 297
|
| I think you are missing "Database.DUAL AS WMB" |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Nov 12, 2008 9:12 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
There is a difference between ESQL Select statement and SQL Select statement.
Until you understand what that difference is, you will continue to have trouble using databases with ESQL. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Nov 12, 2008 7:32 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
we discussed a lot about this and even given good insight to you also
use PASSTHRU function
As Jeff said there is a difference in ESQL Select and SQL Select. (had given couple of hints to you, what to use and how to use)
Try out and search the forum.
_________________
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
|
|
|
|
