DSXchange

The easiest solution is to use a server job or a "BASIC Transformer" stage in a parallel job. Simply add 0 to the number; DataStage BASIC returns the shortest possible string for each arithmetic result.

What value - precisely - do you have in the Table field of your ODBC stage?

No. I suspect the target table. Make a copy of the job with a Sequential File as the target. What rate do you get from that?

Is there another machine on the network with the same IP address as your DataStage server machine?

Assuming you're referring to class DX436, can you please give the page number (and whether it's in the notes or the lab manual)? I'll try to track it down.

Welcome aboard. All DataStage processes are background processes, so INPUT and PRINT statements don't really do it. However, well spotted that field #6 of the dynamic array returned by the STATUS statement can return the size of the file. The following function can be called from a Routine activity....

It will always try to use all eight. Dump and inspect the score to see what is actually executed, and where. Circumstances that may inhibit use of all nodes include sequentially executed stages and stages constrained to execute in node pools with fewer nodes than all.

Never, EVER, delete hashed files in the Repository. Repair them, purge them, clear them, but never delete them.

1. Yes. Alternative is delete entries more than x days old.

2. Purge job logs. Clean up unneeded files in UVTEMP directory.

3. No.

Then please accept this gratuitous advice. This is a forum for professionals. We prefer - and, indeed, expect - a professional level of communication. Do you use SMS-style abbreviations in your work documentation? No? Then why do so here? You can write good English, please do so. If nothing else, it...

If you have a Failed trigger this takes precedence over the automatic handling. So that answers your second question. If you want to abort the sequence you can include a Routine activity that invokes the SDK routine UtilityAbortToLog in the stream from this trigger. You could also, if desired, inclu...

May I ask whether this is a standard IBM training class, or one that's been developed independently of IBM? Just curious.

That's fine, allow the "is the DB there?" job to abort. Have its triggers handle the abort condition, only proceeding with subsequent processing if the database is available. Particularly for this job's Job activity, set "do not checkpoint run" (so that it executed always), and "reset if required, t...

The log hashed file for job number 1917 has become corrupted.

Search the forum for other occurrences.

The quick fix is to clear all entries from the log.

DataStage expects to import from COBOL FD files on the client - the reasoning is that they are most likely to have been emailed to the DataStage developer. So search on the client machine - put them somewhere with a short, easily-remembered pathname, such as C:\COBOL_FD Tip: When importing from a CO...