Hi
As a project requirement I need a DS sequencer which echoes all the parameter name and values to a file when the sequencer is run.
Please provide pointers about how to achieve the same.
Thanks in Advance.
Mrinal
Sequencer which echoes Paramater Name and Value to a file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's in the first event in the job log. You can capture this with the DataStage API or with the dsjob command, and direct the information to wherever you will.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks Ray,
Resolved it using dsjob command with the following script
Resolved it using dsjob command with the following script
Code: Select all
dsjob -server ${ServerName} \
-user ${USERID} \
-password ${PASSWORD} \
-logsum \
-type "STARTED" \
-max 1 \
${PROJECT} $1 > ${FilePath}/FileName.log
StartID=`head -2 ${FilePath}/FileName.log | cut -f1 `
echo ${StartID}
dsjob -server ${ServerName} \
-user ${USERID} \
-password ${PASSWORD} \
-logdetail \
${PROJECT} $1 ${StartID} > ${FilePath}/ActualLog.log
grep '=' ${FilePath}/ActualLog.log | grep -v 'DSJobController' > ${FilePath}/Parameter.lst