Search found 53125 matches

by ray.wurlod
Wed Apr 23, 2008 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ERROR: Cannot find 'BEGIN HEADER'
Replies: 3
Views: 1860

BEGIN HEADER is a DSX file component. Are you sure you're using "import from XML" rather than "import DataStage components" (from DSX)?
by ray.wurlod
Wed Apr 23, 2008 3:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Field level error logging
Replies: 3
Views: 910

You need to design this yourself. There is no automatic mechanism. However, you can put anything you like into a target table, provided you can determine it somehow in the ETL tool. How do you propose to determine which column threw the error?
by ray.wurlod
Wed Apr 23, 2008 3:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Field level error logging
Replies: 3
Views: 910

Moderator: please move to parallel forum
by ray.wurlod
Wed Apr 23, 2008 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using Join stage for joining three inputs
Replies: 2
Views: 859

With full outer join you should get eight.
by ray.wurlod
Wed Apr 23, 2008 3:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using Join stage for joining three inputs
Replies: 2
Views: 859

Moderator: please move to parallel forum
by ray.wurlod
Wed Apr 23, 2008 3:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Custom SQL run time error in OCI lookup stage.
Replies: 4
Views: 1546

The :3 indicates that the third entry in the Columns grid was marked as Key (and was the first column so marked).
by ray.wurlod
Wed Apr 23, 2008 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS logs accessing the logs so they can be placed in a oracle
Replies: 7
Views: 2186

You're on the right track, but the metadata of repository tables is blocked from being imported. The important column names from DS_JOBS are: NAME VARCHAR(255) NOT NULL PRIMARY KEY CATEGORY VARCHAR(255) NOT NULL JOBNO VARCHAR(10) NOT NULL You can see (but not import) all the ...
by ray.wurlod
Wed Apr 23, 2008 7:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cofiguration file
Replies: 3
Views: 902

That's a configuration file for an SMP system. An SMP system has only one physical node, which means that the fastname property of each processing node will be the same for every node defined in the configuration file. In your particular case, the name of the machine is "auriga" in each node, so tha...
by ray.wurlod
Wed Apr 23, 2008 7:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Droping Columns in FILTER stage
Replies: 8
Views: 1773

I never use RCP. It destroys any hope you may have had of performing lineage analysis.
by ray.wurlod
Wed Apr 23, 2008 7:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic Job Execution
Replies: 6
Views: 1592

You could do this with custom job control code, but I can't envisage a tidy way to do it with a job sequence, unless there were execution paths in the job sequence for every possible job activity. My reason for making this assertion is that the job name is hard coded in a Job activity; there is (pre...
by ray.wurlod
Wed Apr 23, 2008 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Monitor didn't work for 2 target Oracle Enterprise Stage
Replies: 3
Views: 1194

Do you have operator combination enabled?
by ray.wurlod
Wed Apr 23, 2008 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error during file comparision
Replies: 8
Views: 2342

It's all in the message - the Field Width property is not set.
by ray.wurlod
Wed Apr 23, 2008 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to connect to host: error code 39125
Replies: 20
Views: 7877

You will find that you can not delete entries from system tables. They have special protection. You need to use specific utilities (such as DDL statements) to have any impact on these tables. But we have established already that you ought not to need to do so, since the project exists (as a director...
by ray.wurlod
Wed Apr 23, 2008 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter Condition in sequential file
Replies: 15
Views: 5122

"It's not working" is singularly uninformative.

If you want us to help you need to specify the actual command(s) that you used, what you expected to get, what you actually got, and why you believe that they are different.