Search found 42189 matches

by chulett
Wed Apr 07, 2010 7:32 am
Forum: General
Topic: How can I get trailing zeros removed from output?
Replies: 3
Views: 1366

Pretty much just like that. Was hoping the OP would take a stab at it on their own first, however.
by chulett
Wed Apr 07, 2010 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

But don't think you still need to Abort the Sequence to trigger the checkpoint restarting you no longer have. Abort it for other reasons, perhaps, but not that one.
by chulett
Wed Apr 07, 2010 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I load comp-3 (packed decimal) data
Replies: 4
Views: 2108

OK, that's what I was afraid of. COMP-3 is packed decimal and packed is packed, not even EBCDIC or ASCII technically, just... packed. It can look like hex data if you look at the raw data, but it isn't. Why are you "not able to read it" using the CFF? What exactly are you doing and what er...
by chulett
Wed Apr 07, 2010 6:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: db2 xmeta Issue:- Max log file utilization (heapsize)
Replies: 2
Views: 3280

It has everything to do with the Health Monitor's "let me know when utilization goes over 85%" alarm going off now that it's at 91%. Suggest you talk to your DB2 DBA.
by chulett
Wed Apr 07, 2010 6:48 am
Forum: General
Topic: Upgrading DataStage Server Edition to a Parallel Extender
Replies: 5
Views: 1685

Only time for very short answers this morning:

1. Yes.
2. Yes, technically.
3. Backup, backup, backup. Config info comes with the product.
by chulett
Wed Apr 07, 2010 6:44 am
Forum: General
Topic: How can I get trailing zeros removed from output?
Replies: 3
Views: 1366

You'll have to declare the output as a string and then trim any trailing zeroes. After that, the comma too if it is now the last character.
by chulett
Wed Apr 07, 2010 6:42 am
Forum: General
Topic: Oracle Enterprise Loader - Direct vs. Conventional Path
Replies: 3
Views: 1646

Re: Oracle Enterprise Loader

sridharvg wrote:Can anyone tell me about the Direct and Conventional paths used in Oracle loader and also how are these related to indexes.
Sure, your DBA. :wink:
by chulett
Wed Apr 07, 2010 6:42 am
Forum: General
Topic: Convert number from US_NLS to EUROPEAN_NLS
Replies: 5
Views: 2175

Then it's time to mark your post as Resolved it seems, using the button at the top of the page.
by chulett
Tue Apr 06, 2010 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RTI WS doesn't return data if above a certain amount of rows
Replies: 28
Views: 8827

MT wrote:There are not so many guys having RTI experience anyway
Unfortunately true. Perhaps Ernie will add something once he comes back from his self-imposed exile.

ps. There is a dedicated "RTI" forum here. FYI.
by chulett
Tue Apr 06, 2010 11:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ParamValue/Limitvalue is not appropriate
Replies: 3
Views: 17571

There are 62 matches for that error message. I picked one at random and it seems to have everything you need in it. If it doesn't help, please let us know why, which part isn't making enough sense and we'll see what we can do about that.
by chulett
Tue Apr 06, 2010 9:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error while creating a copy of a job
Replies: 6
Views: 3408

Unfortunately, the only place "Unable to get Eobject" has been mentioned is in this thread. You'll need to take this to your official support provider, it seems.
by chulett
Tue Apr 06, 2010 9:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I load comp-3 (packed decimal) data
Replies: 4
Views: 2108

What makes you think you have "hex data" in your COMP-3 field? :?
by chulett
Tue Apr 06, 2010 9:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resize VOC
Replies: 13
Views: 4638

Why do you think this needs to be resized? I'm curious what brought you here, asking that. Are you having... issues? :?
by chulett
Tue Apr 06, 2010 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple instance job finished, but don't do anything
Replies: 11
Views: 3372

Then it seems you need to look at whatever checks the last character of the Invocation ID and how it goes sideways when it is a 'Y'.
by chulett
Tue Apr 06, 2010 9:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

So how to design the sequence as my objective before? As already noted. Your requirements preclude the use of the automatic checkpointing, hence the suggestion to disable those compiler options. You need to control the job flow using triggers, for example if you don't want an aborted job to stop th...