file count

[agpt]

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?

[anbu]

Pass the value of this command as parameter to your job and assign it to the target column

Code: Select all

wc -l < File

[agpt]

thnx anbu,

can u pls tell me how do i exactly make parameter out of this command? is it using exec command stage?

[anbu]

Either you can use Exec stage

Or

If you are using unix script to call dsjob, then you can execute the command in your unix script and pass it as parameter to the job.

[agpt]

And what options i need to set to specify that this particular value would come at run time from parameter?

[sivanagu]

did u get solution.

[agpt]

did u get solution.

not yet

[sivanagu]

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.