| Author |
Message
|
| satheesh kampati |
 Posted: Mon Apr 18, 2016 5:13 am Post subject: Issuing calling with the select query to DB in IIB |
 |
|
Newbie
Joined: 28 Dec 2012
Posts: 5
|
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: WebSphere Message Broker
when i am trying to query the following through passthru
Select Ascii(Char) from dual;
to fetch the ascii code for the arabic characters it is returning invalid ascii values in the IIB and the same hass worked in previous version.
Could you please suggest if there is any issues with the IIB in running the select query. |
|
| Back to top |
|
 |
| maurito |
| Posted: Mon Apr 18, 2016 5:29 am Post subject: Re: Issuing calling with the select query to DB in IIB |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| satheesh kampati wrote: |
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: WebSphere Message Broker
when i am trying to query the following through passthru
Select Ascii(Char) from dual;
to fetch the ascii code for the arabic characters it is returning invalid ascii values in the IIB and the same hass worked in previous version.
Could you please suggest if there is any issues with the IIB in running the select query. |
Can you be a bit more explicit please ?. What do you mean by 'invalid ascii values' ? That select will return a NUMBER.
Can you give an example ?
Have you executed the same command in an Oracle command prompt ? |
|
| Back to top |
|
|
| satheesh kampati |
| Posted: Mon Apr 18, 2016 9:45 pm Post subject: Re: Issuing calling with the select query to DB in IIB |
|
|
Newbie
Joined: 28 Dec 2012
Posts: 5
|
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
The same query executed in oracle is returning the right value 202.
Kindly suggest |
|
| Back to top |
|
|
| maurito |
| Posted: Mon Apr 18, 2016 10:10 pm Post subject: Re: Issuing calling with the select query to DB in IIB |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| satheesh kampati wrote: |
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
The same query executed in oracle is returning the right value 202.
Kindly suggest |
can you please post an example of the query ? ie. the PASSTHRU statement and the value you are passing to it ? |
|
| Back to top |
|
|
| satheesh kampati |
| Posted: Mon Apr 18, 2016 11:12 pm Post subject: Re: Issuing calling with the select query to DB in IIB |
|
|
Newbie
Joined: 28 Dec 2012
Posts: 5
|
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 passing to the Passthru. |
|
| Back to top |
|
|
| maurito |
| Posted: Mon Apr 18, 2016 11:42 pm Post subject: Re: Issuing calling with the select query to DB in IIB |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| satheesh kampati wrote: |
| 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 the Passthru.[/quote]
well, that probably is your problem. you are passing a non ASCII character, where did you get it from?
Have you typed it in?
what is the hexadecimal representation of that character?
What code page is it in? |
|
| Back to top |
|
|
| timber |
| Posted: Mon Apr 18, 2016 11:52 pm Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1280
|
| You probably should not be using the ASCII function at all, unless the code page is one of extended ASCII encodings. Please explain why you want to get this number. Why can you not work with the text value? |
|
| Back to top |
|
|
| satheesh kampati |
| Posted: Mon Apr 18, 2016 11:52 pm Post subject: Re: Issuing calling with the select query to DB in IIB |
|
|
Newbie
Joined: 28 Dec 2012
Posts: 5
|
| maurito wrote: |
| satheesh kampati wrote: |
| 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 the Passthru. |
well, that probably is your problem. you are passing a non ASCII character, where did you get it from?
Have you typed it in?
what is the hexadecimal representation of that character?
What code page is it in?[/quote]
This is a valid arabic character which is working fine getting the ascii value in v 7.0.0.7
we are facing this issue only after the upgrade
The code page we are using is 1089 |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Apr 19, 2016 1:26 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Somethnig that may have worked in a previous version might have worked because of a Bug that has since been fixed.
This is the sort of thing that you testing should have thrown up.
Perhaps you need to go back and look at the underlying SQL command and see if there is an alternative method of getting the data available to you.
If there isn't then it might be time for an ODBC trace (on both versions!) followed by a PMR.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
