Search found 53125 matches

by ray.wurlod
Fri Mar 14, 2008 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting irregular values after using Surrogate Key Generator
Replies: 1
Views: 956

You can never get them in sequence in parallel mode. Think about it. With two nodes, one side is generating the odd numbers, the other node is generating the even numbers. Assuming both nodes are operating at the same speed, the output would be in sequence: 0,1,2,3,4,... But with variations in speed...
by ray.wurlod
Fri Mar 14, 2008 4:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executing shell Script
Replies: 10
Views: 2047

Please post how you resolved this.

Another solution would be to create your own after job subroutine that invokes the one that's currently there then executes the shell script through DSExecute.
by ray.wurlod
Fri Mar 14, 2008 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how can we suppress the warnings in sequence
Replies: 10
Views: 2447

Finding the solution in the course of my regular activities. Client asked whether there was a way that did not generate a warning (as opposed to suppressing, since message handlers don't apply to job sequences).
by ray.wurlod
Fri Mar 14, 2008 4:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: any way to find which user is using which job
Replies: 16
Views: 3382

Network error. The UNLOCK command does not exist in a project unless you've used one of the unlock options from DS.TOOLS (which emplaces the UNLOCK command) or you've emplaced the command yourself. We're not going into that. You can unlock a visible lock from Cleanup Resources if you have sufficient...
by ray.wurlod
Fri Mar 14, 2008 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Find all projects in Datastage
Replies: 4
Views: 1628

Open Manager, switch to Host View.

There is a tool on the toolbar for this, or you can enable it from the View menu.

Note that, although you can see all projects, you can still only be attached to one project at any one time.
by ray.wurlod
Fri Mar 14, 2008 4:32 pm
Forum: General
Topic: Cannot edit the Target or Source Stages
Replies: 3
Views: 1059

Personal preference stuff is in the HKEY_CURRENT_USER hive of the registry.
by ray.wurlod
Fri Mar 14, 2008 4:31 pm
Forum: General
Topic: DataStage 7.5.2 MVS
Replies: 8
Views: 3817

eostic wrote:Like Ray, it's been a long time since I've used MVS Edition in earnest, ...
Ernie

:lol:
by ray.wurlod
Fri Mar 14, 2008 4:28 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: IBM Information Server
Replies: 3
Views: 2743

Welcome aboard. First, DataStage and QualityStage is now a combined client. What you see in that client depends on what you license - if you only license QualityStage you see only the components (stages) needed for QualityStage jobs. Beware that the hardware requirements for IBM Information Server, ...
by ray.wurlod
Fri Mar 14, 2008 5:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conversion error with aggregator stage
Replies: 1
Views: 818

It's been answered before. Search for the answer.
by ray.wurlod
Fri Mar 14, 2008 5:47 am
Forum: General
Topic: Display User Parameters in the job log
Replies: 2
Views: 666

They are already shown, in the "job starting" event (for the job) or the "job run requested" event (for a controller).
You can also see the job parameter values in Status view, by looking at the detailed status of the job (provided the job has not been compiled since it was last run).
by ray.wurlod
Fri Mar 14, 2008 3:49 am
Forum: General
Topic: Help regarding Datastage ORacle stage
Replies: 9
Views: 5161

8.1 or 8.0.1 ? I understood that 8.1 would be out "later this year". Import the column definitions from Oracle and load those into your job, so as at least to avoid the metadata mismatch issues that may be at the heart of your problem. Make sure you handle null data properly in your job design.
by ray.wurlod
Fri Mar 14, 2008 3:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation error help using Transformer/Peek
Replies: 7
Views: 4050

I try to avoid using a parallel job to process one row. I prefer a server job. If the client insists on all parallel jobs I try to talk them out of it. If they still insist, I make sure it uses a single-node configuration file - any more is wasted.
by ray.wurlod
Fri Mar 14, 2008 3:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Compile time
Replies: 1
Views: 1494

Exactly the same things have to happen whether you compile from Designer or from the command line. Therefore it should make no difference to the total time taken.
by ray.wurlod
Fri Mar 14, 2008 3:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle Stage : Array Size
Replies: 19
Views: 7580

Welcome aboard. I think your analysis is exemplary. That seems to be the way it behaves. Have you done anything with Prefetch Memory setting? What versions of Oracle, DataStage, and OCI stage are you using? It's a bit of a worry, really. How would one be sure, fetching lakhs of rows with an array si...
by ray.wurlod
Fri Mar 14, 2008 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problems with invalid dates
Replies: 1
Views: 680

How do you expect US to check it? You need to build in your own validation rules. Read the field as VarChar and work in a Transformer. You can effect import to date datatype for the CCYYMMDD format by specifying an appropriate format string in the extended column properties. But there is nothing you...