data insert issue

[hargun]

hi i have question my job design is as follows:

Code: Select all

seq file..................> 
                                       merge stage..............>odbc(DB2 database1) 
odbc......................>        .                                               SVR.PORTF 
                                       . 
                                       .reject 
                                       . 
                                       . 
                                   odbcs (DB2 database)SVR.PORTF 

in seq file i have columns
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.

[chulett]

Just so you know, posting in all caps is considered SHOUTING. Please don't shout.

[Devendrudu]

hi, first tel me which one is master? and if seq file is master how can u get these fields(account, Collatral, markt_val amt,PORTF_NM) in reject

[hargun]

sorry craig......

i really apologize for putting post in capital letters i have changed to lower case can you please reply me know

[hargun]

hi dev you are right if master is seq file how can i get these fields..........actually master is odbc and fileds now in reject link are portf_id,portf_nm and portf_eff_dt.....

so could you please tell how can i increment the portf_id with one and insert to the reject one target database .

please reply me.