Search found 53125 matches

by ray.wurlod
Fri Jul 29, 2011 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No hit on lookup with Ignoring duplicate error
Replies: 3
Views: 1607

No, that's simply how it works.
The Lookup stage by default returns one match. If you want more than one (which is likely less of the time) you have to tell it so.
by ray.wurlod
Fri Jul 29, 2011 4:13 pm
Forum: General
Topic: Sequencer Restartability issue
Replies: 5
Views: 1551

One sequence can call another to build a hierarchy of control.
by ray.wurlod
Thu Jul 28, 2011 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can we implement Arr... in Transformer stage .....
Replies: 2
Views: 1571

Probably not in the sense that you mean, though it IS possible to implement "dynamic arrays" which are delimited strings with reserved delimiter characters that pretend to be arrays.
by ray.wurlod
Thu Jul 28, 2011 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parsing Names
Replies: 7
Views: 3144

... or using something like QualityStage to figure it out based on known first names. But even that's not 100%. Can't be, because parents go on inventing new names for their children.
by ray.wurlod
Thu Jul 28, 2011 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Information Server Dataset Directory
Replies: 4
Views: 2023

You probably have a heap of orphaned *.ds and/or *.fs files hanging around now.
by ray.wurlod
Thu Jul 28, 2011 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look up table temporary Storage space
Replies: 2
Views: 1657

How, precisely, do you go about "Creating dataset in a user defined path"? If all you create there is the descriptor file, you're not accomplishing much. The data, or "segment", files that comprise the data set are stored in the directories identified as "resource disk"...
by ray.wurlod
Thu Jul 28, 2011 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: validate file
Replies: 5
Views: 1770

If file has one header and one trailer this is a trivial task to script. If the file might have multiple headers and trailers, the best solution is probably a DataStage job.
by ray.wurlod
Thu Jul 28, 2011 4:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Differnce between two dates
Replies: 3
Views: 1238

Subtract date-to-Julian-day conversions.
by ray.wurlod
Thu Jul 28, 2011 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Differnce between two dates
Replies: 3
Views: 1238

Please spell your words completely. Not everyone on DSXchange has English as their first language; they should not be compelled to try to figure out what you mean.
by ray.wurlod
Thu Jul 28, 2011 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence numbers
Replies: 6
Views: 1941

So long as you're not interested in performance. What are you looking up against?
by ray.wurlod
Thu Jul 28, 2011 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Long Month Name from Date
Replies: 24
Views: 12124

Code: Select all

OConv(IConv(YourField,"D"),"DMA" : @VM :"MCT")
by ray.wurlod
Thu Jul 28, 2011 4:34 pm
Forum: General
Topic: Schema Library Manager Option Missing in the Client 8.5
Replies: 5
Views: 2617

You can install Fix Pack 1 on any supported platform. Yours is a supported platform - the fact that you have installed 8.5 there is not sufficient evidence of this - you need to check the Planning, Installation and Configuration Guide.
by ray.wurlod
Thu Jul 28, 2011 4:31 pm
Forum: General
Topic: Error while opening Webconsole Infosphere Information Server
Replies: 5
Views: 6683

WAS wrote:insufficient or empty credentials
by ray.wurlod
Thu Jul 28, 2011 4:30 pm
Forum: General
Topic: How can I monitoring a file all the time.
Replies: 1
Views: 979

You also need to incorporate a mechanism for shutting down the "eternal" job for those occasions when you need to stop the Engine.
by ray.wurlod
Thu Jul 28, 2011 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue in Reading a Sequential File
Replies: 4
Views: 1655

<rant>Resist stupid requirements!</rant>
Please post your client's reasons for "needing" it.
Does your client have pointy hair?