Thread: Multiple row insert

Quote: Originally Posted by db2girl There is "insert buf" bind parameter for "buffered insert". I've only used it with import in a multi-partitioned env. Don't know if this is similar to multiple-row insert on z/OS. He want to insert from the AREA which is not a possible. He can create a file and use LOAD utility to solve this problem. Lenny

The above was static SQL. No multi-row insert as on z/OS is available in DB2 LUW for that API.

No, it does not exist for DB2 for LUW. You will have to as IBM if it will ever be implemented. Andy

Hallo, I have a question about DB2 9.1.6 for LUW: For DB2 UDB V8 for z/OS, an application program can issue a multiple-row insert using static SQL like this: EXEC SQL INSERT INTO DSN8810.ACT (ACTNO, ACTKWD, ACTDESC) VALUES (:HVA1, :HVA2, :HVA3) FOR :NUM-ROWS ROWS END-EXEC. I checked the manuals for DB2 9.1.6 for LUW, but I didn't find anything similar... Does a feature like this exist for this DB2 version? If not, will it be available in...

Yep, like I have always said, UNIX is only 30 years or so behind z/OS

There is "insert buf" bind parameter for "buffered insert". I've only used it with import in a multi-partitioned env. Don't know if this is similar to multiple-row insert on z/OS.

Multi-row insert is supported. Checkout the docs Multi-row SQL operations with the IBM Data Server Driver for JDBC and SQLJ In case of CLI it is supported via SQLBulkOperations API SQLBulkOperations Regards, Sawan Gupta

Quote: Originally Posted by stratmf Hallo, I have a question about DB2 9.1.6 for LUW: For DB2 UDB V8 for z/OS, an application program can issue a multiple-row insert using static SQL like this: EXEC SQL INSERT INTO DSN8810.ACT (ACTNO, ACTKWD, ACTDESC) VALUES (:HVA1, :HVA2, :HVA3) FOR :NUM-ROWS ROWS END-EXEC. I checked the manuals for DB2 9.1.6 for LUW, but I didn't find anything similar...Frank Yes, static SQL does exist in DB2/LUW, just...