Search found 53125 matches

by ray.wurlod
Wed Dec 07, 2011 7:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date issue
Replies: 5
Views: 1820

First bit of advice: don't push. Most of us have to work for a living, and you only waited less than five hours before pushing.
by ray.wurlod
Wed Dec 07, 2011 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 14763 Variable previously undefined. Zero length s
Replies: 9
Views: 2341

The code may be subject to non-disclosure. In that case post a suitably anonymous variant of the code.
by ray.wurlod
Wed Dec 07, 2011 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning message at the end..dropping rows
Replies: 6
Views: 9252

Detect which input columns to that Transformer stage contain nulls and which operation (stage variable, constraint expression, derivation expression) is having problems handling null because it contains a function call. Handle any such null values before they are passed to the function. Note that DS...
by ray.wurlod
Wed Dec 07, 2011 4:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which Version of DB2 is compatible with DataStage 8.1 FP1
Replies: 5
Views: 3281

Try the IBM Information Center (you may have to follow a link called something like "system requirements").
by ray.wurlod
Wed Dec 07, 2011 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom 14763 Variable previously undefined. Zero length s
Replies: 9
Views: 2341

The problem is in your routine TranslatePicCodeOther. The code in the routine is attempting to use the value of a variable before that variable has been assigned a value.
by ray.wurlod
Wed Dec 07, 2011 4:35 pm
Forum:
Topic: Importing Business Glossary
Replies: 5
Views: 4812

Multi-select is OK for batch edit and "mark for deletion".

I can not see how to send a batch for approval, to approve a batch or to publish a batch without individually opening each term and category. :(
by ray.wurlod
Wed Dec 07, 2011 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata 6706 error
Replies: 5
Views: 11589

Welcome aboard.

What method (that is, what stage type and what settings) are you using to write to Teradata?
by ray.wurlod
Wed Dec 07, 2011 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while running an extract Job.
Replies: 5
Views: 1856

Check for expired/changed password.
by ray.wurlod
Wed Dec 07, 2011 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job failing in lookup Stage
Replies: 18
Views: 7857

How much real (physical) memory is in the machine? How much scratch space do you have? How big is your temporary directory?
by ray.wurlod
Wed Dec 07, 2011 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Converting the datetimestamp into following...
Replies: 6
Views: 1528

If it's a string you can simply use Convert(": ",".-",InLink.TheString).

If it's a timestamp you need to convert it to a string (possibly implicitly) then convert that string to a timestamp with an appropriate format string, such as "%yyyy-%mm-%dd-%hh.%nn.%ss.3"
by ray.wurlod
Wed Dec 07, 2011 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning message at the end..dropping rows
Replies: 6
Views: 9252

One message is from node #0, the other identical message is from node #1. You are running on a two node configuration, each performing identical processing on separate subsets of your data.
by ray.wurlod
Wed Dec 07, 2011 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capture the reject record based on column length
Replies: 20
Views: 7863

Use APT_STRING_PADCHAR to set the pad character to space.
by ray.wurlod
Wed Dec 07, 2011 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Logic
Replies: 16
Views: 4257

The sensible one or the silly one? :wink:
by ray.wurlod
Wed Dec 07, 2011 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mutiple Links to Parallel Transformer stage -- SHOCKED ???
Replies: 5
Views: 4027

My guess is that it's a bug in your version of 7.5 that the developer has relied on. How are the multiple inputs manipulated within the stage? How did you ascertain that it's a Parallel Transformer stage?
by ray.wurlod
Wed Dec 07, 2011 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to view all records from sequential file
Replies: 20
Views: 6585

That looks like reasonable data, though maybe the final field is truncated as you say. Can you please provide the record schema that describes the record structure, and one more example of a failed row?