Search found 53125 matches

by ray.wurlod
Tue May 20, 2008 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC call from BASIC
Replies: 3
Views: 1540

You will have to change, on the basis that you are not already calling from BASIC. There is a suite of functions collectively called the BASIC SQL Client Interface, or BCI, that mimics the ODBC API. Search the forum for more information. The BCI manual is downloadable from IBM's online UniVerse manu...
by ray.wurlod
Tue May 20, 2008 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No Limit settings
Replies: 4
Views: 2153

Note also that in parallel jobs there is no Run limit unless you compile in trace mode. (You marked your job type as parallel even though you posted in the server forum.) Our comments about the Warning limit remain pertinent.
by ray.wurlod
Tue May 20, 2008 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file UFD
Replies: 3
Views: 3378

Be more specific about what you did when you "hosed" the project. Since &UFD& is "the current directory" ordinarily, I would suggest that the VOC entry for &UFD& has become corrupted. Can you post the results of this query?

Code: Select all

LIST.ITEM VOC '&UFD&'
by ray.wurlod
Tue May 20, 2008 4:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: file transfer help
Replies: 5
Views: 1601

Because 25 <> 30 <> 65 you can not claim that this is fixed width. Use VarChar, as I indicated. FTP does not care about delimiters; no stage does if there is only one column. Use DIGITS Transform to extract the numeric portions of the header and trailer records, and constraint expressions in the Tra...
by ray.wurlod
Tue May 20, 2008 4:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fatal error in the Master sequence -Datastage Job
Replies: 1
Views: 2310

There is no issue. You have not designed your job sequence to do anything about/with failed activities. Find details relating to causes in the individual logs of controlled jobs.
by ray.wurlod
Tue May 20, 2008 4:00 pm
Forum: General
Topic: IBM INformation Server Start and Stop
Replies: 6
Views: 2323

It may be insufficient memory. IBM recommends a minimum of 2GB just for the client alone. IBMers who have to run on laptops all have 3GB or 4GB of RAM in those.
by ray.wurlod
Tue May 20, 2008 3:58 pm
Forum: IBM QualityStage
Topic: osh is unavailable. Please install or configure
Replies: 7
Views: 2349

On all nodes (fastnames) mentioned in your configuration file?
by ray.wurlod
Tue May 20, 2008 8:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Abort/Fail PX job
Replies: 6
Views: 2102

If you're a Vogon guard, the adjective is "useless", and it has to be shouted.
by ray.wurlod
Tue May 20, 2008 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: retrive the data from sequential file
Replies: 2
Views: 786

If it's urgent, ask your support provider, with whom you no doubt have a "premium service" contract to provide answers to urgent questions. DSXchange is an all-volunteer site whose participants post as and when they can. If you can view data there is nothing wrong with the Sequential File stage and...
by ray.wurlod
Tue May 20, 2008 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator Role Issues - Jobs not Found
Replies: 8
Views: 1336

Operator's Edition is the one you install with the DSDIR auth code rather than the DSDES auth code. Apart from that the Operator role is identically defined - it can only work with released jobs. In version 8.0 there is a "Super Operator" role that can work with all job types - can even open jobs re...
by ray.wurlod
Tue May 20, 2008 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Verify Trigger Expression
Replies: 6
Views: 2888

These aren't really expressions - they're really pseudo-expressions for OK and Warning triggers respectively. True expressions are really for Custom triggers.
by ray.wurlod
Tue May 20, 2008 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count generation
Replies: 13
Views: 3837

Use a Copy stage with a Sample stage on the second output.

(Come on, keep 'em coming - the target is ten ways!)
by ray.wurlod
Tue May 20, 2008 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJOBS table not being populated when using reorting assista
Replies: 8
Views: 1947

Depends. What do you want to report? The intention (in deprecating the Reporting Assistant) was to force customers to use MetaStage for metadata reporting. With version 8 this has been replaced again, with some of the metadata reporting capabilities embedded in the metadata analysis server and more ...
by ray.wurlod
Tue May 20, 2008 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP Plugin Stage
Replies: 6
Views: 4477

"Plug-In" means "optionally installed".

The terms "FTP Plugin stage" and "FTP stage" mean the same thing.
by ray.wurlod
Tue May 20, 2008 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Abort/Fail PX job
Replies: 6
Views: 2102

Resist stupid requirements.