Search found 53125 matches

by ray.wurlod
Thu Mar 31, 2005 2:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capturing warning messages in my sequencer
Replies: 3
Views: 1204

Set up another output link from the job activity. Trigger it for warnings. Invoke a Routine activity. Create a Routine that takes the job name as its argument and retrieves the warning message(s) from the job log (using DSGetNewestLogID and DSGetLogEntry functions and writes them to a text file. App...
by ray.wurlod
Thu Mar 31, 2005 1:58 am
Forum: IBM QualityStage
Topic: test the data
Replies: 9
Views: 6276

Nope, also.

It's just thst there's no place to put in a QualityStage version number. :roll:

But QualityStage version 7 can run on Windows perfectly adequately (given enough memory especially).
by ray.wurlod
Wed Mar 30, 2005 2:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CenturyBreakYear
Replies: 2
Views: 680

There is a configuration parameter called CENTURYPIVOT in the uvconfig file. There is documentation in there too, describing how different settings affect the way that two digit years in dates are handled. Remember/beware that if you change anything in uvconfig the change does not take effect until ...
by ray.wurlod
Wed Mar 30, 2005 2:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with DRS Stage
Replies: 6
Views: 3879

That would not cause a disconnection. It's unrelated to the original question. Can you start a new thread for the problem with Informix DATE data type?
Meanwhile, did you solve the disconnection problem?
by ray.wurlod
Wed Mar 30, 2005 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warnig message in parallel extender job
Replies: 3
Views: 1234

It's simply alerting you to the possibility that, because you have set a maximum string size on the output, but an arbitrary size on the input, any input string longer than 200 characters would be truncated.
by ray.wurlod
Wed Mar 30, 2005 2:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: check that 'dbx' and 'sed' are installed and on your PATH
Replies: 4
Views: 4042

Welcome aboard! :D

The later part of the message suggests that the PATH environment variable (which is set up in the dsenv file) does not include the directory in which either or both of sed or dbx commands is found.

This is the first thing you need to check.
by ray.wurlod
Wed Mar 30, 2005 2:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 2 sequence daily job call a monthly job?
Replies: 7
Views: 2931

Create a job sequence that runs every day. It runs the two daily sequences using Job Activities. The OK triggers from these run through an All Sequencer to a Nested Condition or Routine activity that determines whether it's the last day of the month, and this may or may not trigger the end of month ...
by ray.wurlod
Wed Mar 30, 2005 2:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage
Replies: 8
Views: 2966

DRS came about largely as a result of the PeopleSoft decision to use DataStage; they needed a generic mechanism for deploying canned ETL jobs to their customers who, of course, use different databases for running the PeopleSoft applications.
by ray.wurlod
Wed Mar 30, 2005 2:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEETING UP PROJECT DEFAULTS
Replies: 10
Views: 4127

Set them up using the Administrator client. There is a command button for the project properties with Environment Variables as its caption. This is where you need to be to set up user-defined environment variables. When creating job parameters in server jobs, you can use the environment variable dir...
by ray.wurlod
Wed Mar 30, 2005 1:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Errors
Replies: 6
Views: 1321

How many links run from the Link Partitioner stage into the Shared Container? How many links run from the Shared Container to the Link Collector stage? What algorithms are you using for the partitioning and collection? Is the Hashed File stage inside or outside the Shared Container?
by ray.wurlod
Wed Mar 30, 2005 1:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric Validation
Replies: 7
Views: 1777

How about

Code: Select all

Ans = ((Arg1 = 2 Or Arg1 = 5) And (Arg2 >= 0)) Or (Arg2 > 0)

Since it's a single-line expression, you can do it in a Transform or even as a directly coded expression within a Transformer stage (without "Ans =" of course).
by ray.wurlod
Wed Mar 30, 2005 1:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: EBCDIC to ASCII and back
Replies: 7
Views: 2547

Do you want to do this using a parallel job (you specified parallel as the job type) or a server job (you posted on the server job forum)?
by ray.wurlod
Wed Mar 30, 2005 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in setOutputFieldAsString()
Replies: 5
Views: 1657

In that case it's a bit of a mystery. Can you please post the entire error message (double click the log entry to get detail view)? This will contain the stage and link name where the error was generated.
Check both input and output links to ensure that no non-string data type has been specified.
by ray.wurlod
Tue Mar 29, 2005 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Basic function LOCATE
Replies: 3
Views: 1987

Please note that, despite having parentheses in one of its syntactic variations, LOCATE is a statement, not a function in DataStage.
by ray.wurlod
Tue Mar 29, 2005 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Very slow updates vs. inserts
Replies: 5
Views: 2069

This is more an artifact of database behaviour rather than DataStage behaviour. A lot more checking takes place for an UPDATE than for an INSERT. You haven't encountered in noticeably in the past because you haven't been throwing the volume of rows at the database that DataStage is.