Logic for DB2 sequence develop in Data stage
Posted: Wed Sep 08, 2010 12:40 am
CREATE SEQUENCE STEVE.SEQ_KEY_ACCTS
AS INTEGER
START WITH 1
INCREMENT BY 1;
CREATE TABLE STEVE.TESTSEQ LIKE NEG085_20090210.ACCOUNT;
INSERT INTO STEVE.TESTSEQ
SELECT * FROM NEG085_20090210.ACCOUNT ORDER BY SRC_SYS_ACCT_KEY FETCH FIRST 10 ROWS ONLY;
ALTER table STEVE.TESTSEQ ADD COLUMN NEW_SRC_SYS_ACCT_KEY INTEGER;
UPDATE STEVE.TESTSEQ SET NEW_SRC_SYS_ACCT_KEY = nextval for STEVE.SEQ_KEY_ACCTS;
Can any one help us regarding above logic for DB2 sequence develop in Datastage
Advance thanks for your help
Thanks
PARAM
AS INTEGER
START WITH 1
INCREMENT BY 1;
CREATE TABLE STEVE.TESTSEQ LIKE NEG085_20090210.ACCOUNT;
INSERT INTO STEVE.TESTSEQ
SELECT * FROM NEG085_20090210.ACCOUNT ORDER BY SRC_SYS_ACCT_KEY FETCH FIRST 10 ROWS ONLY;
ALTER table STEVE.TESTSEQ ADD COLUMN NEW_SRC_SYS_ACCT_KEY INTEGER;
UPDATE STEVE.TESTSEQ SET NEW_SRC_SYS_ACCT_KEY = nextval for STEVE.SEQ_KEY_ACCTS;
Can any one help us regarding above logic for DB2 sequence develop in Datastage
Advance thanks for your help
Thanks
PARAM