Search found 53125 matches

by ray.wurlod
Thu May 20, 2010 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Intelligent word wrapping
Replies: 22
Views: 6430

It's not on the Palette. The BASIC Transformer stage is to be found in the Stage Types branch of the Repository. It is NOT the same as the server Transformer stage - for example the BASIC Transformer stage does not support reference inputs.
by ray.wurlod
Thu May 20, 2010 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Packed column from DB2/400
Replies: 37
Views: 6558

This is the first mention that a column may not be present, and adds hugely to the complexity of the solution. For each field you will first need to determine existence in the string, then find the delimiters (more specifically the character positions thereof) to the left and right of this position ...
by ray.wurlod
Thu May 20, 2010 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: write fail to oracle table
Replies: 8
Views: 2614

Maybe you need to qualify the table name with a schema (owner) name.
by ray.wurlod
Thu May 20, 2010 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to insert data into oracle EE stage
Replies: 14
Views: 5653

Learn some patience.

DSXchange is an all-volunteer site; members post as and when they can. Some of them are asleep at the moment.

If you want 30 minute response, sign up for premium services with your official support provider.
by ray.wurlod
Thu May 20, 2010 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look-Up for a Complex Logic
Replies: 4
Views: 1177

Apart from the change of case it looks like an ordinary, regular, key-based lookup to me.
by ray.wurlod
Thu May 20, 2010 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling run time meta data
Replies: 5
Views: 1753

With RCP you can use SELECT * FROM #schema#.#tablename#
You get all rows and all columns of course.
by ray.wurlod
Thu May 20, 2010 7:25 am
Forum: IBM QualityStage
Topic: Customized Rule Set
Replies: 4
Views: 1870

Try here
by ray.wurlod
Thu May 20, 2010 7:23 am
Forum: General
Topic: Job deletion and Logs associated with these.
Replies: 2
Views: 1199

Welcome aboard. It really depends on where your logs are stored, but in either case all the log information will be lost. If you are using local repository even the structures in which the log data are stored are dropped. If you are using central repository then only the events pertinent to that job...
by ray.wurlod
Thu May 20, 2010 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XMETA sharing between Version 8.0 with 8.1
Replies: 1
Views: 1039

Short answer: NO.

The structure changes somewhat in version 8.1.
by ray.wurlod
Thu May 20, 2010 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Two Nodes not working
Replies: 18
Views: 6394

Right click on Monitor background and choose "Show Instances" (or some such).
by ray.wurlod
Thu May 20, 2010 3:24 am
Forum: General
Topic: IOD EMEA Day Two
Replies: 11
Views: 6814

IOD EMEA Day Two

It's a very busy conference, with 560 presentations over the three days. Obviously no one person can get to very many of them at all. Alas (even though it's now day three) I have not been able to assemble my notes to post here. I will get around to doing so. No roadmap presentations thus far. Please...
by ray.wurlod
Thu May 20, 2010 3:20 am
Forum: General
Topic: IOD EMEA 2010 Day One
Replies: 5
Views: 1779

Yes, these are adjacent Channel Islands. But what's a Sark (as an item of clothing)?
by ray.wurlod
Thu May 20, 2010 3:19 am
Forum: General
Topic: fail to connect to ole server
Replies: 5
Views: 1754

Not quite. "Loses the handle" is a technical term. A "handle" to an object is like a file variable in DataStage BASIC. Windows is a messaging operating system that passes various things (including handle references) to and fro, and occasionally loses them. "Spit the dummy&qu...
by ray.wurlod
Tue May 18, 2010 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project level message handler not being picked up
Replies: 2
Views: 1619

Not being picked up "where"?

Have you set it as the default message handler for the project using Administrator client? Or have you deliberately attached this message handler to a job?