Page 1 of 1
Sequencer which echoes Paramater Name and Value to a file
Posted: Tue Feb 27, 2007 7:15 pm
by memrinal
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
Posted: Tue Feb 27, 2007 7:48 pm
by ray.wurlod
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.
Posted: Tue Feb 27, 2007 11:04 pm
by kduke
One of the tables in EtlStats is ETL_PARAM_HIST. This gets loaded along with the other tables. There is a job which can extract these values from previous job runs in the log files as long as there are not cleared.
Posted: Thu Mar 01, 2007 8:32 am
by memrinal
Thanks Ray,
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