Sequencer which echoes Paramater Name and Value to a file

[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

[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.

[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.

[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