Search found 53125 matches

by ray.wurlod
Tue May 01, 2007 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset using as intermediate stage b/w two jobs
Replies: 6
Views: 1350

A Data Set stage is ideal as the staging area between two jobs because it preserves the internal Data Set structure; internal formats, partitioning and sorting. You will need to read the Data Set with a configuration file that is compatible with the one used when it was written. You may, therefore, ...
by ray.wurlod
Tue May 01, 2007 3:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does the SetDSParamsFromFile exist for DSEE
Replies: 12
Views: 3868

It may also be the case that this routine was written as a transform function (so that it can be called from a job sequence's Routine activity) rather than a before/after subroutine. In that case it will never appear on the drop-down list of before/after subroutines. It may also be the case that it ...
by ray.wurlod
Tue May 01, 2007 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing tabs from a column
Replies: 2
Views: 999

As well as od -xc as suggested by Craig, you can use editors such as UltraEdit that can open the file via FTP and show it to you in hex.
by ray.wurlod
Tue May 01, 2007 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL for Last value in a universe field
Replies: 3
Views: 901

Perhaps this thread is resolved and could be marked thus?
by ray.wurlod
Tue May 01, 2007 3:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: will space be used for extract job
Replies: 5
Views: 926

The sequential file will, of course, be written to disk and consume disk space.

Depending on the extraction SQL, the database stage may need to use paging space.

The Transformer stage ought not to use any disk space, unless you invoke routines that explicitly use disk space.
by ray.wurlod
Tue May 01, 2007 2:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Authentication problem in DataStage 8
Replies: 16
Views: 8091

You're paying for support - what do they offer in the way of advice? Very few posters here have version 8.0 at this time.
by ray.wurlod
Tue May 01, 2007 2:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Facing a problem in order to pass a value from Sequencer
Replies: 8
Views: 3137

It's all part of the patience that you need to develop, grasshopper. You may have explained it before, you may have explained it many times, but you will still get questions from people who are new to the technology, even new to the Search technology! Be patient with them, especially those with low ...
by ray.wurlod
Tue May 01, 2007 3:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Lookup stage
Replies: 4
Views: 1400

In the Sequential File stage provide either or both of a Null Field Value or Default Value for the UPDATED_DATE field.
by ray.wurlod
Tue May 01, 2007 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error updating As400 table in ODBC stage
Replies: 2
Views: 981

What precisely does the error message "EXSMRT1P in HMLIMSNRB not valid for operation." mean? That should suggest to you where the problem is being caused. As you note, the same error was seen prior to migration, so it can not be put down to migration. I'd be looking for a DB2 object called EXSMRT1P ...
by ray.wurlod
Tue May 01, 2007 3:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the length for decimal field
Replies: 17
Views: 5511

There is, on this forum, an IsValid() function for server jobs. It is well documented.
Please post parallel job questions on the parallel forum.
by ray.wurlod
Tue May 01, 2007 3:43 am
Forum: General
Topic: Job disappeared after migrating with Version Control
Replies: 4
Views: 1714

"Disappear" might mean that the CATEGORY index has become out of date. This can be fixed using the DS.REINDEX ALL command (search the forum for detailed instructions). Note that Version Control ceases to exist from version 8.0. If you prefer export/import, you can set the read-only field (called REA...
by ray.wurlod
Tue May 01, 2007 3:40 am
Forum: General
Topic: How to Convert from DD-MM-YYYY hh24:mi:ss to YYYY-MM-DD hh24
Replies: 2
Views: 1146

Because there are no internal data types in server jobs, you could simply re-arrange the substrings. Otherwise, you need to convert the date and time portions separately and concatenate them with a separating space character. Because it's Oracle, I suspect you'll need minutes and seconds too - if no...
by ray.wurlod
Mon Apr 30, 2007 4:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the length for decimal field
Replies: 17
Views: 5511

Try the IsValid() function I posted here some time back.
by ray.wurlod
Mon Apr 30, 2007 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Got certified in Datastage
Replies: 40
Views: 13776

The sample questions are fairly representative of the style and difficulty level of those in the real exam. Obviously, though, ten sample questions can not cover the breadth of knowledge. Therefore I exhort you as part of your preparation also to read the objectives for the exam.
by ray.wurlod
Mon Apr 30, 2007 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setup problem parallel job
Replies: 5
Views: 2692

APT_RESPATH contains the path of a "resource file". A resource file is like a lookup table for messages. Every message is tokenized, and you look up the token to get the message text template (something like the first argument for the printf() function in C). If you're running a Japanese version of ...