Search found 53125 matches

by ray.wurlod
Mon Sep 08, 2003 5:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question on partition method for lookup or Join stage
Replies: 2
Views: 3295

Remember, too, that within DataStage PX environment, data can be re-partitioned "on the fly". There are pictures of this in the marketing material, but not in the manual.
by ray.wurlod
Mon Sep 08, 2003 5:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Mystery
Replies: 5
Views: 1275

Do you have NLS enabled and, if so, what character map are you using on this link? What happens if you change the map to NONE ? Because the most significant bit of the lead byte is set (that is, 198 > 128), this would ordinarily be interpreted as the lead byte in a multi-byte character. The UV-UTF8 ...
by ray.wurlod
Mon Sep 08, 2003 5:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ExecCommand in Sequences
Replies: 11
Views: 1960

It can't be edited in the job sequence. However, you can copy the code from there and paste it into the Job Control page of another server job's properties, and edit it there. That server job becomes your job control. I also advocate placing an Annotation on the canvas in this case, advising future ...
by ray.wurlod
Mon Sep 08, 2003 5:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS Locale
Replies: 2
Views: 957

Assuming you have installed DataStage with NLS enabled (because you are asking this question): You set project-wide defaults on the NLS button of the Administrator client, once you have selected the project. You set job-wide defaults on the NLS tab of the Job Properties window. These override the pr...
by ray.wurlod
Mon Sep 08, 2003 4:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Suppressing warnings
Replies: 3
Views: 1239

You can always use the filter (Ctrl T) in Director's log view to suppress display of warning messages. The warning events are still logged, but you can generate reports that don't contain them.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
by ray.wurlod
Mon Sep 08, 2003 4:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of transformer
Replies: 10
Views: 3214

Conceptually the IPC stage is like two sequential file stages, the first writing to a named pipe and the second (executing in a separate process) reading from the named pipe.
So I think it's fair to say that it does, in fact, cause the two halves of the job to execute separately.
by ray.wurlod
Sun Sep 07, 2003 6:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic arrays
Replies: 13
Views: 2599

Dynamic Arrays [Resolved]

The ";" is for use (must be used) when the value# and subvalue#, or the subvalue#, are omitted.
REPLACE(dynarray, field#, value#; newvalue)
by ray.wurlod
Sun Sep 07, 2003 6:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ExecCommand in Sequences
Replies: 11
Views: 1960

Whence came this "pseudo-edict"? [?]
I was not aware of it. I've been suggesting to my clients to use the job sequence to prototype but to feel OK about customizing the code it produces.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
by ray.wurlod
Sun Sep 07, 2003 5:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of transformer
Replies: 10
Views: 3214

If you have the time to experiment, try putting a Sequential File stage between the two Transformer stages, to try to focus a bit more accurately on the location of the problem. (In DS 6.0 and later you can use an Inter Process stage, and achieve the same effect in memory.) Ray Wurlod Education and ...
by ray.wurlod
Sun Sep 07, 2003 5:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Tandem NS SQL database and Datastage
Replies: 1
Views: 752

If this is a specific requirement not accommodated by any extant DataStage stage type, then you could contemplate creating your own plug-in stage type. There is a documented API for doing this; but be warned that it requires fairly substantial C skills. Or you could generate specifications for what ...
by ray.wurlod
Thu Sep 04, 2003 5:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Generated files with 0 bytes
Replies: 6
Views: 2398

If they are being created by Sequential File stage, you can check Omit Last NewLine on the Inputs tab (Format tab).

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
by ray.wurlod
Thu Sep 04, 2003 5:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage client startup
Replies: 6
Views: 1339

No. If you explain what you're trying to achieve, we may be able to offer a mechanism. DataStage clients connect to the server via a proprietary mechanism called DSObjects, connection being achieved via the DSRPC mechanism. There is nothing within this mechanism that permits customization. Ray Wurlo...
by ray.wurlod
Thu Sep 04, 2003 5:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bulk Load
Replies: 1
Views: 426

Assuming you're asking about server jobs, the stage type to use is the UDBLOAD stage. If you don't have this installed (it's a "plug-in" (= optionally installed) stage type), you can install it using the DataStage Package Installer. Full details can be had from the manuals. Ray Wurlod Education and ...
by ray.wurlod
Thu Sep 04, 2003 5:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I don not see Palallel Jobs
Replies: 2
Views: 500

When you install DataStage server, the first licensing screen handles the base product (server jobs, sequences and shared containers). A second licensing screen allows you to put in auth codes for PX and for mainframe. If you don't put anything in here, these components are not licensed. To find out...
by ray.wurlod
Thu Sep 04, 2003 4:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Where oh Where to do the Job....
Replies: 6
Views: 1040

A Transformer stage has one stream input, and zero or more reference inputs. (You can't draw it any other way.) The reference input connects to a Hashed File stage. The column metadata for the hashed file identifies one or more columns as being Key. In the Transformer stage, for each reference input...