Search found 42189 matches

by chulett
Tue Aug 04, 2015 12:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bulk-load problem
Replies: 10
Views: 5362

I'm assuming Arnd's question was meant for tj_user...
by chulett
Tue Aug 04, 2015 9:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: understanding external filter stage
Replies: 7
Views: 2326

You need to look closer at the example. They are not simply passing 'only filename' to the command, the contents of the file are being cat'd to the command. And we have no idea what exactly is in the file (other than whatever 'special characters' were being passed on the command line that was causin...
by chulett
Tue Aug 04, 2015 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: understanding external filter stage
Replies: 7
Views: 2326

Those are called options for a reason. :wink:
by chulett
Tue Aug 04, 2015 7:44 am
Forum: General
Topic: Projects are marked "broken" in the DataStage Admi
Replies: 7
Views: 4164

How hard is it to answer a simple yes/no question? And how is that any kind of 'same issue'? :?

Please explain to us what you were doing that resulted in that error and if you can, post the remainder of it because it looks like we got short-changed.
by chulett
Tue Aug 04, 2015 6:55 am
Forum: General
Topic: Projects are marked "broken" in the DataStage Admi
Replies: 7
Views: 4164

Re: Projects are marked "broken" in the DataStage

mandyli wrote:This may be due to insufficient resources - please try to delete the project again
Again I'll ask - did you?
by chulett
Tue Aug 04, 2015 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: understanding external filter stage
Replies: 7
Views: 2326

I thought you said you knew what the tr command does.

The example linked to was extremely generic so what exactly happens depends on what is in a1, i.e. 'the content of the argument'.
by chulett
Mon Aug 03, 2015 3:36 pm
Forum: General
Topic: Projects are marked "broken" in the DataStage Admi
Replies: 7
Views: 4164

Or insufficient resources. Did you try to delete it again?
by chulett
Mon Aug 03, 2015 9:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase IQ Wire Protocol Driver - problem with inserting data
Replies: 7
Views: 3152

Doesn't sound like any kind of character conversion issue to me but who knows. Time to involve support if you haven't done so already.
by chulett
Mon Aug 03, 2015 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern - String Extraction
Replies: 7
Views: 3754

Sounds like you need to re-read the documentation on the Convert function. :wink:

If you need more help that that, start your own post and let us know what problem you are trying to solve. Thanks.
by chulett
Sun Aug 02, 2015 8:09 am
Forum: General
Topic: Job sequence scenario
Replies: 10
Views: 2797

Yes. Use a single Sequencer before it that all three funnel into and then write a custom condition. Another option would be a simple routine to count the number of successes and then trigger after that if it is > 1.
by chulett
Sat Aug 01, 2015 6:36 am
Forum: General
Topic: Job sequence scenario
Replies: 10
Views: 2797

Use the Nested Condition stage.
by chulett
Fri Jul 31, 2015 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: First and last record
Replies: 7
Views: 2900

Been wondering the same thing, all of this conversating about "last record alone" - if that's all you need just use tail -1 as noted and never mind about all this parallel mode stuff.

Oh, and... whatever happened to the "first record" you mentioned in your subject?
by chulett
Fri Jul 31, 2015 12:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar numeric to Oracle decimal conversion
Replies: 12
Views: 5739

Sorry, but... how exactly is that an issue?
by chulett
Fri Jul 31, 2015 9:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar numeric to Oracle decimal conversion
Replies: 12
Views: 5739

Including those in scientific notation? Hmmm...

By golly, it does! :D
by chulett
Fri Jul 31, 2015 6:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar numeric to Oracle decimal conversion
Replies: 12
Views: 5739

Move away from Server jobs where appropriate. Leverage Server jobs where appropriate. Basically Ray is wondering if there is anything you are doing in this job that requires it to be a Parallel job? Your 'moving awaying' not withstanding, of course.