| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Select statement with where clause is not working properly |
« View previous topic :: View next topic » |
| Author |
Message
|
| HJaber |
 Posted: Thu Aug 04, 2022 1:40 am Post subject: Select statement with where clause is not working properly |
 |
|
Newbie
Joined: 04 Aug 2022
Posts: 6
|
Hello every one,
I am trying to select some data from oracle database and i faced a problem with the where clause as the following:
SET Environment.Data = select KC.* from Database.Table AS KC where KC.KeyT = InputRoot.JSON.Data.KeyType; --> this do not retrieve any data
SET Environment.Data = select KC.* from Database.Table AS KC where KC.KeyT = 'ABC'; --> this retrieve the data correctly
noting that the data location inside the input root is correct, i tried to store it inside environment variable and inside local variable and nothing work...
so how to make it working properly since i can't make the condition with static value(s)
by the way i am on ACE 12
Thanks in advance, |
|
| Back to top |
|
 |
| abhi_thri |
| Posted: Thu Aug 04, 2022 2:54 am Post subject: Re: Select statement with where clause is not working proper |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
| HJaber wrote: |
noting that the data location inside the input root is correct, i tried to store it inside environment variable and inside local variable and nothing work...
|
hi...the above seems to be a contradictory statement, if the field path is correct the value should get assigned to variables.
try collecting the user trace for the flow and see what value gets printed for 'InputRoot.JSON.Data.KeyType'
If you add a tracenode to the flow and print the message using {$Root} that should tell you the exact field path for the value you are looking for and then you can use that path in the code. |
|
| Back to top |
|
|
| HJaber |
| Posted: Thu Aug 04, 2022 3:13 am Post subject: |
|
|
Newbie
Joined: 04 Aug 2022
Posts: 6
|
Thanks for your support
Sorry not to mention that I already solved it 
Now I faced a new issue; I can't insert data into database as the following:
INSERT INTO Database.table(REF_ID, KEY_TYPE) VALUES ('234567', 'abc');
it return to me all the time "driver does not support this function" |
|
| Back to top |
|
|
| HJaber |
| Posted: Thu Aug 04, 2022 4:47 am Post subject: |
|
|
Newbie
Joined: 04 Aug 2022
Posts: 6
|
| HJaber wrote: |
Thanks for your support
Sorry not to mention that I already solved it
Now I faced a new issue; I can't insert data into database as the following:
INSERT INTO Database.table(REF_ID, KEY_TYPE) VALUES ('234567', 'abc');
it return to me all the time "driver does not support this function" |
It solved when I check the parameter on the ODBC named "Enable SQLDescribeParam" |
|
| 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
|
|
|
|
