| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Select stament in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| boogey |
 Posted: Fri Aug 24, 2007 12:36 pm Post subject: Select stament in ESQL |
 |
|
Novice
Joined: 01 Jan 2007
Posts: 21
|
Hi,
I am using the following statement to query the database,
(THE (SELECT ITEM N.TECSYS_CODE FROM Database.{cSOURCE}.{cSCHEMA}.{cTABLE } AS N WHERE N.SAP_CODE = VKORG ));
Souce, schema, table names are delclared as external variables. This select statement doesn't return any value, no errors too.
I did select query in Oracle databse, for the same VKORG value, it resulted the exact value
I hard code the value VKORG in messge flow, then it resulted the exact value.
But i IF pass the VKORG value from input , it doesn't result any value.
Where did i go wrong?
Someone please help me.
Thanks |
|
| 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
|
|
|
|
