Search found 42189 matches

by chulett
Wed Aug 04, 2010 9:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null Handling
Replies: 10
Views: 2224

Apparently the Reply to topic link is not working either. [sigh]

"Not working" doesn't really give us much to go on, how about more information? Say, your job design, stages used (particularly the target stage), settings there, etc etc etc. Details are your friend.
by chulett
Wed Aug 04, 2010 9:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle turning a space into a null
Replies: 14
Views: 3265

Ah... another excellent point from Our Man Ray. :wink:
by chulett
Wed Aug 04, 2010 9:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborted without specific error message
Replies: 3
Views: 2962

Would really need a wee bit more information... for starters, how about some details about your job design? Stages, settings, etc etc etc - anything you can think of to share even if you don't think it is relevant.
by chulett
Wed Aug 04, 2010 8:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle turning a space into a null
Replies: 14
Views: 3265

In searching back over the forums I think it is actually plural, so try $APT_ORACLE_PRESERVE_BLANKS instead and see if that works more bettter.
by chulett
Wed Aug 04, 2010 8:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null Handling
Replies: 10
Views: 2224

While nulls and empty strings are two different things, Oracle is perfectly happy to turn one into the other. Add $APT_ORACLE_PRESERVE_BLANKS to your job and set it to "true", see if that helps.
by chulett
Wed Aug 04, 2010 8:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null Handling
Replies: 10
Views: 2224

Be patient, people post when they can - this isn't a 24 hour hotline. :?

Also, please learn to use the Reply to topic link, there's no need to quote something every dang time.
by chulett
Wed Aug 04, 2010 6:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicates of logical key loaded into dimension table
Replies: 13
Views: 5083

Vogons? Yikes, please tell me you won't start spouting their poetry next? :shock:
by chulett
Wed Aug 04, 2010 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to get the last word after space
Replies: 4
Views: 2236

Curious under what circumstances DCount() might be considered invalid? :?
by chulett
Wed Aug 04, 2010 12:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Job
Replies: 2
Views: 1181

Re: DS Job

I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc) How about you first explain what "them" are? I could guess but I'd rather not and you haven't really told us in your post. Then we can get working on why you a...
by chulett
Wed Aug 04, 2010 9:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_ORACLE_PRESERVE_BLANK
Replies: 1
Views: 981

:!: You really should have just added to this your existing post so people know what the heck you are talking about.
by chulett
Wed Aug 04, 2010 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checkpoint run!
Replies: 4
Views: 8444

No, not the "whole operation", it just means that that object will always run regardless of the current checkpoint situation.
by chulett
Wed Aug 04, 2010 9:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal Termination
Replies: 6
Views: 3434

An exact match search for "Fault type is 11. Layer type is BASIC run machine." returned 9 other posts that mention it, check those out.
by chulett
Wed Aug 04, 2010 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To remove previous job logs
Replies: 11
Views: 3126

Please let me know whether it will keep only 7 days old logs which is mentioned at admin level from the next run. No, not in the releases prior to 8.x. As already noted, that value only applies to new jobs so as you are doing the manual purge you will need to set the auto-purge setting to use, per ...
by chulett
Wed Aug 04, 2010 9:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter
Replies: 5
Views: 2723

FYI - They don't need to be multi-instance to "pass different parameter" but they will if you want the jobs to run simultaneuously.
by chulett
Wed Aug 04, 2010 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Download file with the DataStage
Replies: 6
Views: 2275

The new name for the SOA product, which was the new name for the RTI product. :wink: