Search found 53125 matches

by ray.wurlod
Wed Mar 02, 2011 2:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: i have prob with effectve date and end date
Replies: 3
Views: 1463

Make another post indicating what version of software and operating system, then wait for the moderator to move this question to an appropriate forum.
by ray.wurlod
Tue Mar 01, 2011 11:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DCLGEN has 2 fields but only 1 VARCHAR column to load in DB2
Replies: 7
Views: 4331

That is a sngle VarChar field.

In your COBOL, EOD-EDI-TXN-DTL-TXT-LEN contains the length of the string, while EOD-EDI-TXN-DTL-TXT-TEXT is a buffer containing the string value itself, right space-padded to 3900 characters.
by ray.wurlod
Tue Mar 01, 2011 7:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel jobs
Replies: 6
Views: 2066

Not really. There is only one type of parallel job. It's called a "parallel job".
by ray.wurlod
Tue Mar 01, 2011 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Achive bellow logic in datastage
Replies: 6
Views: 4318

Search DSXchange for "vertical pivot" for that is precisely what you are seeking to accomplish.
by ray.wurlod
Tue Mar 01, 2011 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fast Track Query
Replies: 4
Views: 1577

Ernie is correct. Down to the individual column mapping level, FastTrack records and displays "last updated" (date/time) and "editor" (by whom). That information is available for all assets (as far as I can determine) as well as at higher levels - for example you can get these da...
by ray.wurlod
Tue Mar 01, 2011 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error: broadcastStepIR
Replies: 2
Views: 1947

Hard to say. Is your /tmp file system full (or near full)?
by ray.wurlod
Tue Mar 01, 2011 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Usage of sed in external filter stage
Replies: 6
Views: 6565

Escape backslashes the same way - with a preceding backslash. This is shell programming fundamentals.

The -f option is good too, except that you now need to maintain the file.
by ray.wurlod
Tue Mar 01, 2011 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to search for a specific string within an input string
Replies: 6
Views: 2500

An even more cunning plan - one that cannot fail - is to search for the delimited string.

Code: Select all

If Index(" " : OPT_STRING : " ", " " : OptionCode : " ", 1) Then "X" Else " "
by ray.wurlod
Tue Mar 01, 2011 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting multiple occurences in XML file
Replies: 3
Views: 2371

Probably because cosec forgot to type the / characters!
by ray.wurlod
Tue Mar 01, 2011 3:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load >2,000 byte string into Oracle using DataStage
Replies: 3
Views: 3262

Try using Long VarChar as the data type in your metadata. What is the data type when you import the table definition from Oracle?
by ray.wurlod
Tue Mar 01, 2011 3:24 pm
Forum: General
Topic: Job Sequence
Replies: 5
Views: 2264

You can search the Fix Central site for patches that apply to your particular version and operating system. You can also download the selected patches and fix packs from there.
by ray.wurlod
Tue Mar 01, 2011 3:23 pm
Forum: General
Topic: Error calling DSSetParam
Replies: 13
Views: 16773

:idea:
Plan ahead.
by ray.wurlod
Tue Mar 01, 2011 3:21 pm
Forum: General
Topic: Getting data out of DS_AUDIT
Replies: 5
Views: 4100

Code: Select all

SELECT INSTANCE, MODIFIER, MAX(DTM) AS MOST_RECENT_MOD
FROM UNNEST DS_AUDIT ON MODS
GROUP BY INSTANCE, MODIFIER;