Search found 53125 matches

by ray.wurlod
Tue May 27, 2008 6:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Got certified in Datastage
Replies: 40
Views: 13776

If you pester enough people they might just give you one. But I doubt it.

Study, learn, practice, study, learn and practice some more, then "bite the bullet" and attempt the test.
by ray.wurlod
Tue May 27, 2008 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: methods for aggregator stage
Replies: 1
Views: 964

The difference is how memory is managed. HASH method builds a hash table in memory with one row for each combination of grouping values. It can not generate any output rows until all rows have entered the Aggregator stage. SORT does the same but flushes and frees that memory when any of the sorted c...
by ray.wurlod
Tue May 27, 2008 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to connect to host,he connection is broken (81002))
Replies: 2
Views: 1794

If IP addresses are allocated dynamically make sure that the server still has the same address after being re-booted.
by ray.wurlod
Tue May 27, 2008 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generating Job auditing information
Replies: 4
Views: 1253

Get ETLStats anyway, and review the code. All your answers are there.
by ray.wurlod
Tue May 27, 2008 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot stage error
Replies: 3
Views: 1110

Then please mark the thread as Resolved.
by ray.wurlod
Tue May 27, 2008 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reason for the Sybase server warning.
Replies: 3
Views: 1482

I'm sure this has been answered in the past. Search.
by ray.wurlod
Tue May 27, 2008 6:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Report
Replies: 17
Views: 7302

Please don't overquote. It's a waste of space on the server. Everything needed already exists in the thread.

The answer to question 1 is "Yes". Question 2 is rhetorical (I wonder why...).
by ray.wurlod
Tue May 27, 2008 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need last 5 transactions
Replies: 2
Views: 1390

Why can't you just use the extraction SQL to get the five most recent?

Otherwise, order by transaction date in reverse order and select only the first five.

I take it the "p" is "sopurce" is a silent "p", as in "swimming"?
:lol:
by ray.wurlod
Tue May 27, 2008 6:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job abort communication in Sequence calling Sequence
Replies: 9
Views: 3117

Log warnings for any activity that fails to complete successfully. That will alert the parent sequence that there is something for which to search. It can use a routine that invokes DataStage API functions to examine the log. If you use Exception Handler or explicit failure handling, you can also wr...
by ray.wurlod
Tue May 27, 2008 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find out if a certain stagetype is used in a project
Replies: 9
Views: 2930

That will have to be done in each project (but, then that was your question). However, without writing some fairly "hacky" code, so will any other method if you want the answer for all projects.
by ray.wurlod
Tue May 27, 2008 6:23 am
Forum: General
Topic: Road to Datastage Certification !
Replies: 6
Views: 2143

... not to mention Private Message as well!
:x
by ray.wurlod
Tue May 27, 2008 6:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Report
Replies: 17
Views: 7302

The words "in a single log file" in the original post.
by ray.wurlod
Tue May 27, 2008 6:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can I make a schedule to rerun the job when it is failed???
Replies: 6
Views: 1322

SLEEP is seconds. NAP is milliseconds.
by ray.wurlod
Tue May 27, 2008 6:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can I make a schedule to rerun the job when it is failed???
Replies: 6
Views: 1322

SLEEP is seconds. NAP is milliseconds.
by ray.wurlod
Tue May 27, 2008 6:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email sending with attachment
Replies: 10
Views: 2990

How do you send email to multiple addressees without DataStage? Use the same addressing convention within DataStage.