DSXchange

Folks should be encouraged to search for answers. There are many questions that get asked over and over. Today's one on difference between two timestamps is just one example.

There are four fundamental I/O statements in either case. To work with sequential files: OPENSEQ READSEQ WRITESEQ CLOSESEQ To work with hashed files: OPEN READ WRITE CLOSE For sequential files, you may need to check the value of STATUS() if the OPENSEQ statement takes its ELSE clause (if zero, you'v...

This count is rarely accurate. Today it said I had 11 when, in fact, there was only one. Can you please check it out? It always overestimates.

I've been doing some work on an Etch-a-Sketch, but it keeps rebooting when inverted! Grey screen of death?

It might be a useful thing to provide guidance on when to post to the Parallel Extender foum and when to post with job type = "Parallel" to the DataStage forum. As I envisage it, the Parallel Extender forum is more about configuration of the Orchestrate engine, configuration files, environment varia...

An environment variable only lives as long as the process that creates it. So this is not a viable approach for preserving a last value, as it is almost certain that the next execution will not run in the same process. You need a more persistent form of storage (that is, disk). You CAN set the value...

You don't need the rows with NULL in col2. The documented behaviour of DataStage reference lookups in server jobs is to return NULL for every column defined on the reference lookup link (and to set that link's NOTFOUND link variable) in the situation where the lookup fails to return any rows.

Hard copy documentation comes at a price mainly to cover printing costs. SAVE THE TREES! Get a DataStage CD from somewhere - even Ascential!
It's not the software that costs, it's the licensing!

Right now we are trying to resolve an issue with Ascential, in which they assert that ANY screen shot is their copyright and/or intellectual property. Negotiations have been taking place (with huge hiatuses on their part) since last May.

It is possible, but there is no function provided for doing it. Such a function would embed knowledge of the internal storage of job design and run time configuration, which is not in the public domain. So, while it is possible, assume that it isn't, use job parameters, and interrogate the parameter...

The *.IMF file (INTEGRITY meta file) contains table definitions and perhaps definitions of procedures that others have created. Have you imported it? That should be your first step - there's an Import option in the INTEGRITY menu. When you build a procedure, you specify the input and output file nam...

Notice how all the "gurus" are shying away from mention of the GCI, making mystic signs to ward off the evil eye, and so on? There are many dangers in using the GCI improperly, not least being that you can totally foul up the way that DataStage works if you are not extremely careful. You end up rebu...

1. It seems, from the error message, that the temporary VOC pointer name (&FOLDER&) is hard coded. Therefore, an attempt will be made by the second process to create something that already exists, and that second process will encounter the lock situation. 2. Unlikely that the locks would be held aft...

COUNT DS_JOBS WITH @ID LIKE "1N0N" This UniVerse (DataStage Engine) command counts the integer keys in the DS_JOBS file. This is the total number of jobs that you have. It does not differentiate job type; this was not part of your original request. To execute this from a UNIX shell, you need the uv ...

Heck, no! I'm self-employed. But others get vacations (or so I'm told).