| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Search found 5 matches |
| Author |
Message |
 Topic: Issuing calling with the select query to DB in IIB |
satheesh kampati
Replies: 8
Views: 3705
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2016 11:52 pm Subject: Re: Issuing calling with the select query to DB in IIB |
can you please post an example of the query ? ie. the PASSTHRU statement and the value you are passing to it ?
Hi Maurito
SELECT ASCII('ت') FROM DUAL;
this is the query i am passing to ... |
| Topic: Issuing calling with the select query to DB in IIB |
satheesh kampati
Replies: 8
Views: 3705
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2016 11:12 pm Subject: Re: Issuing calling with the select query to DB in IIB |
can you please post an example of the query ? ie. the PASSTHRU statement and the value you are passing to it ?[/quote]
Hi Maurito
SELECT ASCII('ت') FROM DUAL;
this is the query i am pas ... |
| Topic: Issuing calling with the select query to DB in IIB |
satheesh kampati
Replies: 8
Views: 3705
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2016 9:45 pm Subject: Re: Issuing calling with the select query to DB in IIB |
hi maurito
actually with this select select query i am trying to get the ascii value of the arabic characters but irrespective of what arabic value i am passing the query is returning '26.0' value ... |
| Topic: Issuing calling with the select query to DB in IIB |
satheesh kampati
Replies: 8
Views: 3705
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2016 5:13 am Subject: Issuing calling with the select query to DB in IIB |
Hi all,
Currently i am using
BIP8996I: Version: 9004
BIP8997I: Product: IBM Integration Bus
this has been upgraded 2 weeks ago from
BIP8996I: Version: 7007
BIP8997I: Product: ... |
| Topic: substr(number,3,2) IN ('03','18','09','07') i need to fetch |
satheesh kampati
Replies: 1
Views: 1304
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Mar 23, 2013 10:53 am Subject: substr(number,3,2) IN ('03','18','09','07') i need to fetch |
Hi all,
I am trying to get these records which are having these values
EG: substr(10035489,3,2) IN ('03','18','09','07') )
Then i should get 03 else the other values which are having 18,09,07 |
|
|
|
