MVSFORUMS.com

shailesh · Beginner Joined: 30 Jun 2006 Posts: 3 Topics: 2

hi i have a cics+db2 program.
i have an list of acnt names on screen defined as an array of length 10.
if user updates then names need to be inserted into table
insert query fails while i give
insert into xxxx (number,......)values
(ws-numbr(ws-array)......)
suggest me if any ways to do

ofer71 · Posted: Sat Jul 01, 2006 10:54 pm Post subject:

Will you please elaborate about 'insert query fails'? Do you get any SQL error? CICS abend?

And by the way, INSERT can't be a query.

O.
________
XM Falcon

kolusu · Posted: Sun Jul 02, 2006 2:00 pm Post subject:

shailesh,

You cannot insert array values as different rows in a single sql statement. You need a loop to insert the array values 1 by 1.

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

shailesh · Beginner Joined: 30 Jun 2006 Posts: 3 Topics: 2

I got act names as map fields defined as an array of 10 and need to be populated from the table.
If I do the changes then the new values needs to be inserted into the table .
Duplicates must be ignored. Is there a way other than sorting the entered
values and comparing with original ones.