Search found 53125 matches

by ray.wurlod
Thu Feb 14, 2008 12:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exporting - Importing DS components
Replies: 8
Views: 2498

If the export includes executables, then it is not necessary to compile in the project into which the components were imported. Equally, it is not wrong to do so. Validating jobs is the preferred way to verify connectivity; parameter defaults may be changed in Director if desired without the need to...
by ray.wurlod
Thu Feb 14, 2008 12:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning in transformer
Replies: 27
Views: 8375

Look in RT_BP2311/JOB.1396960201.DT.1465440079.TRANS1 and check the code either side of line number 107 to see what might have happened. In particular look for a reference to a subroutine whose name begins with "$". (You may have overlooked this earlier.)
by ray.wurlod
Wed Feb 13, 2008 11:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleted Category
Replies: 6
Views: 1241

The three dots are part of the syntax. The job name is preceded (in the DS_AUDIT key) by a class identifier. The three dots are the wildcard in RetrieVe query language pattern matching. Or use the SQL that I posted earlier.
by ray.wurlod
Wed Feb 13, 2008 11:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Complex Flat File
Replies: 1
Views: 665

Why do you believe asking the same question in a different thread will get a different answer?
by ray.wurlod
Wed Feb 13, 2008 11:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of the Job Control
Replies: 2
Views: 747

Versions earlier than 5.2 had to write their own job control code. Nowadays we have job sequences which, when compiled, create job control code. Therefore the need to write your own should be almost non-existent; though you may encounter sites where there is some "from the old days" that needs to be...
by ray.wurlod
Wed Feb 13, 2008 11:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Main Sequence from a particular Job/Sequence
Replies: 10
Views: 2936

U hasn't logged in for quite a few months. Don't hold your breath waiting for U to explain how to start any DS job from another.
by ray.wurlod
Wed Feb 13, 2008 10:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern Matching in Wait for file activity
Replies: 2
Views: 1196

No. but it's easy to do from a Routine activity.
by ray.wurlod
Wed Feb 13, 2008 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error reading on import from Sequential file
Replies: 1
Views: 2997

Look on the Format tab. The delimiter you've specified is not the one actually used in the file. DataStage is still looking for the on you've specified. Alternatively you've hit a hard-coded limit of one million bytes that the import operator is allowed to scan without finding a delimiter. If you ne...
by ray.wurlod
Wed Feb 13, 2008 10:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: etl-tools.info - datastage-tutorial- scd2-implementation?
Replies: 6
Views: 4567

Start at this page for the full set. Heed Craig's advice.
by ray.wurlod
Wed Feb 13, 2008 10:01 pm
Forum: Enhancement Wish List
Topic: Query editor in hashed file
Replies: 5
Views: 2171

Or you can use the Administrator client Command window. DataStage/SQL is one of the two query languages available. Or you can use the RetrieVe query language, as Ken suggested. To view the table definition of a hashed file the command is LIST.DICT (for which you will also need a VOC pointer to the h...
by ray.wurlod
Wed Feb 13, 2008 6:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: why does Datastage not support Datatype INT8(serial8)
Replies: 20
Views: 9199

So cast as BigInt rather than Integer. BigInt is an eight-byte signed integer.
by ray.wurlod
Wed Feb 13, 2008 6:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: why does Datastage not support Datatype INT8(serial8)
Replies: 20
Views: 9199

So cast as BigInt rather than Integer. BigInt is an eight-byte signed integer.
by ray.wurlod
Wed Feb 13, 2008 6:20 pm
Forum: Enhancement Wish List
Topic: Query editor in hashed file
Replies: 5
Views: 2171

What it is you think you can't do? Is it a query builder, or the ability to view the data in the hashed file? Certainly you can do the latter with the data browser.
by ray.wurlod
Wed Feb 13, 2008 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: java pack
Replies: 17
Views: 6567

That most recent message is about not being able to find the error message text in the "resource" file. It's unrelated to the earlier problem, and probably solved by setting the indicated environment variable to the location of the resource file (probably DS_RESENU for US English).
by ray.wurlod
Wed Feb 13, 2008 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Stage which supports both Input and output links?
Replies: 3
Views: 1137

The reason is that that would be a "blocking operation" - a passive stage can not open its output(s) until its input has closed. Blocking operations interfere with (prevent) pipeline parallelism and are therefore banned.