Hi,
I have an input file whose number of records keep on varying. I need to capture these number of records and assign it to one column. how can I achieve this?
file count
Moderators: chulett, rschirm, roy
Pass the value of this command as parameter to your job and assign it to the target column
Code: Select all
wc -l < File
You are the creator of your destiny - Swami Vivekananda
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 parameter in data stage job
5) assign job parameter to column.
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 parameter in data stage job
5) assign job parameter to column.