DSXchange

Arnd is correct. If you put a print statement in your routine then it prints in the log.

The parent job is stored in the log. I think it is the first or second record in the current grouping. Each run has a group of log records associated with it. The invocation id is field 7 or something like that in the log. I could look it up if you cannot find it.

Roy

Teej went to the dark side and was never heard from again.

It would be easy to write in a routine because you need a prototype on the DSN you want and then just append it to the file. You need a lot less in each project. I am sure it could be written in a few minutes. Maybe tomorrow.

KgdGenHtml does exactly that. Run KgdGenHtmlJobDocs and set CategoryToDoc to the sequence name you want to document. It will build an index page and link to all the job pages produced by JobReport. Here is an example m I used this to document itself. Here is another example m when I used to document...

This is probably doable. I have VB program which I can run any TCL command with. It is part of DwNav. It runs standalone though. I post with my version of DataStageBackup.bat. It does a UNLOCK READULOCK in the UV account before it exports all the projects. This is a dangerous command if you do not u...

I posted a routine to do this called KgdEstimateDiskSpace. If you cannot find it then let me know. You need to import your metadata. You need to know the number of rows for each hash file. This routine needs to know the id for DS_METADATA which is the table plus the folder like Saved\Hashed\MyHashFi...

If you want examples then download EtlStats.zip from my tips page. There is a job named DSJobReportDb which runs dsjob -report XML. This is output to a flat file and then processed to get start and end times, row counts by link name and parameter values. This should help get you started with XML. Do...

Thanks Vincent

This is a Microsoft driver. You need an Oracle driver to connect to Oracle. Load the Oracle client first.

The jobs I wrote do use JobReport. Before the new version came out I modifed the output of JobReport and adding the html to display bmp files created by /saveasbmp option to the Designer. Included is a DSaveAsBmp.bat which will loop through and create bmp files for all jobs. These bmp files are huge...

This is exactly why I wrote DwNav. I use it to help me understand the ETL created by previous consultants. That was the main reason for writing it. Most of the time you do not have access to these people. What I found was most of the time you need just source and target tables. DwNav can browse thes...

You cannot rely on any of these to be consistant. The table is filled in column generated queries and fully generated but not user defined. We tend to copy jobs and use them as templates. If these fields are filled in meaning at some point this stage was column generated or fully and switched to use...

* is a comment line. Also BASIC if then else is different than one used in a transformation. In a transformation it is treated as a single line statement therefore there is no end like a multiple line if then else.

if x = 1 then 10 else 20

This will assign a 10 or 20 to column in a transform.

The assignment statement is confusing. x = 12 if x = 12 then y = 1 z = 2 end else y = 2 z = 3 end You can also do C++ type assignments: x =1 x += 5 * x now equals 6 x -= 1 * x now equals 5 x := 2 * x now equals 25 because it is the same as x = "2" : "5" * : concatenates strings t...