DSXchange

shrey3a You should have code for all routines and jobs except one GenHtmlFromSqlRtn. It should be easy to change the extension from html to htm in the documents produced. * ----------------------------------------------------------------- * write documents to disk * ---------------------------------...

I am not sure I want to support every version of DataStage. The order seems to change between 7.1, 7.5 and 7.5.1A. Thats what I tried to explain. Serks as Ray man would say. It is close enough that most of us can make it work. Little bit tought to debug though. Thanks for the feedback. I think Tony ...

I almost forgot. You need to copy the files from your server and the bmp files into one set of directories so they all work together. If you change your files from bmp to jpg then don't forget to edit the html and change bmp to jpg.

KgdGenHtml is group of DataStage jobs that can document a whole project. It calls a routine Tony at IBM wrote. I added logic to to run DSJobReport for every job. I also added a menu page to link to each job page. I also added logic to document each routine so you have a complete picture. This job re...

EtlStats does not have source and target tables. This can be done in DwNav and MetaStage. I think both are limited to accuracy of the metadata. DSJobReport subroutine will also print columns which belong to the link. All of these print SQL which belongs to a link. This is the real issue. There are 3...

ray.wurlod wrote:ErrCode = DSSetParam(hJob, ParamName, ScrOutput)

Is usually what I have to do. You could also use field().

Like Ray says I would look elsewhere. I would make sure LONGNAMES is ON. Next I would reboot or stop and start DataStage so you know this project is in a stable state. I would change your statement to CREATE.FILE as well. I would expect you may have a space in your hashed file name or something like...

GenHtml is a group of jobs which document jobs as web pages. Do a search there are several posts about it.

Should be a FAQ.

Sandbox types should be skipped. Sometimes VC projects get skipped. Some customers have older obsolete versions of the same project that may have been corrupted or have too much garbage jobs.

The zipped option was commented out. Never tried it.

I modified DataStageBackup.bat to loop through anything that dsjob.exe could do that might be useful like SaveAsBmp. So DataStageBackup.bat became DSaveAsBmp.bat. This will save a BMP image for every job. This is used in KgdGenHtml for automated job documentation. I also posted one that would do the...

DataStageBackup.bat is a download from my tips page. I normally set it up in C:\DataStage. I also setup C:\DataStage\KimD\Backups and DataStageBackup.bat goes in C:\DataStage\Scripts. I then create DataStageBackupDriveDev.bat, DataStageBackupDriveTest.bat and DataStageBackupDriveProd.bat. I usually ...

This is easy with EtlStats. It can change any SQL statement into html with job GenHtmlFromSql.

It works fine on UNIX. You just have to get the DSX file on the DataStage server.

If you are on Windows then why not use a routine: * ----------------------------------------------------------------- * KgdParseDSX(Path, FileName, JobsToSkip, CatOnlySw, DebugSw) * Decription: Parse DSX File. * Written by: Kim Duke * ---------------------------------------------------------...