DSXchange

I do get row counts at the end of a sequence. Much cleaner and easier. Unless you need row counts to make a decision like send an email if more than 1000 rejects then wait till the end of the sequence.

Jil

Most of these developers have been paid lots of money to develop these documents. Only IBM might give them to you if they thought that somehow they would make money later by doing so.

I like both Abort and DSLogFatal(). The sequence should catch either if the right box is checked. It is a personal preference. Ray and Arnd are usually correct in the sense things work better if you avoid these 2 ways to stop a job. Ray likes things neat and orderly. I think that is pretty wise.

DwNav will show you these relationships. This link http://www.dsxchange.com/viewtopic.php? ... ParamNames will also show you.

The t (text bit) works differently on different UNIX platforms. Sometimes you can see an s bit set as well. Like drwsrwx--- or drwxrws---. The later is supposed to allow anyone in the group to delete files even though they do not have permission to do so. This directory should be owned by the DataSt...

Andy very well done.

Mainframe is probably 1. This is field 6 of DS_JOBS. The easiest way to get this value is:

JobType = TRANS("DS_JOBS",JobName,6,"X")

It is possible to compile a routine with warnings and it will not be cataloged. Try to compile the routine and see if you get a warning.

Excellent, thank you.

If you want all job names then NAME NOT LIKE '\%' would work.

I posted a routine called KgdIsJobSequence(). Look at it to create what you want. You may need to figure out a new way to calculate what is a parallel job. This routine uses what is in field 40 of the ROOT record in DS_JOBOBJECTS. I think you can look only at the DS_JOBS record which would greatly s...

I understand what you mean but I was not talking about dumbing down my solutions. I don't think my solutions are simplistic. I do think my solutions are streamlined and clean in their design. I don't like over engineered or overly complicated solutions like Ray was talking about. There is a way to ...

Buzz, Buzz, Buzz. Lots of buzzwords. There is value in these books but why is it that the people who can quote from these books build terrible DataStage jobs? Simple solutions to complex problems are sometimes very beautiful. I think a lot of developers get lost in these books. Practical solutions w...

He is not human.

I wish my confusion would clear up. Think Craig knows the cure?