Search found 53125 matches

by ray.wurlod
Thu Jan 25, 2007 2:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: writing to XML file
Replies: 9
Views: 2478

Quantify "very slow" and "faster" without using rows/sec which, as I have established elsewhere, is an essentially meaningless metric. What volume of characters is written into a text file versus what volume of characters is written into the XML file? How much extra processing is needed to create th...
by ray.wurlod
Thu Jan 25, 2007 2:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help in setting up environment variable
Replies: 13
Views: 5175

Visual Studio first, then DataStage. MKS Toolkit installs as part of DataStage 7.5x2.
by ray.wurlod
Wed Jan 24, 2007 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Locked Error
Replies: 2
Views: 2996

When you get an opportunity, stop DataStage on the server and restart. This is the only way I've ever found to clear a project lock.
by ray.wurlod
Wed Jan 24, 2007 11:33 pm
Forum: Enhancement Wish List
Topic: Array of Wishlistsssss
Replies: 4
Views: 3181

1. Debugging for PX. Server type debugging. Besides Peek, Head ,Tail, Row, Column gen. Won't happen. A debugger needs a single stream of execution. In a parallel job, not only might you have multiple streams of execution, they might be on separate machines. And what happens when the grid management ...
by ray.wurlod
Wed Jan 24, 2007 7:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OCI Stage: Indexes in Unusable State
Replies: 7
Views: 3720

Don't need to guess. Need to Search.

This is a known issue, and has been discussed here previously.
by ray.wurlod
Wed Jan 24, 2007 7:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: qsrtmngr.exe in Windows
Replies: 7
Views: 1659

Have you set up the user ID as able to run as a service ?
by ray.wurlod
Wed Jan 24, 2007 7:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NVL in Server jobs?
Replies: 4
Views: 1272

You'll find these as Transforms, rather than as Routines. Create your own NullToValue transform in the same category. Of course, it will need two arguments, not one.
by ray.wurlod
Wed Jan 24, 2007 7:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Install DataStage on RED HAT 4 32/64 bit
Replies: 7
Views: 1765

Version 7.x of DataStage is not, and will not be, certified on RH 4.

It may work, it may work with some tweaking, but IBM make no promise to support it (and officially they won't).
by ray.wurlod
Wed Jan 24, 2007 3:42 pm
Forum: IBM QualityStage
Topic: data removal in quality stage
Replies: 1
Views: 1724

Check out the Survive stage.
by ray.wurlod
Wed Jan 24, 2007 3:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparse Lookup Connectivity to DB2
Replies: 6
Views: 1516

If this resolves your question, please mark the topic as resolved.
by ray.wurlod
Wed Jan 24, 2007 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does ETL able to handle TCP Socket connectivity
Replies: 6
Views: 2195

jhmckeever's response is appropriate to parallel jobs, not server jobs.

There is no direct support for sockets in server jobs, but the Sequential File stage can work with named pipes, which comes close in functionality for inter-job connectivity.
by ray.wurlod
Wed Jan 24, 2007 3:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Picking up the Right values n loading to DW
Replies: 2
Views: 864

Code: Select all

Field("TR1|TR2|...|TR30", "|", TheNumber, 1)
by ray.wurlod
Wed Jan 24, 2007 3:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PROTOTYPEParam
Replies: 7
Views: 1486

That's why I include a copyright notice and a condition of use that the notice remains. Whether it works or not I have no idea but, if I ever encounter a violation, I intend to prosecute.
by ray.wurlod
Wed Jan 24, 2007 1:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help in setting up environment variable
Replies: 13
Views: 5175

Try using backslash characters rather than forward slash characters in the Windows pathnames. If that does not work, try "escaping" the backslash characters (use "\\" instead of "\").