DSXchange

I have a job that reads from a CSV file. The problem is that this file has a blank line at the end of the file. Please let me know how to take care of this.

Thanks in advance

I would try to remove the line using shell commands before the DataStage job starts. If it truly is blank, then "grep "," should discard the line. Since it is a csv file all other lines would be output.

You can include a constraint in the job. This is just in case you do not have this in the future.

Alternatively you can use OS commands to perform the same.