DSXchange

Do a search for GenHtml. This is a series of jobs which extract this information into HTML documents. It is easy to cut and paste from these documents into whatever you like. The Reporting Assistant included with DataStage in the Manager will also extract this information into Access database named ...

If you download EtlStats then you get several jobs which extract job names, job categories, link names, link types which you can look at and see how to ake this metadata and make something useful with it. Once you get these jobs there is a whole series of reports written in SQL to get things like jo...

Do a search for EtlStats. It has BASIC code included to extract row counts and store them in tables. It also has examples of using dsjob to gert the same thing. You can download all the jobs n my tips page below.

Thats what I meant. Post code here. DSX on ADN. Not very clear.[/img]

You will have to hack the table name. Each stage type is stored in OLETYPE. You SELECT DISTINCT OLETYPE FROM DS_JOBOBJECTS; to see which ones you have. You need to figure out which field stores the table name. You can guess by doing EVAL "@RECORD<1>" AS TABLE_NAME change the 1 to 2,3... until you fi...

It is all job control code correct? If so then post that. You could post the DSX on ADN (Ascential Developer Net).

I would agree with that.

This is just more direct. Too many layers inside calling another routine when it is just 2 lines of code. Keepin it simple smarty.

I would not call a routine. I would:

Post it. We helped you then help others by posting the solution.

CRC32

How about one for routines?

He is in Arkansaw not India. We had 40 at BellSouth.

You have 25 DataStage developers?

Thanks