Search found 42189 matches

by chulett
Wed May 26, 2010 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation of parallel job taking more time
Replies: 9
Views: 3241

Yes, transformers invoke the C++ compiler and if you have a single concurrent license, it could be "slow" as you wait for the compiler to come free.
by chulett
Wed May 26, 2010 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Moving From 8.0 to 8.1: Through upgrade or fresh install ?
Replies: 9
Views: 3082

Upgrades should be painless, they were before 8.x but no clue in our new world. And no need for a recompile, it handles all that automagically.
by chulett
Wed May 26, 2010 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation of parallel job taking more time
Replies: 9
Views: 3241

Of course, that's a given. Do you understand why? Can you answer the other questions, please?
by chulett
Wed May 26, 2010 6:58 am
Forum: General
Topic: How to Display the Day from the date value in parallel job
Replies: 13
Views: 2925

Same way - by using the appropriate date format string: %eee off the top of my head. Check the docs.
by chulett
Wed May 26, 2010 6:51 am
Forum: General
Topic: How to Display the Day from the date value in parallel job
Replies: 13
Views: 2925

Display? And by "day" do you just mean the day number (1-31) or the day name? Regardless, check the DateToString() function and use the appropriate 'Date format string'.
by chulett
Wed May 26, 2010 6:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create file in Local drive
Replies: 7
Views: 1861

Or get the limit raised. A 2GB limit is so... 80s. :wink:
by chulett
Wed May 26, 2010 6:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Expect to abort job after ...
Replies: 8
Views: 3122

Yes, that would be best. A script can also be used to pass back a non-zero return / exit code and the job will recognize it, however (from memory) it will log a warning rather than abort. :?
by chulett
Wed May 26, 2010 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Information
Replies: 14
Views: 12151

Please, for goodness sakes, answer my dang questions regarding your job design. If your design is wrong, we could be chasing wild geese that a simple redesign would solve. :evil:
by chulett
Wed May 26, 2010 6:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Stage with an Upsert option
Replies: 2
Views: 1198

I would guess so as well. Does this happen if you run the job on a single node?
by chulett
Wed May 26, 2010 6:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switch/Case
Replies: 11
Views: 2508

Don't think he meant that one. :wink:
by chulett
Wed May 26, 2010 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to update null to zero
Replies: 7
Views: 3955

How is this any kind of WORKAROUND? You are (or certainly should be) Resolved now. :?
by chulett
Wed May 26, 2010 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Performance
Replies: 2
Views: 1080

Exactly, it's an average.
by chulett
Wed May 26, 2010 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Run time column propagation
Replies: 9
Views: 3502

Well, there you go. Read all about RCP in the Parallel Job Developer Guide, page 26. You are missing a critical piece of information.
by chulett
Wed May 26, 2010 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: INVOCATION ID's
Replies: 3
Views: 3136

For Multi-Instance jobs, the JobName would be the base job name, followed by a dot and the Invocation ID. Then get a handle for that.
by chulett
Wed May 26, 2010 6:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Functions to get total number of records
Replies: 10
Views: 2468

Please use meaningful subject lines, it helps searchers of the site. Your Subject and Additional Info should have been swapped, that or just skipped the whole "Hi" part as we're quite the friendly bunch and are all about the solutions. :wink: All that can be done "after job" from...