Search found 42189 matches

by chulett
Thu Jan 29, 2009 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup not matching
Replies: 15
Views: 4729

Then it seems you're not populating your keys properly for the lookup. And that can include something as simple as trimming trailing spaces in your incoming values.
by chulett
Thu Jan 29, 2009 7:44 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI console
Replies: 10
Views: 5137

Yes, the "RTI Console" is a client application you need to install on your PC. It would have been delivered on the same media with the other RTI components.
by chulett
Thu Jan 29, 2009 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Decimal to Character
Replies: 7
Views: 1948

It won't because a) they resolved this several months ago and b) there's no such function in the Server edition.
by chulett
Wed Jan 28, 2009 7:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Run Times
Replies: 5
Views: 2724

Yah... that's why people build systems like ETLStats to farm and store that information somewhere less transient if they want to preserve it.
by chulett
Wed Jan 28, 2009 7:21 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI console
Replies: 10
Views: 5137

eostic wrote:Highly unlikely. On the other hand, I know I've said that Web Services Pack is no longer charged for.....
Aha! That was it. :D
by chulett
Wed Jan 28, 2009 5:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2/UDB Enterprise stage Write Method=Load blank values
Replies: 2
Views: 1151

Did you report this to your support provider?
by chulett
Wed Jan 28, 2009 5:25 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI console
Replies: 10
Views: 5137

Huh... I could have sworn you said that RTI was no longer being charged for and you just needed to request it nowadays. Ah, well. :?
by chulett
Wed Jan 28, 2009 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: .o file
Replies: 1
Views: 763

You... can't. That is "object code", compiled output. You still need to track down the source code for it, as was mentioned in your other posts on the subject.
by chulett
Wed Jan 28, 2009 3:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Run Times
Replies: 5
Views: 2724

Nope.
by chulett
Wed Jan 28, 2009 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I remove dashes in a date format?
Replies: 7
Views: 8067

Just the OConv is all that's really needed in this case... or use the DIGITS transform which makes the same function call under the covers but is a little easier on the eyes. :wink:
by chulett
Wed Jan 28, 2009 12:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Perl program erroring out from Datastage
Replies: 3
Views: 1468

Not what I meant - you may need to escape the double-quotes already around the -F\\ but I don't know how that would play with back-slashes that are already there. Maybe??

Code: Select all

perl -i \"-F\\\" -ape and so on
I'd probably just script it and then run the script instead.
by chulett
Wed Jan 28, 2009 12:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Perl program erroring out from Datastage
Replies: 3
Views: 1468

Hmmm... it tends to strip quotes from commands like that. Sometimes escaping them can help. Or you could put the commands in a batch / script and execute that instead.
by chulett
Wed Jan 28, 2009 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert strings
Replies: 6
Views: 1298

Right, your solution converts individual characters, so every "a" to a "k" and every "c" to a "g" regardless of where they appear or if (as the poster requires) they appear together in the string.
by chulett
Wed Jan 28, 2009 9:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The directory you are connecting to either is not ...(39125)
Replies: 2
Views: 7156

Right, "n" was the correct answer for that. As shown in my previous post, try backing up to the DSEngine directory before launching the shell: cd <DSEngine directory> bin\dssh It should just take you in without issue or questions and then you can LOGTO the project from there which is where...
by chulett
Wed Jan 28, 2009 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compile:"Referenced StartLoop cannot be found on input
Replies: 3
Views: 6536

Err... no, not the job control code. Post a picture of the canvas or draw the flow so we can "see" your job design. :?