Search found 42189 matches

by chulett
Wed Dec 23, 2009 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to translate EDI X12 documents
Replies: 1
Views: 1742

There's no plug-in for that that I know of and one would typically use the "TX" product for things of that nature. Otherwise it's going to be something you'd need to tear apart yourself. From looking at the format it doesn't look like it would be too bad to handle. :wink: Read the file as ...
by chulett
Wed Dec 23, 2009 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Key Column
Replies: 4
Views: 1144

A Key column has nothing to do with indexes or database Primary Keys or any such concept. It simply means the column(s) to be used in the where clause.
by chulett
Wed Dec 23, 2009 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help with sorting the data
Replies: 8
Views: 1654

srinivas.g wrote:Performance wise Inline sort is best compare to explicit sort stages.
Based on what? Under the covers they're both the same tsort operator.
by chulett
Wed Dec 23, 2009 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while running the job
Replies: 10
Views: 1720

'Code' doesn't necessarily mean your 'code', could be a driver or parallel framework bug, etc. Involve your official support provider.
by chulett
Wed Dec 23, 2009 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clearing PH folder
Replies: 2
Views: 1191

PH stands for 'Phantom' or background process. It is a communication area that should be pruned of 'old' information on a regular basis. There is no 'moving to production' component to this. Once a job completes this information is no longer needed.
by chulett
Wed Dec 23, 2009 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loop for previous month number of days
Replies: 12
Views: 4365

The Start Loop and End Loop stages, oddly enough. Optionally a User Variables stage as well to derive values at runtime, for example your number of times to loop. Read the docs, they are explained there with several examples.
by chulett
Wed Dec 23, 2009 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Compiling Parallel Transformer 8.1
Replies: 17
Views: 14822

They've been posted here fairly recently, it might be a little bit of a PITA but a search should find them.
by chulett
Wed Dec 23, 2009 7:55 am
Forum: General
Topic: How to run UV commands from Unix
Replies: 15
Views: 21580

Where did you launch uvsh from? Did you get any kind of a message about something "not being set up"? Are you properly logged into your project? Does that work in the Administrator?
by chulett
Wed Dec 23, 2009 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Striping Line Feed Character
Replies: 7
Views: 4395

First you must identify the character, then you can strip it easily. A hex editor is the easiest way to do that and there are a ton of free ones out there.
by chulett
Wed Dec 23, 2009 7:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Query
Replies: 3
Views: 1321

I'm not sure there really is a need for that option with a Type 30. But don't forget the stage supports all types, so it could be more appropriate for the static types. Curious what others think.
by chulett
Wed Dec 23, 2009 7:37 am
Forum: General
Topic: execute command stage
Replies: 2
Views: 723

In other words, it executes an operating system command. And you put in whatever is required to run it.
by chulett
Tue Dec 22, 2009 11:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling special characters
Replies: 2
Views: 2478

So... this is resolved? If so, mark it as such using the button at the top of the page.
by chulett
Tue Dec 22, 2009 11:45 pm
Forum: General
Topic: Failed validation
Replies: 3
Views: 1058

Is that the sum total of the error(s) you get? What is your job design?
by chulett
Tue Dec 22, 2009 11:43 pm
Forum: General
Topic: Invalid character(s) ([xFD]) found
Replies: 1
Views: 1516

It's a character set issue, not a data type issue. Have you tried stripping it from the field? Add $APT_DISABLE_COMBINATION set to True in your job and rerun to know which stage is throwing the error.