DSXchange

Hi

We need to get the list of modified datastage jobs in a text file. Is there a command to list jobs modification dates?

Search for DS_AUDIT.

The DS_AUDIT hashed file contains this information. You could get this information by executing the following command from TCL:

LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER

If you want to put this into a text file, you could write a Server job to read this file and write it to a text file. The "DTM" (date-time-modified, position 5) column and the "MODIFIER" (pos 6) column are both multivalue fields.

Can I access DS_AUDIT through a bat script?

You can execute TCL commands from .bat scripts and get that data. CD to your project directory and then "uvsh.exe LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER NO.PAGE". The output goes to stdout and can be processed from your .bat script.

It might be better to use BY.EXP.DSND rather than BY.DSND.

Redirect the output of the uvsh.exe command into a file as required.

Assuming DSND = descending, but "EXP"?

Exploded. DTM is a multi-valued field. The equivalent SQL query is

Ah... cool, thanks.

Hi all,

Thanks for the inputs and sorry for the delayed response.

Now i need help in exectuting these commands in a batch file then getting the result in a text file.

I can do it in Unix like -

$ path/to/uvsh/uvsh "select query" > my_text.txt

but how do I do this in a batch(DOS based) file?

Same way.

Craig,

I am unable to find the path to uvsh on my system. Please help me on that. I tried echo %DSHOME% but its not set

Did you try a simple Windows search? Nowadays I would look for (and use) "dssh" rather than "uvsh".

I searched for both uvsh and dssh but I couldn't find them.

Are you searching on the DataStage server? Do you know where your DSEngine directory is? There should be a "bin" directory under there with all of the appropriate executables in it, I would think.