DSXchange

Why not create a query which eliminates the dashes. DataStage can select from saved queries in Access.

Follow my link below my sig. On my tips page.

Most of these files are dynamic hashed files. They store the log for jobs and other run time information. How to access them directly is not supported by IBM. They created APIs to read from these. The dsjob command can retrieve a lot off this information.

Post your command line. Change passwords and user names.

One of the jobs in EtlStats.zip will send the log as email attachment. It is designed to send only jobs that fail. The source is included so you can modify it to send all.

That is correct. The batch file will run dsjob to get a list of jobs then run this command on every job. I forget the name of the bat file.

Do an exact search for JobAct and kduke as poster.

The data type is real important on stage variables. What is the data type?

This function has issues. Sorry.

Try just "decimal".

We have had issues with this as well. I have not used it with Decimal, only date and timestamp. We had to call it with double quotes and not single quotes. We had to leave second argument a string. isvalid("date", InLink.InColAsString) isvalid("timestamp", InLink.InColAsString) Both seem to work fin...

dsjob -report can be run from UNIX prompt. It also has a XML option.

Don't think the variables are allowed. I think you need a pure SQL statement which return rows.

You may be counting the links as well. There are 2 links for most stages. Post your SQL and we might be able to help some more.

I am not sure but I think field 8 on CCustomStage tells the real stage type on PX jobs. If that does not work then I need to look it up.