Hi,
I have a requirement to execute the Unix command and pass the value the next JobActivity
In the Execute command how do I pass the two unix commands
awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/' #ps_EDW_StdHrs.p_Source_Dir#/*/#ps_EDW_StdHrs.p_Source_FileName# | cut -d"|" -f8,9
Here I read the file and extract only the column 8th and 9th
But Execute Command is not accepting the Parameter in between the Unix command. Could some one can help how to handle this requirement?
Execute Command Function
Moderators: chulett, rschirm, roy
Execute Command Function
Thanks,
Avunoori.
Avunoori.
You can print the eight and ninth field from awk
Code: Select all
awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/ { print $8 FS $9 } ' #ps_EDW_StdHrs.p_Source_Dir#/*/#ps_EDW_StdHrs.p_Source_FileName#
You are the creator of your destiny - Swami Vivekananda
Use exit command
Code: Select all
awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/ { print $8 FS $9; exit } ' #ps_EDW_StdHrs.p_Source_Dir#/*/#ps_EDW_StdHrs.p_Source_FileName#
You are the creator of your destiny - Swami Vivekananda