DSXchange

You confirmed that it won't work to me. Thanks!

In JobControl you can use DSGetJobInfo(DSJ.ME,DSJ.JOBNAME)

Sure you can do that - read the list of mail ids and also send the emails all from the same DataStage routine. There is not reason to doubt that it can be done. I don't think you are going to have someone post a complete solution, but if you attempt to write this and encounter problems then you will...

Yes.

Does you windows installation have MKS Toolkit or other unix command emulation installed? If so, you can use the commands "wc -l" and "head" to remove the last line from a file. If not, you can always write a DS job to perform the same functionality.

Within a DataStage BASIC routine you use the commands OPENSEQ, READSEQ and CLOSESEQ for sequential files.

Hello Sidharth,

that is good question indeed! I've not tried it but am fairly sure that this won't work. Have you tried to see what happens when you do this?

Just as Ray stated, I always have my first code line in every program EQUATE ProgramName TO "name-of-routine" , and usually the second line is EQUATE Version TO "x.x.x" . I thought the stack might contain an easily accessible name of the current routine, but I've done some checki...

Per the upgrade/install guide, make sure of the following (particularly #2): 1 Install DB2 and make sure it is working properly. 2 Grant the DataStage users SELECT privileges on the system tables syscat.nodegroupdef, syscat.tablespaces, and syscat.tables. 3 Make the file db2nodes.cfg readable by the...

If you write a routine called "MyRoutine" then do you want some sort of a DS function call which will return "DSU.MyRoutine"? If that is what you are asking then I think it might be possible, but I'm not sure it can be done. It might depend upon how the routine was called.

Yes, declare it with length of VarChar(200) and put a LEN() check when you truncate to 50.

I made a mistake in my first post, DataStage always thinks and works in terms of characters; but with NLS installed a character can be more than one byte.

You declare VarChar(50) for a 50-character field. The rep

Vijay,

The datatype you can use in DataStage is VarChar() and DataStage "thinks" in terms of characters unless you have NLS installed.

Welcome to DSXchange, Sudhindra.

This thread comes close to answering your question. I got it by entering "sequence list jobs" in the forum's search function.

The easiest solution is to activate your deadlock daemon; this will ensure that no matter what happens the locks will be cleared automatically and regularly (the default is 15 minute intervals). There are hundreds of posts on this subject, so instead of answering this again I recommend you use the s...