Search found 53125 matches

by ray.wurlod
Sat Mar 14, 2009 12:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Universe Routine
Replies: 9
Views: 5523

How do you know you're processing the correct level of delimiter? For example Char(252) is - probably - a sub-value mark, while Char(253) is - probably again - a value mark. Some operations, such as Trans() with a multi-valued first argument, effect an automatic Lower() on the dynamic array. Add deb...
by ray.wurlod
Sat Mar 14, 2009 12:29 am
Forum: General
Topic: DataStage 8.0 dsjob command error
Replies: 11
Views: 11986

Which particular Windows platform? This might be one of those things that Windows XP does not support (though the fact that it worked pre version 8 is a bit of a poser). But version 8 is a radically different beast in any case.
by ray.wurlod
Fri Mar 13, 2009 1:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the meaning of following errlog message?
Replies: 10
Views: 4903

In the Administrator client, with exclusive access to the project and logged in as an administrator, execute the following command:

Code: Select all

UPDATE.ACCOUNT IDEAL
by ray.wurlod
Fri Mar 13, 2009 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null_field for a timestamp field in an orchestrate schema
Replies: 2
Views: 1196

Basically, get it right. You need 19 characters to store a timestamp - you will never get one shoehorned into 14 characters. And/or change your timestamp format picture to something like "%yyyy%mm%dd %hh%mm".
by ray.wurlod
Fri Mar 13, 2009 1:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar Field Truncation Issue : Sequential File
Replies: 8
Views: 2237

As noted elsewhere (did you Search?) the string requires two extra character positions - one for the sign and one for the decimal placeholder character (unless scale = 0).
by ray.wurlod
Fri Mar 13, 2009 1:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Missing Stages in Project
Replies: 7
Views: 2078

Did you check "overwrite without query"?
by ray.wurlod
Fri Mar 13, 2009 1:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage -- Warning mEssage
Replies: 4
Views: 4571

Add an additional Specification containing only the word NOWARN.
by ray.wurlod
Fri Mar 13, 2009 1:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data.30 in my input Data
Replies: 19
Views: 5064

Bonne chance!
by ray.wurlod
Fri Mar 13, 2009 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration File Issue in Parellel Jobs
Replies: 22
Views: 13165

What about on the other nodes?
by ray.wurlod
Fri Mar 13, 2009 1:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Startloop and Endloop activity.
Replies: 5
Views: 2246

I gave you a solution. All you need to do is purchase a premium membership so you can read it.

Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. It's not expensive, at less than 30c (Rs 12) per day, and there is an increasing set of benefits.
by ray.wurlod
Fri Mar 13, 2009 1:39 am
Forum: Cognos (IBM BI)
Topic: Reading multiple files
Replies: 1
Views: 8773

Welcome aboard.

This particular forum is for questions about Cognos tools.

Please post your question in the correct forum (Enterprise Edition).
by ray.wurlod
Thu Mar 12, 2009 11:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can i move dataset using mv command
Replies: 2
Views: 1592

You can not copy or move or delete a Data Set. A Data Set consists of potentially many files, on the resource disk specified for the various nodes in your configuration file. You have no convenient way of knowing (while at the command line) which files belong to which Data Set. Even if you did, the ...
by ray.wurlod
Thu Mar 12, 2009 11:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Startloop and Endloop activity.
Replies: 5
Views: 2246

I don't really know what you want to achieve. Is it a list of the numbers, or a list of the file names, or a list of the pairs, that you wish to pass to the Start Loop activity? The easiest way is to use an upstream Execute Command activity to read the file (perhaps with filtering), then a user vari...
by ray.wurlod
Thu Mar 12, 2009 10:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting Warnings/Job Finished status of child Sequences
Replies: 6
Views: 1463

One can design in point-of-failure restart without relying on the brain-dead automatic mechanism.

Grognard.
by ray.wurlod
Thu Mar 12, 2009 10:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Providing parameters to all the jobs/Selective jobs
Replies: 3
Views: 1122

Do you mean environment variables? The answer is to use parameter sets. To do that, you will need to upgrade to version 8. Until then there is no "all in one shot" solution. Another possibility is custom coded "read parameters from a file" functionality, perhaps in job control ro...