Forum Discussion

shpits's avatar
shpits
New Contributor
12 years ago

Running DB2 queries fails with: SQL0104

Hi folks,

Running several queries for DB2 is failing with the following error:
Error getting response; com.ibm.db2.jcc.a.rm: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601 DRIVER=4.0.100

The following query is running successfully:
INSERT INTO Table(NAME) select 'test1' from sysibm.sysdummy1 where NOT exists (select * from Table where NAME='test1')

But when running 2 queries with ; delimiter then I get the error:
INSERT INTO Table(NAME) select 'test1' from sysibm.sysdummy1 where NOT exists (select * from Table where NAME='test1');
INSERT INTO Table(NAME) select 'test1' from sysibm.sysdummy1 where NOT exists (select * from Table where NAME='test1');

I tried to change the delimiter to : / , ! space and nothing worked.
The same quires run perfectly in the DB2 client, so it's the soapUI that is responsible for this.

Please assist.

Gadi
No RepliesBe the first to reply