Search found 53125 matches

by ray.wurlod
Tue Nov 21, 2006 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stored Procedure
Replies: 19
Views: 3636

You don't pass output parameters. You receive them. They should then appear as two columns on the output link of the Stored Procedure stage.
by ray.wurlod
Tue Nov 21, 2006 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generating a report using a Datastage tool
Replies: 11
Views: 2764

Why do you think anything is missing? What do you think is missing?
by ray.wurlod
Tue Nov 21, 2006 1:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterpise Stage Warnings
Replies: 8
Views: 2042

Oracle has never been horribly consistent externally with numeric data types. Adjust your metadata to match what Oracle generates, and this ought to eliminate the warning. Adjust the data type explicitly in your job.
by ray.wurlod
Tue Nov 21, 2006 1:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel job functions
Replies: 12
Views: 4311

Clearly this is "vapourware" at this time. If there is enough interest then maybe there will be time found to put one together. Remember that developing training takes much longer than presenting it - depending on the delivery model the ratio may be up to 100:1.
by ray.wurlod
Tue Nov 21, 2006 1:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup failing
Replies: 2
Views: 778

Explain what you mean by "rejected". Maybe you need to rethink the design, to handled failed lookups correctly - not reject them, but insert them into the target database.
by ray.wurlod
Tue Nov 21, 2006 1:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling of a Job
Replies: 15
Views: 4170

Can you please outline what you think this entry is doing?
by ray.wurlod
Tue Nov 21, 2006 1:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: some upgrade questions
Replies: 7
Views: 1964

Have you checked for "upper case o versus zero" and "upper case i versus lower case L" in the auth codes?
by ray.wurlod
Tue Nov 21, 2006 1:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot find record JOBPARAMINSTS in executable job
Replies: 10
Views: 4497

Add one extra parameter to the job properties. It doesn't have to do anything. Then recompile. This will force a new parameters collection to be built. Then remove the job from the Schedule (if indeed it is there), and re-schedule it. This process should prompt for job parameter values and, based on...
by ray.wurlod
Tue Nov 21, 2006 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: difference between the two statements
Replies: 3
Views: 865

Stages, link ends (pins), jobs, annotations, containers...
by ray.wurlod
Tue Nov 21, 2006 12:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel job functions
Replies: 12
Views: 4311

You haven't looked hard enough - there ARE faults. But in general they do have adequate breadth of coverage, if not perhaps the desired depth. Would anyone be interested in (paying to take) a training class on derivations in parallel jobs? Probably two or three days, with lots of hands-on exercises.
by ray.wurlod
Tue Nov 21, 2006 12:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error in px
Replies: 12
Views: 7360

Thanks for letting us know.

My reaction (yuk) is unchanged.
by ray.wurlod
Tue Nov 21, 2006 12:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterpise Stage Warnings
Replies: 8
Views: 2042

The data types in the result set of the UNION query should match those in the SELECT clause of the first SELECT statement in the UNION.
by ray.wurlod
Tue Nov 21, 2006 12:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Windows Vs UNIX
Replies: 8
Views: 2207

Parameters, my friends, and more parameters. Don't do ANYTHING platform-specific. The migration itself is quite straightforward; it is exactly the same technique you would use on homogenous platforms. You WILL need to recompile everything on the AIX machine, since it will use a different C++ compile...
by ray.wurlod
Tue Nov 21, 2006 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: User Status
Replies: 19
Views: 6948

There's nothing to install. All you have to do is license it. All the pieces are already in place.
by ray.wurlod
Tue Nov 21, 2006 12:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HAsh files creation
Replies: 3
Views: 817

Edit an export file, then re-import.