Search found 53125 matches

by ray.wurlod
Mon Jun 04, 2007 9:23 pm
Forum: General
Topic: AddMonths routine
Replies: 4
Views: 2013

Try downloading from here
by ray.wurlod
Mon Jun 04, 2007 9:16 pm
Forum:
Topic: Information Analyzer and Business Glossary in Version 8
Replies: 29
Views: 15442

There was a good paper at IOD2006 called "Joining the Dots" - get a copy of that, to see the interactivity between the tools sharing a common repository. Also shows Rational Architect in the mix, but that's OK. Other papers go into using Information Analyzer in more detail. They can be had for the a...
by ray.wurlod
Mon Jun 04, 2007 9:13 pm
Forum: IBM QualityStage
Topic: a problem with the Run
Replies: 4
Views: 2490

You could check for short records in D:\Projects\OMPDWCZ\Data\OMCCB0NS with a DataStage job that reads each row as a single string and reports its length. "Eyeballing" doesn't always work, it can be confused by tabs and non-printing characters.
by ray.wurlod
Mon Jun 04, 2007 9:10 pm
Forum: IBM QualityStage
Topic: error in directions
Replies: 1
Views: 1033

QualityStage never deletes anything. You could try using a Select stage to isolate those rows that contain "garbage" characters.
by ray.wurlod
Mon Jun 04, 2007 9:07 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: eror:3704-Operation is not allowed when the object is closed
Replies: 2
Views: 2423

Usually, if someone has any idea, they will post it. The dearth of replies suggests something like the following.

Code: Select all

select posters with clue > 0;

0 rows selected.

Why not use the support provider you're paying to support you?
by ray.wurlod
Mon Jun 04, 2007 2:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job under control failed to start
Replies: 2
Views: 613

Job under control failed to start

Has anyone seen this happen? Like to advance a cogent explanation? The job controller reported (-14) that the job under control failed to start within the 60 seconds allowed. The job run request was made at 4:39:08 and the failure was reported at 4:40:10, at which time the job controller aborted, th...
by ray.wurlod
Mon Jun 04, 2007 2:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Enterprise Server configuration
Replies: 4
Views: 1206

Administrator client. Project Properties. Environment. User Defined.
by ray.wurlod
Mon Jun 04, 2007 1:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting records in table
Replies: 11
Views: 5134

With what value?
by ray.wurlod
Mon Jun 04, 2007 1:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Enterprise Server configuration
Replies: 4
Views: 1206

Parallel Job Advanced Developer's Guide page 6-7
by ray.wurlod
Mon Jun 04, 2007 1:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: about passing parameters dynamically
Replies: 10
Views: 2473

Not in one job. You can only build the target table name dynamically by passing these values as job parameters, then constructing the table name from these, or by constructing the table name in the invoking job sequence.
by ray.wurlod
Mon Jun 04, 2007 1:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading Successful but cannot decipher warning !!! HELP!!!
Replies: 2
Views: 1321

It ordinarily means that the DB2 stage lacks an SQL statement of any kind. This is possible with user-defined SQL. Check every link that connects to a DB2 stage. Or read the remainder of the error message to see whether it's being reported from a particular stage, and you need only investigate the l...
by ray.wurlod
Mon Jun 04, 2007 1:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: About Oconv & Iconv
Replies: 9
Views: 2665

Be more specific about the arguments you used with Oconv() and Iconv(). Without that information it is impossible to provide any diagnosis. We also need the exact text of the error message that is thrown in your first example, and information about when it is thrown (compile time, run time, etc.).
by ray.wurlod
Mon Jun 04, 2007 1:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: About Dastage Manager
Replies: 1
Views: 605

To disappear in version 8.0. Even now most of its tasks can be performed in Designer; the remainder are transferred in version 8.0.

A stroll across the menu in the Manager client will reveal the answer to your question.

Incidentally there are three "a" characters in "DataStage".
by ray.wurlod
Mon Jun 04, 2007 1:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hash file
Replies: 3
Views: 664

Beware of the terminology. It's hashed file, therefore it's hashed lookup. The hashing algorithm used in lookup is the one that is specified for the hashed file. There are two choices (GENERAL or SEQ.NUM) for dynamic hashed files, and seventeen choices for static hashed files. There are thus 19 sepa...
by ray.wurlod
Sun Jun 03, 2007 11:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Dates in multiple formats from a text file
Replies: 4
Views: 1216

There are four possible date format strings: "%mm/%dd/%yyyy", "%m/%dd/%yyyy", "%mm/%d/%yyyy" and "%m/%d/%yyyy". If you must use a parallel job, specify one of the date format strings in Sequential File stage A. Its reject link is passed to a Column Import stage, which uses a record schema with the s...