Search found 53125 matches

by ray.wurlod
Fri May 04, 2007 2:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading Cobol File using CFF Stage
Replies: 5
Views: 3635

With such a simple layout, you could read this as a single VarChar field (using a Sequential File stage) and parse it in a Transformer stage, flattening the repeating group into separate columns. Whether or not you keep E is rather irrelevant - you simply parse into five pairs of columns, perhaps su...
by ray.wurlod
Fri May 04, 2007 2:18 am
Forum: General
Topic: How to add entry in VOC file
Replies: 9
Views: 9090

That's not the same as the DS.UNLOCK entry, though. Or is it? :roll:

Executing an unlock command from the DS.TOOLS menu will catalog the UNLOCK command into your VOC file without your needing to risk corrupting the VOC file with any external operation.
by ray.wurlod
Fri May 04, 2007 2:15 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Profile stage Documents?
Replies: 6
Views: 3137

None of which I'm aware.

Some information about the products can be found on the IBM Websphere DataStage Library and some ProfileStage-specific information can be had from a search on the IBM web site, but not precisely what you seek.
by ray.wurlod
Thu May 03, 2007 11:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run jobs Parallely in Batch Jobs
Replies: 5
Views: 1397

The preferred mechanism these days is to create a job sequence.

Run jobs simultaneously in a job sequence by not having any dependency from one Job activity to another.
by ray.wurlod
Thu May 03, 2007 11:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bulk Load Of Target DB2 Table
Replies: 3
Views: 1131

Welcome aboard. :D Bulk load is invoked using Write method from DB2 Enterprise stage, and is used for rapid loading of new rows to the table. The actual load, however, is performed by the DB2 bulk loader, not by DataStage. Therefore, you will need to design in your own restart logic and the "record ...
by ray.wurlod
Thu May 03, 2007 11:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Number
Replies: 9
Views: 2642

Only if you ensure that the External Source stage executes in sequential mode. Otherwise you'll get a separate sequence of numbers starting from 1 on each processing node.
by ray.wurlod
Thu May 03, 2007 11:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Call Jobs on Condition based in the Sequence
Replies: 15
Views: 5784

Search for "BCI". But you don't really need a routine. A job could fetch a calue from Oracle, probably easier to manage and to maintain. Load the retrieved value into the job's user status area and use that value to drive the triggers from the Job activity.
by ray.wurlod
Thu May 03, 2007 11:37 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Profile stage Documents?
Replies: 6
Views: 3137

If you have any of the "Ascential" products, try asking IBM. They may be prepared to give you the PDF files in the hope of a sale.
by ray.wurlod
Thu May 03, 2007 8:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re-Running Installation for Information Server
Replies: 4
Views: 1568

Surely that would already be in place, for Information Server to use?
by ray.wurlod
Thu May 03, 2007 6:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion
Replies: 24
Views: 6450

The suggested second argument for Oconv() was "D-YMD[4,2,2]" but you used "D-DMY[2,2,2]" against that advice. Why?
by ray.wurlod
Thu May 03, 2007 6:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot move job from one category to another
Replies: 4
Views: 2237

As well as that, the 7.5x2 client has LOTS of problems talking to other server versions that specifically 7.5x2.
by ray.wurlod
Thu May 03, 2007 6:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in reading Sequential file
Replies: 6
Views: 1991

Your design looks like this?

Code: Select all

SeqFile  ----->
   |
   | [Reject]
   |
   V
 Peek

Please report what the Peek stage captures from your reject link.
by ray.wurlod
Thu May 03, 2007 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: mv Command again
Replies: 3
Views: 815

Not all UNIX systems support mv across file systems. In this case you need to do a (recursive) cp followed by a (recursive) rm to remove the original.
by ray.wurlod
Thu May 03, 2007 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re-Running Installation for Information Server
Replies: 4
Views: 1568

I believe the answer is yes, but can not advise on how. Get your support provider to answer the "how" question.
by ray.wurlod
Thu May 03, 2007 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best approach for unknown varied source
Replies: 19
Views: 5646

Then specify the format in the request.