Search found 53125 matches

by ray.wurlod
Sun Jun 24, 2007 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparce Lookup error
Replies: 7
Views: 1617

Forget the row counts on the link - these might not be updated for a number of reasons.

Is the job running to completion? Are the lookups working? Enable player process row counts and get the row counts into the log file.
by ray.wurlod
Sun Jun 24, 2007 3:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KBADifferent does not work Fractional part of Dec is 10 dig
Replies: 22
Views: 5870

PRECISION <> EXACTNUMERIC

PRECISION is a statement that can be inluded in a BASIC routine.
EXACTNUMERIC is a configuration directive in uvconfig

They are related by the fact that PRECISION must be less than EXACTNUMERIC but it remains the case that PRECISION must also be less than 15.
by ray.wurlod
Sun Jun 24, 2007 4:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin dump problem
Replies: 6
Views: 2443

Try the Orchestrate Administration manual.
by ray.wurlod
Sun Jun 24, 2007 4:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot Open executable job file RT_CONFIG1303- Director Hang
Replies: 14
Views: 3649

Create a new job.
Copy the DATA.30 file from that job's RT_CONFIGnnnn to the jobs that are exhibiting the problem.
Then try re-compiling those jobs.
by ray.wurlod
Sun Jun 24, 2007 4:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: a database deadlock occured during this operation
Replies: 4
Views: 962

That's at best a workaround. If 8.0 is causing deadlocks in the Repository I, for one, want to know how, where and why so that I can avoid the situation. Please ask your support provider to stay with it. Having to run scripts to clear deadlocks is not my idea of a professional application.
:x
by ray.wurlod
Sun Jun 24, 2007 4:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading output form Command Execute Stage
Replies: 7
Views: 2293

StartLoop activity supports two kinds of loop: a counted loop and a "list of things" loop. Investigate more thoroughly.
by ray.wurlod
Sun Jun 24, 2007 4:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KBADifferent does not work Fractional part of Dec is 10 dig
Replies: 22
Views: 5870

We are not discussing scale. We are discussing an artifact of working in a data-typeless environment, where decimal numbers are rounded to PRECISION decimal places following any arithmetic operation (originally so that display columns are not too wide). For most currency operations, PRECISION 4 is f...
by ray.wurlod
Sat Jun 23, 2007 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading and Deleting in a Single Unit of Work
Replies: 7
Views: 1220

There's no tab, but there IS an available property to add.
by ray.wurlod
Sat Jun 23, 2007 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CSV files unformated in Parallel jobs
Replies: 1
Views: 620

Welcome aboard. :D

Get "them" to send you a valid CSV file. The CSV rules stipulate the same number of fields in each row.

If you can't get that, read each row as a single VarChar and parse it yourself, perhaps in a Transformer stage, perhaps in a Column Import stage.
by ray.wurlod
Sat Jun 23, 2007 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data display problem
Replies: 2
Views: 751

In particular, is there a leading \x00 character?
by ray.wurlod
Sat Jun 23, 2007 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer
Replies: 4
Views: 1394

I do know. It can not be done.

RCP is only ever about pass-through columns. Anything you want to derive or constrained must be named explicitly.

You might contemplate building the constraint expression as or containing a job parameter.
by ray.wurlod
Sat Jun 23, 2007 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot stage giving very poor performance
Replies: 8
Views: 2656

That - along with the coding exercise itself - should tell you something about the amount of work that is involved.

It's time to manage expectations better.
by ray.wurlod
Sat Jun 23, 2007 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: deleting rows from a table and then inserting rows
Replies: 6
Views: 1217

Can you run two jobs in succession, one with Delete, the other with Insert, using the same keys?
by ray.wurlod
Sat Jun 23, 2007 7:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deadlock Daemon mode
Replies: 1
Views: 1610

1. Someone executed dsdlockd -p command.

2. The deadlock daemon on waking found defunct processes and initiated a cleanup.

3. Someone (whose pid is given) started the deadlock daemon, maybe from DEADLOCK.MENU, maybe from the command line. If pid = 1 this was the auto-start on re-boot.
by ray.wurlod
Sat Jun 23, 2007 7:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding log maintanance in datastage
Replies: 9
Views: 2080

You don't need administrator access. All you need is read/write access to the DSParams file for project-defaults set in the Administrator client, and read/write access to the job log to set for a particular job.