Search found 53125 matches

by ray.wurlod
Tue Aug 29, 2006 11:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: A Matches question
Replies: 4
Views: 955

"1006":"1011" :"1012" is the same as "100610111012" which probably isn't the pattern you had in mind. I daresay you were looking for something like "1006" : VM : "1011" : @VM : "1012" as your pattern in the first case. But it all seems unnecessarily unwieldy. You have t...
by ray.wurlod
Tue Aug 29, 2006 11:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 9221

Hashed files can, if 64-bit addressing is used, be much bigger than 2GB if required. Check whether "they" have any processes that are removing the .Type30 files, perhaps because the files are zero-length. If they do, oblige them to change the behaviour so as not to delete files called .Type30 becaus...
by ray.wurlod
Tue Aug 29, 2006 10:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to add a generated column
Replies: 4
Views: 1108

Is this a parallel job (as indicated in the original post) or a server job (as indicated by the forum in which you posted it)?
by ray.wurlod
Tue Aug 29, 2006 10:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Header & Trailer Record Warning
Replies: 11
Views: 4343

Also not all UNIX operating systems/emulators support positive arguments for the tail command.
by ray.wurlod
Tue Aug 29, 2006 10:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: floatingpoint decimal is not fully supported adjusting scale
Replies: 2
Views: 1635

It's not a bug, it's how it works. The warning comes from the fact that DataStage uses an IEEE standard for implementing storage of floating point numbers that has limits to its precision - eleven bits are used for the exponent (which is offset by a constant, 1023 if I recall correctly) and 51 bits ...
by ray.wurlod
Tue Aug 29, 2006 10:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: VarChar to Hex
Replies: 8
Views: 3233

You would need a BASIC Transformer to use Oconv() or Iconv() in a parallel job. But your output isn't hex - it appears to be binary. Oconv() can do that too. Please specify your exact requirements. Hex can be managed with "MX" or "MX0C" or "MY" conversion, binary with "MB" or "MB0C").
by ray.wurlod
Tue Aug 29, 2006 10:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which Stages or functionality use the most shared memory?
Replies: 11
Views: 6210

No, these are the buffers inserted by DataStage possibly due to a "force" buffering setting. The problem appears to be with network protocol rather than memory. Are you in a single machine or multiple machine environment? If the latter, are all the rsh and tcp protocols set correctly?
by ray.wurlod
Tue Aug 29, 2006 10:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to write nulls as nulls
Replies: 10
Views: 2744

Vijay Kumar wrote:Is there any way I can avoid these warning messages without doing any transformation for null handling?


No. The warning messages will always be generated in this case, because you need to be aware of the situation.

Either provide null handling or implement a message handler.
by ray.wurlod
Tue Aug 29, 2006 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Training
Replies: 1
Views: 1027

IBM have a class called DataStage Essentials for Mainframe(code DX134) that you can take.
by ray.wurlod
Tue Aug 29, 2006 10:33 pm
Forum: IBM QualityStage
Topic: Can we call unix scripts thru qualitystage?
Replies: 5
Views: 2390

No.

(Unless you can find something really obscure in Pattern Action Language that I have not been able to find.)
by ray.wurlod
Tue Aug 29, 2006 10:30 pm
Forum: Site/Forum
Topic: Congrats Craig on your 7000th accomplishment
Replies: 11
Views: 5536

One of my benchmarks that I was able to sustain for years (2 x Craig's posts) has gone out the window. Maybe if I unplug his keyboard for a while... :lol:
by ray.wurlod
Tue Aug 29, 2006 6:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ftp not retrieving all records
Replies: 9
Views: 2021

Then share it. That's what makes DSXchange the incredibly useful facility that it is.
by ray.wurlod
Tue Aug 29, 2006 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling Date functions in a routune
Replies: 1
Views: 970

It's DEFFUN that's really needed.

If the appropriate DEFFUN declaration exists in a header file then you can $INCLUDE that header file.

Read about DEFFUN and $INCLUDE In the DataStage BASIC manual or in on-line help.
by ray.wurlod
Tue Aug 29, 2006 6:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ftp not retrieving all records
Replies: 9
Views: 2021

Is the final line in the file properly terminated?
by ray.wurlod
Tue Aug 29, 2006 6:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: performance issue
Replies: 1
Views: 788

Did you search? Did you find this answer?