MQSeries.net :: View topic

vlburch · Posted: Thu Dec 07, 2006 5:23 pm Post subject:

I am trying to query an Oracle table with the controlling column defined as varchar2 so I need to have my where variable in quotes. This code
is not working:

SET unit.info[] = select x.ag_id
,x.unid
from Database.def_unit as x
where x.unid = 'hcrew';

But performing the query in sqlplus works. So does it lose the quotes around the variable hcrew in passing and send something like 9011B instead of '9011B' or does it send 'hcrew' as the test value?

Is there anyway to load a variable to the value '

I'm using 6.0 version of the Broker and it appears that setting a variable to this ''' does not work. (SET quot = '''

I was going to try building the SQL in a variable and use PASSTHRU, and that is when I discovered the ''' did not work.
_________________
VLBurch