Search found 53125 matches

by ray.wurlod
Wed Mar 17, 2010 2:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: packed decimal
Replies: 10
Views: 9281

...and how do you propose they use a server job Transform in a parallel job?
by ray.wurlod
Wed Mar 17, 2010 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: truncate the leading zeros
Replies: 3
Views: 2172

No you don't.

Because you can't, and because they make no difference. Decimal numbers are stored internally in binary format.

The only way you can expect to remove leading (and perhaps trailing) nonsignificant zeroes is to place the result into a string data type.
by ray.wurlod
Wed Mar 17, 2010 1:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe stage and version 8.x
Replies: 2
Views: 1341

Yes, localuv remains supported as a pre-connected "UniVerse" data source.
by ray.wurlod
Wed Mar 17, 2010 1:57 am
Forum: General
Topic: How to default a Timestamp Field?
Replies: 2
Views: 1127

WHERE did you try StringToTimestamp() function?
by ray.wurlod
Tue Mar 16, 2010 7:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: reading Oracle MD5 hash values into transformer stage
Replies: 4
Views: 3277

Welcome aboard. The three messages are all part of the same error - it's just that three things have been logged. The last of the three may be ignored - it is just reporting which internal DataStage component is throwing the error. There's a problem with binary data - if the bit pattern happens to c...
by ray.wurlod
Tue Mar 16, 2010 7:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: adding header and footer to every group
Replies: 5
Views: 2116

Moderator: please move to Enterprise Edition (parallel) forum. To achieve this result you need to assign a unique group number to each group, generate the three record types in a Transformer stage with three outputs, then bring them together using a Funnel stage keeping groups together using the un...
by ray.wurlod
Tue Mar 16, 2010 7:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Istools script Issue
Replies: 6
Views: 3802

Try specifying the -server option explicitly.
by ray.wurlod
Tue Mar 16, 2010 7:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage limitation for phantoms processes
Replies: 4
Views: 1951

Kernel parameters are not set through ulimit. Check with your system administrator. The parameter in question is likely to be called something like NPROC.
by ray.wurlod
Tue Mar 16, 2010 7:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File Creation Bogging Down Server
Replies: 13
Views: 3733

Much of this is automatic table space management within the dynamic hashed file structure. When you create the hashed file (as opposed to populating it) pre-size it according to the expected data volume - you can use Hashed File Calculator to achieve the calculation, and the MINIMUM.MODULUS keyword/...
by ray.wurlod
Tue Mar 16, 2010 1:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Float to decimal
Replies: 1
Views: 1126

What precision and scale have you allocated to the Decimal data type?
by ray.wurlod
Tue Mar 16, 2010 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Install v8 using sudo
Replies: 4
Views: 2579

Having sudo access is the same as having effective user ID 0, which is equivalent to having the root login on the machine except that it can be limited to particular commands. I understand that sudo access is sufficient to install Information Server. But beware that there are more commands than the ...
by ray.wurlod
Tue Mar 16, 2010 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: version control features in PX
Replies: 8
Views: 2786

ClearCase and CVS will be directly supported - and others through an Eclipse plug-in or API.
by ray.wurlod
Tue Mar 16, 2010 1:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Varchar by Modify Stage
Replies: 2
Views: 1449

The Parallel Job Developer's Guide is largely incorrect in respect of Modify stage functions. Get a set of Orchestrate (OEM) manuals from your support provider.
by ray.wurlod
Tue Mar 16, 2010 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup error at compilation
Replies: 1
Views: 869

Re-posting this question won't change the answer.
by ray.wurlod
Tue Mar 16, 2010 1:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage limitation for phantoms processes
Replies: 4
Views: 1951

Check out the kernel parameter that limits the number of processes a process can create. Check, too, that the system is not exhausting all available resources.