DSXchange

A FILELOCK does exactly what it says it keeps other people from updating the whole file. You almost never need a FILELOCK.

When you post your code please use the code tag to save indentation. Do not use FILELOCK. You want to use record locks. If you change the routines in the SDK then please rename them as well. When you upgrade then these will be overwritten. A READU was in the original routine. This would allow you to...

Try exporting to a local file. It maybe the network file.

The script is more to show how to do these type of things on more than one job. Also to show the exact syntax. I think examples are more powerful training tools than any other teaching tool.

Vincent you should post your additions.

I still think this is ugly. I think on a certain level they want to know what is an elogant solution and not ugly. I think the trade off is mutiple records versus a single record. It is easier to compare previous values if it is stored all in one record. How often is this a requirement in your repor...

As far as how to use other parameters then use sequences they will know what jobs have what parameters.

This has been covered a lot. Do a search for KeyMgtGetNextValue. You need to do an exact search. In routines there is a folder called sdk. Under it there is KeyMgt. This routine is under it. It reads and writes to a hash file named SDKSequences. You need to seed this with a job. This job will need t...

You can download DSaveAsBmp.bat on my tips page. It will create a bmp image for every job in a project. It is also available on ADN. I also posted one to get a report on all jobs.

Please post your solution.

On some UNIX machines it is possible to allow or not allow redirection into ftp. The .netrc is for inbound ftp. I would try it first.

Here is a shell script I use. #!/bin/ksh ## # Email.ksh jobname file1 file2 subject # Written by: Kim Duke # To use in DataStage: # SH Scripts/Email.ksh GenReport KimD/Sql2Html/RtLog1.html Test Log ## if [ $# -lt 3 ] then echo "Usage: $0 kim|all jobname file1 file2 subject" exit 2 fi case ...

The log is stored in a hash file named RT_LOGnnn where nnn is the job number. Do a search there are lots of posts on how to retrieve this data.

Ramesh A COMMON block is a way to save a set of variables and their values between calls to a routine. Therefore it saves time because complicated values or something that takes time like opening a hash file does not have to be done over and over. I would use row buffering. I would try to replace CO...

The main function of hash files is for fast lookups.

After I process input1 using DS Job -wait -jobstatus

There is no -jobstatus in code posted. I also think that DataStage needs time to clean up between jobs. You need to sleep a few seconds between jobs.