Search found 53125 matches

by ray.wurlod
Wed May 12, 2010 8:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error adding to schedule in windows environment
Replies: 6
Views: 4257

If you want to use the MKS Toolkit at command instead, you will need to add the user name to the at.allow file (and change the BAT file for a shell script).
by ray.wurlod
Wed May 12, 2010 8:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server engine maps and locales were not reconfigured
Replies: 3
Views: 1411

Nah, it's just expectation management. Of course, srikanth's expectation and our "(as soon as) possible" might diverge somewhat. And now to the question. It's pretty obvious that server engine maps and locales were not reconfigured. This refers to the server (as opposed to parallel) NLS ma...
by ray.wurlod
Wed May 12, 2010 5:28 pm
Forum: Site/Forum
Topic: Missing "Delete this post" link in DataStage Serve
Replies: 3
Views: 2997

OK, you can ask the moderator to delete for you. Meanwhile, whoever looks after the site will chance upon this thread and investigate.

I should have mentioned that you can only delete a post from a thread if there are no other posts following it. Perhaps this is your issue?
by ray.wurlod
Wed May 12, 2010 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Precision
Replies: 9
Views: 3491

Are you using Runtime Column Propagation?
by ray.wurlod
Wed May 12, 2010 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Significance of DSAttachJob and DSDetachJob
Replies: 8
Views: 3697

But DSJ.ME can be used as the job handle to interrogate the job that invokes the routine.
by ray.wurlod
Wed May 12, 2010 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid argvalue Warning.
Replies: 3
Views: 2280

Please wrap your "design" in Code tags to preserve its format.
by ray.wurlod
Wed May 12, 2010 4:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Input file for Bapi Stage
Replies: 3
Views: 1284

It's original purpose was for migrating UniVerse hashed files between different-Endian environments. (The name fnuxi is a faux byte-swap of "unix" with an "f" in front.) To be honest it's more than a decade since I've used it. Open a telnet window and execute the command HELP FOR...
by ray.wurlod
Wed May 12, 2010 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problems using range lookup
Replies: 6
Views: 7375

The range lookup can be performed on either link.

Research more deeply. Look in the manual or training materials for "range lookup on reference input" and "range lookup on stream input".

To be honest I have not yet found a need for the latter.
by ray.wurlod
Wed May 12, 2010 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removal of Special Character
Replies: 9
Views: 11236

Philosophically, they're not special, they're just non alphanumeric.

Code: Select all

Convert("!@#$%^&*()_-+={}[]|\:;'?><,./~`" : '"', "", InLink.TheString)
by ray.wurlod
Wed May 12, 2010 4:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: hashed file - 32 bit to 64 bit
Replies: 3
Views: 1858

Hashed files are not much used in parallel jobs. Yet you've marked the job type as parallel and posted in the parallel forum. Now to answer your question. There are several command that can do this. The easiest is to attempt an innocuous command that is not supported on 64-bit hshed files, such as U...
by ray.wurlod
Wed May 12, 2010 4:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsrpcd service is not running
Replies: 2
Views: 2344

Search DSXchange for information about how to debug why dsrpcd might not start.
by ray.wurlod
Wed May 12, 2010 4:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion
Replies: 3
Views: 1283

Interesting how you detected that there was an "Aggrigator" in the mix. Is this something used in farming?
:wink:
by ray.wurlod
Wed May 12, 2010 4:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Commit intervals in ODBC Enterprise stage
Replies: 1
Views: 1109

Moderator: please move to Enterprise Edition (parallel) forum
by ray.wurlod
Wed May 12, 2010 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to compare date columns
Replies: 6
Views: 1814

In Server edition dates can be compared directly provided that (a) they are in the same format as strings and (b) that either none or both has been converted to internal format.
by ray.wurlod
Wed May 12, 2010 4:13 pm
Forum: General
Topic: [DataStage][SQL Client]Data has been truncated
Replies: 6
Views: 4019

Good detective work.

(That's what I meant by suggesting that you "search harder".)