DSXchange

req needs duplicate records in target table. if it requires remove index on the table.

create shl script file with below steps 1) define variable and assign count Val1=`wc -l < /auto/temp_file.txt` 2) define param list and with this veriable ParamList="-param ABCD=$Val1" 3) call dsjob pass the paramlist dsjob -run -mode NORMAL $ParamList <PROJECT> <JOB NAME> 4) define parame...

did u get solution.

Hi,

How the wierd data is allowing to load in source table even the column defined as date.

I think sequence number will give increment number's to all records. but u need for every record u have to start from 1. if it one time load or incremental load...

as kandyshandy said use stage variables.