MVSFORUMS.com

madan777in · Beginner Joined: 07 Dec 2005 Posts: 12 Topics: 6

Hi ,

Could you please provide some example code or functionality to insert multiple rows into Table using Insert Arrays , Atomic function .
I want to load the table be correcttly calculated prior to the insert.when researched i came across get diagonistic function . But iam unclear with example provided .

Thanks

kolusu · Posted: Mon Aug 20, 2007 7:02 am Post subject:

madan777in,

Check this link

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/rinsr.htm

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

madan777in · Beginner Joined: 07 Dec 2005 Posts: 12 Topics: 6

Thanks Kolusu

madan777in · Beginner Joined: 07 Dec 2005 Posts: 12 Topics: 6

Koulsu, Thanks for your reply .. But I have problem in issuing this multiple insert querry n Spufi or Qmf . Iam end up with -803 (duplicate data )

For eg i used the query like

INSERT IN TABLE (C1,C2) VALUES ('123','TEST') FOR 2 ROWS;

SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID
BECAUSE INDEX IN INDEX SPACE IRPARF01 CONSTRAINS COLUMNS OF THE TABLE
SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS.

Please let me know how to check the Multiple insert querry in Spufi or Qmf .. Below is the querry given in IBM link

EXEC SQL INSERT INTO T1 FOR :hv ROWS VALUES (:hva:hvind) ATOMIC;

kolusu · Posted: Mon Aug 27, 2007 7:07 am Post subject:

madan777in · Beginner Joined: 07 Dec 2005 Posts: 12 Topics: 6

Yes - 803 is the reason for duplicate data inserted twice . but in real time thru program we wont get data has duplicate . Dupicate data was handled .

Please let me know(any eg) how this querry can be checked in qmf for 3 rows without any duplicate data .

EXEC SQL INSERT INTO T1 FOR :hv ROWS VALUES (:hva:hvind) ATOMIC;

Thanks ,

kolusu · Posted: Mon Aug 27, 2007 7:56 am Post subject:

madan777in · Beginner Joined: 07 Dec 2005 Posts: 12 Topics: 6

Thanks Kolusu .. Now iam Clear with your reply ..