Conditional execution of job

[prasannakumarkk]

I need the record count in a file. Yes it creates a empty file when there is no record.

Am saying we need not take record count, i was explaining check whether there are any contents in file
Like head command in unix, guess more +1 <file> will give first few lines of file. So in the trigger expression we can check the output of the command executed. If there are content trigger success link.

[sudha03_vpr]

You can probably check the wc-1 (word count) of the file and use this condition in Custom Conditional -> Trigger tab

convert(@FM,"", exec_filesize_isst.$CommandOutput) > 0

This means if the file size is greater than 0 it would trigger the subsequent job.

[priyadarshikunal]

I think we are waiting for the OP to check if the MKS toolkit is present and unix commands can be executed on that server.

From what I know, all 8.x DataStage server (PX) (even client) comes with MKS toolkit and they did not even scaled it down till 9.1, where it relies mainly on native calls instead of MKS toolkit but MKS Toolkit is still there.

[suja.somu]

Thanks everyone for your help.

I am able to run the unix command, so it means MKS toolkit is installed.

I close this post, marking as resolved.

[chulett]