DSXchange

That is it. VC may not work that way but Designer still does. Not sure if that is a documented feature. Not even sure how I learned it.

Did I put you to sleep with my rant?

By the way it may take some time to figure out all that is in EtlStats but if you get it all working you will love it. You will not believe I give it away. I am sure at some point most of this will be included in some Stage product from ASCL. It should be built in. Some is in MetaStage now like row ...

Sure. I think there are several posts on these. The export files are Ds7.1. I am not sure you can use them on older versions. There are several directories you need to create below your project to make the jobs work. In the zip file there are files which go in these directories as well. Dir: KimD Sc...

You could use SQL if you are confident. I wrote a routine to create a standard full description. I would download it from my tips page and modify it. I think I also posted the code on here. So search for KgdFixLongDesc.

The DSEngine directory is usually the same level as the projects directory. So you can use: ../../DSEngine/bin/dsjob If you are on Windows then use "\". If you projects are not on the same directory structure then use a full path. /opt/Ascential/DataStage/DSEngine/bin/dsjob Find the path to your pro...

Do it in a routine. Nested case statements would be lots easier to read and modify later.

Most UNIX vendors recommend 2 to 3 times swap space as physical memory. the way UNIX works is that it doesn't start swapping until the available memory is full I do not think is valid any more especially on Sun Solaris. I do not think one process can grow beyond 2gb on most boxes. If you look at the...

You need else clauses on statements like WRITESEQ. So you can print some message of where it failed.

Routine names are stored in field 31 of the ROOT record of DS_JOBOBJECTS. This is not always accurate. This is the dependent object field. It also stores job names in sequence jobs. Field 32 is the dependent type. Here is something that will work. select DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBS.C...

You need to create a dictionary item or use EVAL.

SELECT EVAL "FULL.TEXT[1,20]" FROM RT_LOG123;

EVAL has several options to it where you can format it or name the column. Do a search. Ray has lots of posts using EVAL.

ADN has an example of the filter command using dsjob -report XML. You can download it and see how it works.

Craig We just upgraded from 7.1 to 7.5 and it worked fine in 7.1. It has a couple of fixes in 7.5 though. So it is improved. 7.5 will stop all jobs in a sequence now when yo stop the main sequence. No need for my stupid routine any more. Also my hack to set a parameter during a running sequence also...

I think most of your assuptions are accurate. I tried to match the status with what shows up in the Director. Here is that code straight out of DsWbMon. begin case case JStat = 0 JobStatus = 'Running' CanRunFlag = 0 CanResetFlag = 0 CanStopFlag = 1 case JStat = 1 JobStatus = 'Finished' case JStat = ...

Ds7.1 has restartable jobs. There are 2 checkboxes under job properties you need to check. The first is add check points so job is restartable. Check this. Also check the one below it about automatically handle objects that fail.

You might be able to just get the number by parsing the output with a field() function.

RowCount = field(OutPutA, " ", 1)