DSXchange

The is a job included with EtlStats which will take a SQL statement like this and turn it into a web page and mail it as an attachement to any list of users you want. SQL can be run against uvlocal or any DSN you like.

We took the DatsStageBackup.bat script and did the samething. It exports from a list of jobs then imports and compiles. We manually copy all jobs in the final directory to a CVS directory and check them in. It also creates an audit trail by using the SQL Server command line tool to insert records in...

If not then let me know. Easy script to write.

EtlStats needs a different job for PX. Vincent modified to aggregate the partitions for a link. I haven't posted the new version which tracks the row counts at the partition level. It was an easy fix to make that happen. Anybody could do it. I could walk you through the changes to fix it. The extra ...

Buy PNav. Pay for itself the first time you use it.

I am not sure knowing a lot of this makes you a better DataStage developer. It probably helps more with admin. Most of this changes so much from one version of DataStage to the next that it helps less and less to know the internals. The future of the product is in PX anyway.

1. DataStage objects are parts of job like links and stages. UniObjects, I have no clue. DLL used to be called OLE objects. 2. DS sdk are examples of server routines. Yes, you can create your own. 3. DSEngine has many components. A lot are store in the bin directory. The parts that run a job are not...

I am pretty sure I posted all the dictionary items for this job and to do this. Do a search.

Why not download EtlStats. It does this for you.

Why not use

dsjob -report XML Project Job

Even if you can extract this from DS_JOBOBJECTS then you may not get what you want. If you are using user defined SQL then you may need to parse the SQL to extract the table naames. One of the jobs in EtlStats extracts the properties of custom stages. This is almost always where PX jobs store target...

They are stored in the ROOT record of DS_JOBOBJECTS in version 7 and earlier versions.

I think you want:

Field(YourColumn,"\",2,9999)

Ray is correct though EtlStats will get you close. At least get the data into tables.