SqlDbx Forum

SqlDbx

You are not logged in.

#1 2011-04-26 20:46:40

mikeb
Member

DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

Hi,

I am trying to make multiple updates on my table and each update statement separated by ;

UPDATE TABLE SET COLUMN1 = VALUE1 WHERE COLUMN2 = VALUE-1;
UPDATE TABLE SET COLUMN1 = VALUE2 WHERE COLUMN2 = VALUE-2;
UPDATE TABLE SET COLUMN1 = VALUE2 WHERE COLUMN2 = VALUE-2;

Only the 1st statement run, the rest were not and I got the following message

DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON.

I tried

--# SET DELIMETER !

and it also did not work. Any suggestion?

Thanks
Mike

Offline

#2 2011-04-26 21:21:22

sqldbxhelp
Administrator

Re: DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

In general this should work ok. What database and version you connect to?

Online

#3 2011-04-27 06:18:11

mikeb
Member

Re: DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

ZOS Mainframe DB2 Version 9.

--#SET DELIMETER is giving me the following error:

SQLCODE -198, THE OPERAND OF THE PREPARE OR EXECUTE IMMEDIATE STATEMENT IS BLANK OR EMPTY

Offline

#4 2011-04-27 12:19:39

sqldbxhelp
Administrator

Re: DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

SET DELIMITER is not going to work for generic ODBC connection. It only works for native DB2 connection.
This is because when using generic ODBC connection SqlDbx uses only functionality available in ODBC.

Online

#5 2011-04-27 13:51:47

mikeb
Member

Re: DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

Does it mean I can issue multiple SQL statement for ODBC connection? There is no way to go around it?

Offline

#6 2011-04-27 14:22:14

sqldbxhelp
Administrator

Re: DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

You should be able to issue multiple statements for ODBC. Statement separator in ODBC in ";"
It looks that it works correctly in the latest version (3.49).

Online

#7 2011-04-27 17:13:48

mikeb
Member

Re: DATADIRECT [ODBC SHADOW DRIVER] [DB2] SQLCODE = 098, WARNING DYNAMIC

I checked the SQLDBX version and I am using 3.1. I upgraded to 3.3 and it is working now. Thanks.

Offline

Board footer

Powered by FluxBB