Search found 42189 matches

by chulett
Mon Mar 07, 2011 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: current date () to julian date (YYDDD)
Replies: 8
Views: 6062

Pretty sure if you check the docs that a mask of %ddd will get that for you.
by chulett
Mon Mar 07, 2011 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: change line break from CR to CR/LF
Replies: 14
Views: 6405

An ASCII (rather than a BINARY) transfer will convert record delimiters between UNIX and Windows... or vice versa.
by chulett
Mon Mar 07, 2011 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup problem
Replies: 4
Views: 1891

Look them up separately.
by chulett
Sun Mar 06, 2011 5:54 pm
Forum: General
Topic: Sechduling job through autosys on every Tuesday
Replies: 3
Views: 2756

That sounds like a question for your AutoSys people. Regardless of the scheduling mechanism, one option is to run the scheduled job every day and then check if it is Tuesday or June 29th. The 'trick' is to schedule a Sequence job that does the check and then only runs the actual processing job if th...
by chulett
Sat Mar 05, 2011 9:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to load null into decimal datatype without warning
Replies: 4
Views: 2626

Why convert the null to a space which is a value that cannot be loaded into a decimal field? Leave it alone, let it load as is.
by chulett
Fri Mar 04, 2011 9:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to load null into decimal datatype without warning
Replies: 4
Views: 2626

Post your actual, unedited warning(s).
by chulett
Fri Mar 04, 2011 7:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error in Transformer
Replies: 11
Views: 6718

Hey... that's how we roll. :wink:
by chulett
Fri Mar 04, 2011 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error in Transformer
Replies: 11
Views: 6718

ray.wurlod wrote:It's nothing to do with the compiler.
Maybe... maybe not. Once they get past that error was trying to head the other off at the pass, that or put it in the Non-Issue pile. We shall see.
by chulett
Fri Mar 04, 2011 7:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error in Transformer
Replies: 11
Views: 6718

First tell us if you have a supported C++ compiler installed, I can't tell from what was posted. :?

ps. I'm assuming you can't compile any job with a transformer, not just this one - yes?
by chulett
Fri Mar 04, 2011 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compile Confirmation Window
Replies: 5
Views: 3146

Another possible solution, uninstall and reinstall the client. An alternate quicker solution if you are comfortable in 'regedit' is to edit your registry and remove any entries for the Designer, in particular the window positions. It will rebuild them with default values next time you run the Design...
by chulett
Fri Mar 04, 2011 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error in Transformer
Replies: 11
Views: 6718

OK... PX jobs with transformers require an properly installed, configured and supported C++ compiler for your platform and version. All of which is documented in the product and has been discussed here ad nauseam. So your first task would be to determine which compiler(s) are supported on your platf...
by chulett
Fri Mar 04, 2011 7:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to update the Hash file in the server Basic language
Replies: 9
Views: 3534

You could also look at either of the two included "KeyMgmt" routines which do pretty much the same darn thing, one with and one without handling concurrency of access.
by chulett
Thu Mar 03, 2011 8:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Signed/Unsigned Decimal to Pack Decimal
Replies: 9
Views: 7658

And, as usual, I have to come along behind and clean up all your excessive quoting. Learn to love the Reply to topic button! :wink:
by chulett
Thu Mar 03, 2011 5:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loop Activity in 8.5 Transformer
Replies: 2
Views: 3464

Split from this topic so wittyme can control their own destiny.