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/source
#Directory_ParameterSet.$Archive_Dir_Parm is /dev/DataStage/myProject/Archive
I use After-Job Soubroutine EXECSH command to move my file (with wildcard asterisk) to an archive folder:
Code: Select all
mv #Directory_ParameterSet.$Dir_Parm#/TEST/#FileName_Parm# #Directory_ParameterSet.$Archive_Dir_Parm#/TEST/#FileName_Parm#
Code: Select all
mv /dev/DataStage/myProject/source/TEST/MyFile_*.csv /dev/DataStage/myProject/Archive/TEST/MyFile_*.csv
When I move the file to the archive folder, I also need to add a time stamp in the front of the file name, for example: MyFile_20180817.csv to 20180817_1057.MyFile_20180817.csv:
Code: Select all
mv #Directory_ParameterSet.$Dir_Parm#/TEST/#FileName_Parm# #Directory_ParameterSet.$Archive_Dir_Parm#/TEST/`date +%Y%m%d_%H%M`.#FileName_Parm#
Code: Select all
mv /dev/DataStage/myProject/source/TEST/MyFile_*.csv /dev/DataStage/myProject/Archive/TEST/`date +%Y%m%d_%H%M`.MyFile_*.csv
Thank you.