DSXchange

Thank you for your reply. Yes, I meant not to create the file if SELECT returns nothing.
I will see if I can delete the file post-job, if the file only has 1 row (the column headers).

Thank you.

I have an Oracle Connector stage that SELECT from Oracle database, and write the result to a Sequential File.
How can I only write to the Sequential File if the SELECT statement returns something (if SELECT statement doesn't return anything, don't write to the Sequential File) ?
Thank you.

Thank you Ray

Agree

I fixed the warning by adding a Line Feed at the end of the file using Before Job subroutine EXECSH sed -i -e '$a\' /dev/inbound/MyFile_*.csv

Our DataStage parallel job has a Sequential File stage that reads a CSV file. This is a sample of the file content. Each row ends with LF (Line Feed - hex = 0A), except the last row has no LF. "Name","Currency","Description"LF "ABC","USD","ABC D...

Thank you all. This ExecSH command sucesfully moved the file to the archive folder, and add a timestamp in the front of the file name: for file in /dev/DataStage/myProject/source/TEST/MyFile_*.csv ; do filename=`basename $file`; mv $file /dev/DataStage/myProject/archive/TEST/`date +%Y%m%d_%H%M`.${fi...

Yes, that's it. Thank you Ray!!

How can I use the following EXECSH command in After-job subroutine ? The above code gives an error "sh: -c: line 1: syntax error: unexpected end of file"

Thank you

Thank you. This code does move MyFile_*.csv to the Archive folder and the file name in the Archive folder is MyFile_20180817.csv. mv #Directory_ParameterSet.$Dir_Parm#/TEST/#FileName_Parm# #Directory_ParameterSet.$Archive_Dir_Parm#/TEST/ Once the correct file is in the archive folder, can I rename/c...

I am using DataStage Designer 11.5. I need to move a file to an archive folder, and add a timestamp in front of the file name. The current folder, archive folder and file name are parameters to the job. #FileName_Parm# is MyFile_*.csv #Directory_ParameterSet.$Dir_Parm# is /dev/DataStage/myProject/so...