Insert a Row_number into table

useit · Active User Joined: 05 Oct 2006 Posts: 152

hi,
To avoid the duplicates i have to insert a row_number into the table. could someone please help me achieving this?

EXEC SQL
insert into TBL1
select
request_no,
seq_no,
account_no
into
:host-request-no,
:host-seq_no,---------------------> row_number
:host-account-no
END-EXEC.

I need to populate the seq_no as Row_number in the above Query.please help me in this regard

Regards,
useit

Nic Clouston · Posted: Tue Sep 19, 2017 1:58 pm

So you read the highest row number from some control table/data set, add 1 insert the row and update the control data. What is the problem?

Rohit Umarjikar · Posted: Tue Sep 19, 2017 5:34 pm

Read
www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sequencereference.html