Search found 53125 matches

by ray.wurlod
Sun Mar 04, 2007 8:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: clearing scratch space
Replies: 9
Views: 2504

Unless you're running out of space there's no rush to clean them up. But, if you want to, simply use rm when there's no jobs running.
by ray.wurlod
Sun Mar 04, 2007 8:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sample px routine
Replies: 10
Views: 3269

The most important piece, as will all programming, is to establish your requirements and design your algorithm before even touching any code. In the case of DataStage functions, give some thought also to whether you can make the function more generic/re-usable.
by ray.wurlod
Sun Mar 04, 2007 8:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: capturing Job's Version Number for audit meta-data
Replies: 9
Views: 2521

XLATE is a synonym for TRANS, as your researches will have revealed.
by ray.wurlod
Sun Mar 04, 2007 10:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to delete the indexes of a table using routine
Replies: 8
Views: 1947

The syntax for OPEN and CLOSE command is "any valid SQL".

"Valid" includes your having appropriate database/table privileges to execute the said command.
by ray.wurlod
Sun Mar 04, 2007 10:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: clearing scratch space
Replies: 9
Views: 2504

Are any jobs running that might be using the scratch space? Scratch space should be cleaned up automatically - if it's not you have jobs that are aborting, and should do something about that.
by ray.wurlod
Sun Mar 04, 2007 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sample px routine
Replies: 10
Views: 3269

Search the forum. Search the manuals. There are examples out there.
by ray.wurlod
Sun Mar 04, 2007 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: More column in RCP and less column in Target?
Replies: 8
Views: 1667

GET access. That's the only way to test things.
by ray.wurlod
Sun Mar 04, 2007 10:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 11204
Replies: 2
Views: 1338

Your job tried to write a record to a hashed file or some other data target with a primary key, but provided NULL as the primary key value.

This is not permitted.

Make sure no NULL gets this far through your job design.
by ray.wurlod
Sun Mar 04, 2007 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: capturing Job's Version Number for audit meta-data
Replies: 9
Views: 2521

How about: FUNCTION TestJobVersion(TheJobName) * Returns job version number if found, or "" otherwise Ans = Trans("DS_JOBOBJECTS", "J\":Trans("DS_JOBS", TheJobName, 5, "X"):"\ROOT", 8, "X") RETURN(Ans&#...
by ray.wurlod
Sat Mar 03, 2007 6:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: More column in RCP and less column in Target?
Replies: 8
Views: 1667

Yes, for example RCP must be enabled in Adminstrator then, even if it is, can be enabled/disabled on a per-stage basis in the processing stream. Is the stage type amenable to using a schema file and, if so, is it? Will that get you going?
by ray.wurlod
Sat Mar 03, 2007 6:31 pm
Forum: General
Topic: DCS-Strategies 10 years of thanks
Replies: 8
Views: 2628

Doesn't time fly when you're having fun?

I'd like to add my thanks to Dennis for having the vision to create this site and its predecessor and sibling sites. Even I have been able to learn stuff from it, and it well pre-dated the "official" user community (DeveloperNet).
by ray.wurlod
Sat Mar 03, 2007 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Read Floats in Sequential File
Replies: 4
Views: 1876

Try reading it as a string, and converting it inside your job.
by ray.wurlod
Sat Mar 03, 2007 12:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Speed up WAN client <-> server connectivity
Replies: 5
Views: 1983

What's the ping time on your LAN? What does that say about relative speeds?
by ray.wurlod
Sat Mar 03, 2007 12:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 64BIT Hashed Files
Replies: 27
Views: 8641

If you're in BASIC anyway, you can open a pathed hashed file with OpenPath statement. Then use the Status statement as described above.
by ray.wurlod
Sat Mar 03, 2007 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage config files.
Replies: 10
Views: 6579

My answer was very detailed. For about 3c per day you can purchase premium membership, help to pay for the bandwidth this site needs, and read all the premium posts plus get access to other premium membership goodies.