Search found 53125 matches

by ray.wurlod
Mon May 25, 2009 12:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Type Conversion in Server Jobs
Replies: 2
Views: 1239

Welcome aboard.

There isn't one. Data types are not enforced in server jobs - all conversions are automatic.

Moderator: please move to Server forum
by ray.wurlod
Sun May 24, 2009 11:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic to Parallel Transformer Conversion
Replies: 1
Views: 944

Welcome aboard. The answer is "no idea". ConvertMember1ToMember2() is a BASIC function written in-house at your site. Without knowing what that routine does, we are in no position to understand what -1 might mean. Peruse the code of the routine (post it if that doesn't violate any non-disc...
by ray.wurlod
Sat May 23, 2009 4:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: avoid pivot
Replies: 9
Views: 2483

Have you considered using an External Filter stage for your awk command?
by ray.wurlod
Fri May 22, 2009 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: last day of the month of a given date
Replies: 11
Views: 3926

There is a very old joke, though many say it's true, that goes something like this. A visitor to Ireland asks directions to a particular attraction, and gets the reply "well, if I were going there, I wouldn't be starting from here".
by ray.wurlod
Fri May 22, 2009 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: last day of the month of a given date
Replies: 11
Views: 3926

What if they're a DB2 shop? You've been in Ireland too long!
by ray.wurlod
Fri May 22, 2009 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: excel extract
Replies: 8
Views: 1776

Are you referring to the worksheets as system tables? You have to for ODBC access.
by ray.wurlod
Fri May 22, 2009 5:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration of DS7.1 to DS7.5.2:- Data quality issue
Replies: 10
Views: 4145

It may be a locale file for the database (rather than for DataStage) that is missing.
by ray.wurlod
Thu May 21, 2009 10:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Compilation problem
Replies: 5
Views: 2820

It is correct that you need to do so. Whether you did so correctly remains to be seen.
by ray.wurlod
Thu May 21, 2009 9:45 pm
Forum: General
Topic: Recovery on a release 8 system
Replies: 6
Views: 1454

Some of the DDL you seek is to be found in ${DSHOME}/../../ASBServer/bin/sql
by ray.wurlod
Thu May 21, 2009 9:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File not Available in Transformer
Replies: 11
Views: 4057

Is any of the key columns VarChar data type and, if so, are they identically trimmed? (Don't assert - check.)
by ray.wurlod
Thu May 21, 2009 9:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot see Projects from Administrator
Replies: 11
Views: 3766

Try closing the Administrator and opening a new one. (There's no other way to get it to refresh, though it *should* auto-refresh.)
by ray.wurlod
Thu May 21, 2009 8:45 pm
Forum: General
Topic: Recovery on a release 8 system
Replies: 6
Views: 1454

I suspect that IBM's position would be that, because everything is done through services, there is no way things can get out of synch.
by ray.wurlod
Thu May 21, 2009 7:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File not Available in Transformer
Replies: 11
Views: 4057

We need more information about your job design and data. What do you mean by "mapped"? Can you publish a picture of the Transformer stage editor? What do you mean by "do not see any records in sequential file"? Are you using View Data or some viewer on the server? Are you indeed ...
by ray.wurlod
Thu May 21, 2009 6:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Oracle enterprise
Replies: 2
Views: 1377

What particular error message is thrown? It does no good to try to guess this.
by ray.wurlod
Thu May 21, 2009 4:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mail
Replies: 6
Views: 1623

You can use the server hostname as the mail server name on UNIX.