Code: Select all
seq file..................>
merge stage..............>odbc(DB2 database1)
odbc......................> . SVR.PORTF
.
.reject
.
.
odbcs (DB2 database)SVR.PORTF
account, Collatral, markt_val amt,PORTF_NM(account:collateral)
In odbc i have cloumns
PORTF_ID,PORTF_NM,PORTF_EFF_DT
i am merging seq file with odbc(master) based on PORT_NM and if match found result going to target database1 and If not found then from reject link do an insert and increment port_id with one
After merge my all record goes to reject by taking odbc as master so how can i increase PORTF_ID with one.
please tell me how i insert mAX(PORTF_ID) +1 to reject link database.
i didn't get any logic please reply me.