MQSeries.net :: View topic - Problem with PASSTHRU statement and Oracle DB

SergeiKA · Posted: Thu Aug 27, 2009 4:57 am Post subject:

Hi,
first of all sorry for my poor english

I have a problem with PASSTHRU statement.

I need to execute some sql-scripts using PASSTHRU. In these scripts parameters in cp1251 coding are inserted in Oracle DB (NLS_CHARACTERSET=CL8MSWIN1251).

The primitive examle of the ESQL-code with script:

PASSTHRU('begin
insert into Table1 (Par1, Par2)
values ('''', ''Привет мир!'');
commit;
end;');

We have two servers with MB: one for dev and the other for test purpose.
On the first server the data is inserted correctly in the external DB, but on the second the data is inserted in wrong coding in the same external DB.

On the first server we have parameters:

brkuser@t34:~> echo $NLS_LANG
AMERICAN_AMERICA.CL8MSWIN1251

brkuser@t34:~> locale
LANG=ru_RU.CP1251
LC_CTYPE="ru_RU.CP1251"
LC_NUMERIC="ru_RU.CP1251"
LC_TIME="ru_RU.CP1251"
LC_COLLATE="ru_RU.CP1251"
LC_MONETARY="ru_RU.CP1251"
LC_MESSAGES="ru_RU.CP1251"
LC_PAPER="ru_RU.CP1251"
LC_NAME="ru_RU.CP1251"
LC_ADDRESS="ru_RU.CP1251"
LC_TELEPHONE="ru_RU.CP1251"
LC_MEASUREMENT="ru_RU.CP1251"
LC_IDENTIFICATION="ru_RU.CP1251"
LC_ALL=

We set the same parameters on the second server, but this has no result.

On the IBM support we have been advised to use INSERT statement istead of PASSTHRU, because PASSTHRU satement is using for administrative purposes.
But in our case we can't use INSERT statement, and besides we have already sured, that PASSTHRU works on one server. So we need to configure the other.

If anybody has some ideas how to configure broker in our case, please tell us.

Thanks!