Search found 53125 matches

by ray.wurlod
Tue Jan 30, 2007 6:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key using sequence ?
Replies: 34
Views: 13357

Similar, but not the same. C arrays depend on knowing the address in memory of each element. Dynamic arrays are navigated based on the character position in the string with respect to the beginning of the string (which, yes, is a position in memory, but not one that's stored as a pointer anywhere) (...
by ray.wurlod
Tue Jan 30, 2007 6:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reference link get the first row of the reference table
Replies: 29
Views: 4178

kumar_s wrote:
ray.wurlod wrote:I suspect kumar_s meant "linking" rather than "liking".

Problem with Keyboard and Chair. :oops:
Ray, You could have used atleast LoL emoticons. :lol:

Why? It was a serious observation (not a criticism).
by ray.wurlod
Tue Jan 30, 2007 6:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lock and unlock jobs
Replies: 20
Views: 5670

DS_AUDIT preserves all history of modification, unless the component is actually deleted and re-created (exported and re-imported).
by ray.wurlod
Tue Jan 30, 2007 6:03 pm
Forum: General
Topic: How to generate a sequence number in Datastage ?
Replies: 2
Views: 3005

Server or Parallel?

The answer is different depending on job type.

Please post in the correct forum.

Your question will be answered when it appears on the Server or Parallel forum.
by ray.wurlod
Tue Jan 30, 2007 6:02 pm
Forum: IBM QualityStage
Topic: cannot see output in quality stage
Replies: 9
Views: 4503

What is the NAME of the output file in your Survive stage? Can you use find on the server to see whether it exists anywhere there?

What check boxes did you check on the job run?
by ray.wurlod
Tue Jan 30, 2007 3:48 pm
Forum: IBM QualityStage
Topic: cannot see output in quality stage
Replies: 9
Views: 4503

Did you do what I asked?
by ray.wurlod
Tue Jan 30, 2007 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key using sequence ?
Replies: 34
Views: 13357

It's not a C array. It's a DataStage dynamic array, which is nothing more than a delimited string. The delimiter character is a "field mark" character, which is accessible as the system variable @FM.
by ray.wurlod
Tue Jan 30, 2007 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lock and unlock jobs
Replies: 20
Views: 5670

Write the routine as a transform function; it can then be run from its Test grid. But some level of management supervision is still required to prevent misuse.
by ray.wurlod
Tue Jan 30, 2007 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Set Management is very slow!
Replies: 20
Views: 4288

Entire partitioning? With 16-way parallelism that would mean you're moving (16 * 1.22) MB of data.

You really haven't provided enough information for good diagnosis. Dump the score and post that.
by ray.wurlod
Tue Jan 30, 2007 3:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checking Operator Error
Replies: 5
Views: 2026

A Sequential File stage supports parallel execution when reading multiple files. If you have only one File property and have not selected multiple readers per node, the parallel option will be disabled.
by ray.wurlod
Tue Jan 30, 2007 3:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: maximum number of jobs per project
Replies: 3
Views: 1601

This is not a DataStage limit, but an operating system limit on the number of subdirectories in a directory. On Solaris, for example, it's 32K. Each job creates up to eight subdirectories, but more usually six or seven. Assuming eight, that's a limit of about 4K jobs on Solaris. For ease of manageme...
by ray.wurlod
Tue Jan 30, 2007 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lock and unlock jobs
Replies: 20
Views: 5670

Put a big, brighty-coloured annotation on it

I'm working on this.
DO NOT change it!
by ray.wurlod
Tue Jan 30, 2007 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nulls in Pipe delimited file
Replies: 8
Views: 2626

If you set the Null Field Value property to "" you will get adjacent delimiters in your output file.
by ray.wurlod
Tue Jan 30, 2007 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Set Management is very slow!
Replies: 20
Views: 4288

It's not normal. Can't say if you're doing something wrong because I don't know what you're doing. What other load exists on the machine? Is the Data Set being accessed by another job at the same time?