Db2 - L

I just use the SQLERRD(3) from the SQLCA - It contains how many rows were INSERTed or DELETEd Roy Boxwell SOFTWARE ENGINEERING GmbH and SEGUS Inc. -Product Development- Vagedesstrasse 19 40479 Dusseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 ...

Is there some reason that you do not want to use the Final Table SQL construct ? The following SQL does pretty much what you are lookin for: 1. A recursive sql to generate 100 rows 2. Insert into a table days_table 3. Use the final table to return ...

Hi there, I am using a CTE query to insert rows into a table. The output does not give the number of rows inserted. FINAL TABLE is also not allowed in this case, any thoughts how to get the rows inserted ? ------------------------------ Venkat Sundar ...

Dear all, forgive me if this question has been already answered in the forum. I am wriitng a SP in DB2 LUW V11.1 with SET ISOLATION LEVEL UR as a first statement and SET ISOLATION LEVEL RESET as last statement. What happen to the current isolation ...

Fascinating... I do hope they try and clear up the documentation here... Roy Boxwell SOFTWARE ENGINEERING GmbH and SEGUS Inc. -Product Development- Vagedesstrasse 19 40479 Dusseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: ...