Search found 53125 matches

by ray.wurlod
Fri Jan 27, 2012 1:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Understanding node config file and degree of parallelism
Replies: 5
Views: 1815

Ask your architect for proof of the assertion, preferably with a reference to some reputable documentation.
by ray.wurlod
Thu Jan 26, 2012 5:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Logic
Replies: 7
Views: 2129

Please explain the logic that would yield your expected result. I can't figure out a single rule based on your example.
by ray.wurlod
Thu Jan 26, 2012 3:03 pm
Forum: General
Topic: DSJOB.exe not starting the job, no error message received
Replies: 8
Views: 3163

ERRORLEVEL is a shell variable that reports the success or otherwise of a command. Immediately after the dsjob command completes issue the command

Code: Select all

echo %ERRORLEVEL%
A value of 0 indicates success, any other value indicates a problem.

This is standard Windows shell programming technique.
by ray.wurlod
Thu Jan 26, 2012 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Char Datatype for fixed width files
Replies: 2
Views: 1038

Yes, because the Char data type exactly describes the fixed width fields.
by ray.wurlod
Thu Jan 26, 2012 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Send fatal message to log in the parallel routines
Replies: 0
Views: 1152

Read the Programmer's Guide, in which there are examples of how to use the classes in the DataStage API.
by ray.wurlod
Thu Jan 26, 2012 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage - Reject the record with Lookup Success.
Replies: 6
Views: 2398

You can have any stages you like downstream of the reject link (therefore you don't need another job). If you don't need the successful lookups, run them into a Copy stage that has no output links.
by ray.wurlod
Thu Jan 26, 2012 2:54 pm
Forum: General
Topic: DSJOB.exe not starting the job, no error message received
Replies: 8
Views: 3163

What is the value of ERRORLEVEL after the dsjob command?
by ray.wurlod
Thu Jan 26, 2012 2:51 pm
Forum: General
Topic: Char(254) value for @FM
Replies: 5
Views: 3926

Oops! Char(32) is space. (Craig's mixing it up with its hex representation 0x20, which you might use in APT_STRING_PADCHAR environment variable.)
by ray.wurlod
Thu Jan 26, 2012 2:46 am
Forum: General
Topic: paramerising a jobparameter
Replies: 6
Views: 1368

If, on the other hand, you ask whether it is possible legally to change the value of a job parameter once the job is running, the answer is no. Therefore, you can safely assume that the job parameter value will have the same value when the job finishes as it had when the job started.
by ray.wurlod
Thu Jan 26, 2012 2:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage - Reject the record with Lookup Success.
Replies: 6
Views: 2398

Use a reject link on the Lookup stage to capture the rejects.
by ray.wurlod
Thu Jan 26, 2012 2:38 am
Forum: General
Topic: Char(254) value for @FM
Replies: 5
Views: 3926

How @FM is represented depends entirely on the viewer that you happen to be using. In many utilities it displays as the Icelandic thorn character. It may be displayed as an open rectangle, or a filled rectangle, or anything else, but it's always the same single-byte value on the server.
by ray.wurlod
Wed Jan 25, 2012 4:47 pm
Forum: General
Topic: Important reminder concerning IBM Professional Certification
Replies: 0
Views: 573

Important reminder concerning IBM Professional Certification

Please review this important information regarding the IBM Professional Certification Testing Policy. In order to ensure the validity and integrity of the IBM Certification Program, testing data and results are randomly audited. All test takers are required to agree to a confidentiality statement wh...
by ray.wurlod
Wed Jan 25, 2012 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create key change column..sort stage error ???
Replies: 3
Views: 6221

Start by checking your metadata to ensure that CuSTID is present (and correctly cased) everywhere it's needed.
by ray.wurlod
Wed Jan 25, 2012 4:37 pm
Forum: General
Topic: New Functions
Replies: 16
Views: 6349

Version upgrades are free if you're paying for support. And imho you'd be crazy not to pay for support.
by ray.wurlod
Wed Jan 25, 2012 4:36 pm
Forum: General
Topic: DataStage Multi-Client Launcher
Replies: 13
Views: 8010

While you're writing the v8 one, please check that the registry keys are correct. I suspect these will have been "blue washed".