Search found 53125 matches

by ray.wurlod
Tue Jul 17, 2007 10:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage MVS Edition
Replies: 10
Views: 5921

DataStage MVS generates nice COBOL and JCL, but the politics of getting "them" to allow it to run on their precious mainframe can be altogether too time-consuming. :roll:
by ray.wurlod
Tue Jul 17, 2007 6:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CobolData Type Conversion
Replies: 3
Views: 723

When you import from the COBOL FD you must specify the column number in which the level 01 item occurs.
by ray.wurlod
Tue Jul 17, 2007 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Catching all duplicate and non duplicate records seperately
Replies: 6
Views: 1773

Run a fork-join design, using an Aggregator to count the number of each grouping key combinations. Run them all through two streams, one with a Remove Duplicates stage, the other with a filter stage on the count being >= 2.
by ray.wurlod
Tue Jul 17, 2007 4:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling for timestamp in DS 8.0
Replies: 4
Views: 1731

Handle your nullability properties correctly. The stage in question is the one performing the export, not the Modify stage.
by ray.wurlod
Tue Jul 17, 2007 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SHLIB_PATH
Replies: 4
Views: 1276

Set SHLIB_PATH in the dsenv script.
by ray.wurlod
Tue Jul 17, 2007 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: max bit length
Replies: 1
Views: 709

Please be more precise about "somewhere". Then review the data types mentioned in Parallel Job Developer's Guide - which include up to uint64 in the integer series, very large decimal numbers, and single- and double-precision floating point numbers (huge numbers, potentially).
by ray.wurlod
Tue Jul 17, 2007 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage MVS Edition
Replies: 10
Views: 5921

You don't need to install MVS edition, though your IBM account rep would be happy for you to do so. You can get the data from the mainframe using FTP.
by ray.wurlod
Tue Jul 17, 2007 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join many to many
Replies: 2
Views: 1084

Join stage with full outer join would be first choice. Lookup stage if your second input is small enough to load into memory.
by ray.wurlod
Tue Jul 17, 2007 2:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Format Checking
Replies: 7
Views: 1971

Problem is that these dates are all valid, being early in the so-called Christian era.
The correct approach is to use pattern matching.

Code: Select all

InLink.TheDate Matches "3A' '1N' '4N" : @VM "3A' '2N' '4N" 
before applying an IsValid() function.
by ray.wurlod
Tue Jul 17, 2007 2:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to set the Job params in a Seq. to all the jobs in it??
Replies: 5
Views: 1126

Upgrade to version 8.0 and use parameter sets.

Downgrade to version 7.0 and copy/paste activities in job sequences - they preserve their parameter settings. This functionality has been removed for version 7.5 so that arbitrary expressions may be used to supply parameter values.
by ray.wurlod
Tue Jul 17, 2007 2:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call a routine with diff number of arguments
Replies: 1
Views: 887

For user-written server routines there is not.

You can write the routine to ignore some of its arguments, but the number of arguments is fixed.
by ray.wurlod
Tue Jul 17, 2007 2:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal Termination of Transformer stage
Replies: 3
Views: 1573

You could never have gotten those records into the hashed file, so you will never succeed in looking them up. Please post the metadata from the job that populates the hashed file. Do NOT change MAXKEYSIZE without first taking expert advice on the consequences. For example, you will not be able to us...
by ray.wurlod
Tue Jul 17, 2007 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date calculations
Replies: 4
Views: 1752

But these routines are probably even more better!
by ray.wurlod
Tue Jul 17, 2007 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help on dsexport
Replies: 40
Views: 15946

You could have used strings utility for that!
by ray.wurlod
Tue Jul 17, 2007 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Memory problem - Routine value - Abnormal termination
Replies: 10
Views: 2571

The ULIMIT in uvconfig is ignored if the UNIX ulimit is larger that the value specified in uvconfig.