Search found 53125 matches

by ray.wurlod
Sun Jul 06, 2008 6:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: get user defined environment variable in job sequence
Replies: 11
Views: 3406

If the parameter is a parameter of the job sequence itself, then you can simply use it directly to supply the parameter value in any Job activity. Just use the "insert parameter value" tool. Encrypted or not, it will work.
by ray.wurlod
Sun Jul 06, 2008 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IBM Information Server - How to run the jobs on condition
Replies: 3
Views: 1022

You can not rely on Job1. Job1 (except through use of an after-job subroutine) can only report the number of rows it sent to table XYZ, not how many were successfully inserted. You have to do something in between to test how many rows the table has. This could be a command or a routine, or another j...
by ray.wurlod
Sat Jul 05, 2008 3:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IBM Information Server - How to run the jobs on condition
Replies: 3
Views: 1022

When you draw an arrow from one activity to another, there is an extra tab on the upstream activity called "Trigger". Some "canned" triggers are available, for example "OK", "Warning" and "Failure", and you can create your own custom triggers using the expression builder. In your specific case, you ...
by ray.wurlod
Sat Jul 05, 2008 9:06 am
Forum: IBM QualityStage
Topic: Peek stage
Replies: 1
Views: 1304

Welcome aboard. There is no such thing as a Peek stage in QualityStage version 5. Please post in the correct forum (Enterprise Edition).
by ray.wurlod
Sat Jul 05, 2008 12:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Steps involved in Deployment
Replies: 4
Views: 1061

Deploy on what hardware configuration? SMP, MPP cluster or grid? The answer will be different in each case.
by ray.wurlod
Fri Jul 04, 2008 11:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Perform update/delete ops in Dataset
Replies: 5
Views: 999

No it isn't. This is specifically barred because it is a blocking operation (would prevent pipeline parallelism).

If you're in an SMP environment, why not put a UniVerse stage into a server container?
by ray.wurlod
Fri Jul 04, 2008 2:57 pm
Forum: General
Topic: Sydney conference cancelled
Replies: 0
Views: 648

Sydney conference cancelled

The Information Management Technical Conference in Sydney 28-31 July has been cancelled but will, I'm told, be re-scheduled.

If you go to the education website you will find a link on the left hand side to Conferences & Events. Watch that space.
by ray.wurlod
Fri Jul 04, 2008 2:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance statistics
Replies: 1
Views: 664

The "performance" statistics in Designer are purely cosmetic. Rely instead upon the row counts reported in Director (log or monitor).

Search the forum for advice on how to start the job monitor.
by ray.wurlod
Fri Jul 04, 2008 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Modify stage
Replies: 1
Views: 703

What is "max@"? What is the input data type?

Add an extra specification to the Modify stage containing just the single word NOWARN.
by ray.wurlod
Fri Jul 04, 2008 2:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How we will get folder stage functionality in parllel
Replies: 6
Views: 1611

That's no less true using a Folder stage.
by ray.wurlod
Fri Jul 04, 2008 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Perform update/delete ops in Dataset
Replies: 5
Views: 999

Data Sets do not support update or delete. Data Sets are not database tables. Use a database table, perhaps SQL Server or Access via ODBC.
by ray.wurlod
Fri Jul 04, 2008 2:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Increment Row value by 1
Replies: 4
Views: 1563

Why did you not mention this added requirement in your original question? Then you have no solution if this integer is your key. If this integer is not the primary key, then you could have an after insert trigger to generate its value from a sequence. DataStage can not provide something that depends...
by ray.wurlod
Fri Jul 04, 2008 4:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Empty string to Date column
Replies: 1
Views: 907

You can not assign an empty string to a Date column, for the simple reason that "" is not a valid date.
by ray.wurlod
Fri Jul 04, 2008 4:54 am
Forum: Site/Forum
Topic: Delete is not working in ODBC stage for SQL server 2000
Replies: 4
Views: 3298

You can open a new thread there, or post a message here asking the moderator to move this thread to the correct forum.

Moderator: please move to parallel forum
by ray.wurlod
Fri Jul 04, 2008 4:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read Line feeds in seqential file stage
Replies: 10
Views: 3127

Read again what I wrote.

Remove those linefeeds that follow "Z".