Search found 53125 matches

by ray.wurlod
Fri Sep 21, 2007 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Auto Generated column values via RCP
Replies: 3
Views: 2370

RCP only works for pure pass-through. If you neeed to derive an output column from an input column by any other means, or to use an input column in a stage variable or reference key expression, or to use an input column in an output link constraint, then that input column must explicitly be mentione...
by ray.wurlod
Fri Sep 21, 2007 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while installing Datastage PX
Replies: 9
Views: 3774

Vista is not supported as an operating system for DataStage. The vendor makes no guarantees that the product will even install.

The same is true of XP, but XP has been around longer and is closer to the Windows NT model that does support DataStage.
by ray.wurlod
Fri Sep 21, 2007 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with the teradata
Replies: 9
Views: 6092

What's different between the system where it is working and the system where it is not? Please consider non-DataStage differences as well, particularly differences in Teradata settings.
by ray.wurlod
Fri Sep 21, 2007 3:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error running a simple C routine.
Replies: 6
Views: 1507

Modifying the input argument in a function is never a good plan - you can get unwanted side effects. What did you actually want this function to accomplish?
by ray.wurlod
Fri Sep 21, 2007 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error msg "TOSH 000205 "
Replies: 2
Views: 1601

Path search failure suggests that one of the search list environment variables (PATH, LD_LIBRARY_PATH, CLASSPATH, etc.) needs extra information (extra directory pathnames).
by ray.wurlod
Fri Sep 21, 2007 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data type mismatch.
Replies: 3
Views: 1485

Does any derivation occur to SEGMENT in the Transformer stage?
Please post the generated OSH so we can see what's happening.
by ray.wurlod
Fri Sep 21, 2007 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migration from Linux to Windows
Replies: 1
Views: 1331

There is no "comparable version" prior to 8. The only parallel-capable version for Windows is 7.5x2, which does not have a UNIX equivalent. (7.5x2 relies heavily on being able to execute UNIX functions via MKS Toolkit, and you need the .NET C++ compiler installed, so straight away there is the poten...
by ray.wurlod
Fri Sep 21, 2007 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: creating sequential file in dos mode
Replies: 2
Views: 2539

That's just Notepad. Use Word; it can "translate" the UNIX line terminators. Maybe WordPad can too, I've never tried it. I usually use Word (or UltraEdit) because I usually want to see line numbers.
by ray.wurlod
Fri Sep 21, 2007 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What background process is going on After triggering PX job
Replies: 3
Views: 995

For less than 30c per day you can be a premium member and be able to read entire posts from premium posters (of whom there are only five). This money goes totally towards covering the hosting/bandwidth charges needed to keep DSXchange running. It's a worthwhile investment.
by ray.wurlod
Fri Sep 21, 2007 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to start teradata multiload
Replies: 7
Views: 4827

Welcome aboard. Can you please describe where you are using the $PROJDEF token? It should be used only in the job parameters grid, and only as the default value for a job parameter added as an envionment variable. Specifically, you do not set the default value of the environment variable to $PROJDEF...
by ray.wurlod
Fri Sep 21, 2007 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborting due to row limit being reached on output link
Replies: 5
Views: 11766

How big is the file? Ask your UNIX Administrator whether large file support is enabled. Does your job design include a row limit in an output link of the Transformer stage?
by ray.wurlod
Fri Sep 21, 2007 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DFloatToStringNoExp
Replies: 1
Views: 3863

Scale is the number of decimal places required to be represented in the string representation of the number.
by ray.wurlod
Fri Sep 21, 2007 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValue & KeyMgtGetNextValueConcurrent
Replies: 9
Views: 2959

Only the ability to guarantee that no other process was updating the table using the sequence to generate keys at the same time as the DataStage job. If there are other processes that update the table using the sequence at other times then the DataStage job, then you need to design in a check to ret...
by ray.wurlod
Fri Sep 21, 2007 3:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROLLBACK in OCI After SQL
Replies: 4
Views: 1308

Could be an example of "disgruntled former employee syndrome"! (OK, youse guys, try and figure out why nothing is loading!)