Search found 53125 matches

by ray.wurlod
Wed Jun 29, 2005 6:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Filter + Multi Xforms" vs "Xform + Multi Con
Replies: 6
Views: 1647

How about creating a lookup File Set keyed by country name and returning continent? Or, if the lists are small enough, a Modify stage to generate the continent lookup_string_from_int16(lookup_int16_from_string(...)) followed by a Switch stage to segregate rows by continent.
by ray.wurlod
Wed Jun 29, 2005 6:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: node_node2: Player 34 terminated unexpectedly.
Replies: 1
Views: 1037

Search the forum; player processes terminating on unexpected signals has been addressed before.

View the generated osh script to learn which operator becomes player 34. (You may need to enable viewing of generated OSH in the Administrator client.)
by ray.wurlod
Wed Jun 29, 2005 6:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure Stage Problem
Replies: 2
Views: 2665

Thanks for (a) finding and (b) posting the solution. This will hopefully alert future developers with similar problems to how painstaking proper troubleshooting needs to be.
by ray.wurlod
Wed Jun 29, 2005 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Lookup
Replies: 4
Views: 1148

Yes, but the OP specified to exclude "Have multiple looks with the same table". :wink:
by ray.wurlod
Wed Jun 29, 2005 3:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file 64 bit
Replies: 2
Views: 874

This post or this one will get you started.
by ray.wurlod
Wed Jun 29, 2005 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading from Excel with Dynamic columns
Replies: 10
Views: 6560

Nice one! :D
by ray.wurlod
Tue Jun 28, 2005 11:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Updatating a sequential file
Replies: 5
Views: 1528

While it is technically possible to overwrite a section of a file opened for sequential access, the restrictions probably preclude your using it in a generic sense. The first restriction is that the replacement line must contain exactly the same number of bytes as the line it replaces. Using a secon...
by ray.wurlod
Tue Jun 28, 2005 11:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading from Excel with Dynamic columns
Replies: 10
Views: 6560

Care to share?
Or, at the very least, to post the URL where you found the technique?
by ray.wurlod
Tue Jun 28, 2005 6:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: type 1 and type 2 dimensions
Replies: 11
Views: 4076

It's not our decision - it's theirs . They must tell you what information they want stored; for which fields it is essential to keep full history, for which fields partial history (maybe the most recent three changes) would be OK, and for which fields they are only interested in the most recent valu...
by ray.wurlod
Tue Jun 28, 2005 6:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS_log file
Replies: 10
Views: 4212

WAVE is a purely internal concept; if does not affect anything you do. The wave number is a mechanism for identifying runs uniquely, particularly when resetting a job. MSG.TEXT is the message text with placeholders, somewhat like the template used with the printf() family of functions in C. MSG.ARGS...
by ray.wurlod
Tue Jun 28, 2005 6:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Total no.of jobs in a Project
Replies: 6
Views: 1719

Code: Select all

COUNT DS_JOBS WITH NAME LIKE "1A0X"
would be my preference from the Administrator client command window.
by ray.wurlod
Tue Jun 28, 2005 6:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Different
Replies: 3
Views: 1306

Your approach to add key columns does not work with hashed files. A hashed file must, at all times, use the key, the whole key and nothing but the key to determine the location of a record. 20000000 rows is an awful lot for a hashed file - do you REALLY need them all? Can you be selective about whic...
by ray.wurlod
Tue Jun 28, 2005 6:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using routine read Hash file,generate 500 records of eachrow
Replies: 10
Views: 2760

To read each row from a hashed file, you need to have opened the hashed file, then establish a "Select List" of the hashed file's keys. You choose one at a time and read that record. OpenPath hashedfilepath To inputfilevariable Then ClearSelect 9 ; * initialize Select List number 9 Select inputfilev...
by ray.wurlod
Tue Jun 28, 2005 6:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using routine read Hash file,generate 500 records of eachrow
Replies: 10
Views: 2760

To write to a text file, use WriteSeq OutputLine To filevariable Else Call DSLogFatal("Unable to write to output file", "ExpandMe") End You need to have opened the file with OpenSeq before the main loop, and you need to close the file with CloseSeq after the main loop (to...
by ray.wurlod
Tue Jun 28, 2005 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mail Notification
Replies: 3
Views: 1129

If that's not enough, look at the Routine called DSSendMailTester (in the Built-In\Utilities category) for a coded example.