Search found 42189 matches

by chulett
Mon Oct 06, 2008 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Set of values from a data base table to Sequence Job
Replies: 7
Views: 1552

Why, so you did. I didn't bother to scroll back that far. :wink:
by chulett
Mon Oct 06, 2008 7:49 am
Forum: General
Topic: Rows per commit
Replies: 4
Views: 1437

Interesting.
by chulett
Mon Oct 06, 2008 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Set of values from a data base table to Sequence Job
Replies: 7
Views: 1552

Put them in a delimited string and then parse it back into the component pieces after fetching it from the user status area.
by chulett
Mon Oct 06, 2008 7:16 am
Forum: General
Topic: Commit after job aborts
Replies: 1
Views: 1145

You're certain both B & C output links (assuming there are two) are set to a Transaction Size of 0?
by chulett
Mon Oct 06, 2008 7:14 am
Forum: General
Topic: Rows per commit
Replies: 4
Views: 1437

I can't imagine this is different in mainfraime jobs but transaction size is a link property everywhere else. That is, each output link will check the number of rows down it and commit as needed.
by chulett
Sun Oct 05, 2008 10:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Black Magic
Replies: 18
Views: 4508

Your choice. That's the 'dynamic' aspect of it,.
by chulett
Sun Oct 05, 2008 10:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error calling subroutine
Replies: 9
Views: 2773

That happens when you reindex the project and not everyone is out of it. You need to ensure yours is the only connection active or otherwise, there are no running jobs, etc etc. Only then rerun the reindex.
by chulett
Sun Oct 05, 2008 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling Datastage Basic Routine Through Command Line
Replies: 8
Views: 4494

Which? 'Command Line' impying from the O/S or 'DataStage Command Language'? If the latter, you'd need to explain what you mean by that - the TCL prompt? :?
by chulett
Sat Oct 04, 2008 9:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding a month in a Date column
Replies: 7
Views: 1352

They stated "5 months and 2 weeks", not days. And yes, does seem like a curious interval and dependant on their definition of a month in this case.
by chulett
Sat Oct 04, 2008 9:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Execute Command Output
Replies: 2
Views: 2826

No probably about it. That's the perils of using a relative path.
by chulett
Sat Oct 04, 2008 12:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding a month in a Date column
Replies: 7
Views: 1352

You'll need to 'remove' the time portion, work the magic on the date portion and then pop the two pieces back together, AFAIK.
by chulett
Sat Oct 04, 2008 10:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding a month in a Date column
Replies: 7
Views: 1352

Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp?
by chulett
Sat Oct 04, 2008 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: same job run simultaneously with different parameters
Replies: 14
Views: 3491

ArndW wrote:No, the project level setting would only allow users to create multiple instance jobs.

There's no project level setting for this that I am aware of.
by chulett
Sat Oct 04, 2008 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar to Date format
Replies: 42
Views: 10909

Never mind the fact that I've already explained what you need to do to make this work. Can't believe we're still going round and round and up to 3 pages now. :?
by chulett
Fri Oct 03, 2008 6:46 pm
Forum: General
Topic: compile multiple jobs
Replies: 8
Views: 2219

Does the "Multi-Job Compiler" no longer exist under 8.x? :?