DSXchange

Remove the Terminator.

If for some reason you still need the link but need to to do 'nothing', send it to a Sequencer.

Yes, you can certainly use SQL to get the category of a job if you prefer:

I didn't mention the database answer because of this:

thiru wrote:I do not want to use a Merge stage or load the sequential file into database and perform a query

Ummm... Step 2?

Yes and we leave it that way, handling all Oracle DATE fields as Timestamps in DataStage. This gives one explicit control over the time portion and between the generated SQL in the OCI stage with a 'standard' set of Oracle date handling routines in place you will never have a problem handling them a...

We're on H-PUX here and 'rebooting' DataStage is a pretty rare thing, and is only done 'when needed'. And that would tyypically be when things get really jammed up and we start seeing the behaviour Ogmios mentioned.

I can only remember needing to do that about 3 times in the last 4 years. [shrug]

Are any of the dates null? All it takes is one null coming into the Aggregator to get a null result out the other end.

Only the ODBC and UV stages support 'multi-row result sets' - can you use one of them?

Create a Sequence job and schedule it to run every Sunday via Director. Create and run a routine first that checks to see if the current Sunday is the first Sunday in the month and only trigger subsequent jobs if the routine says to. We've done things like this in the past and they are fairly easy t...

Using $ENV in the Administrator sets it to the current value of the variable in 'the environment', which can include NULL if it is not currently set. Using it allows you to define it for DataStage without immediately changing the value in every existing job. So, to not change the value anywhere but ...

These kind of problems are usually Oracle client related, certain releases are more 'buggy' than others and can seem to be working fine until one job triggers it. However, other factors can come into play. So...

What operating system?

What exact version of the Oracle client are you using?

A couple of questions...

Have you read the chapter on the stage in the Parellel Job Designer's Guide? What are you attempting to 'encode' or planning on using the stage for?

As Ken notes, the idea that you have no 'softcopy manuals' is simply incorrect. You can access them from the Start menu or you can drill down to where they live via Windows Explorer. They are all are in pdf format in the 'Docs' directory under your main client installation.

4-3-5

Because you have it as a literal - inside quotes. How about this instead? strshell='' ToFile= '' strshell = SOURCE_FILE_DIR: '/recordcount.sh ' : TABLE_NAME Call DSExecute("UNIX", strshell, ToFile, SystemReturnCode) If SystemReturnCode = 1 Then Ans=1 Call DSLogInfo("Job Ab...