Search found 53125 matches

by ray.wurlod
Fri Feb 13, 2009 1:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Table information from web service..
Replies: 3
Views: 868

First question: how fast does the web service respond?
by ray.wurlod
Fri Feb 13, 2009 1:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling a job to run on the hour every hour
Replies: 4
Views: 971

That was the third option I suggested.

Premium membership is not expensive, at less than 30c per day, and it helps to defray the hosting and bandwidth costs incurred by DSXchange.
by ray.wurlod
Fri Feb 13, 2009 1:49 pm
Forum: General
Topic: Can we use DSOpenProject, DSOpenJob in basic routines?
Replies: 3
Views: 2525

DSOpenProject() exists only in the C-callable DataStage API, not in the DataStage BASIC API which is expected only ever to be used from within the context of a project.
by ray.wurlod
Fri Feb 13, 2009 1:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bizzare hashed file lookup issue
Replies: 9
Views: 3477

One says "" not found which suggests you're trying to look up a zero-length key. In the other one, it's failing to find a very long key value that ends with Ctrl-M - did it get read from source with UNIX line terminators specified when in fact it should have been read with DOS line termina...
by ray.wurlod
Fri Feb 13, 2009 1:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SERIOUS DESIGN PERFORMANCE ISSUES - WINDOWS
Replies: 9
Views: 3589

In addition to the above, lose any wallpaper/screensaver you have on the server and the client, particularly animated ones.
by ray.wurlod
Fri Feb 13, 2009 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash building job running longer than normal
Replies: 5
Views: 1303

Clearly something has changed. Time for your Sherlock Holmes impersonation.
by ray.wurlod
Fri Feb 13, 2009 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup On Multiple Records
Replies: 1
Views: 985

There's an "allow duplicates" drop-down in the Lookup stage.
Check for STATUS = "Y" downstream of the Lookup stage, or build the reference data set so that it only contains records with status = "Y" in the first place.
by ray.wurlod
Fri Feb 13, 2009 4:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling a job to run on the hour every hour
Replies: 4
Views: 971

1. Write your own job control routine.

2. Use a third-party scheduler and the dsjob command line interface.

3. Schedule it through Director (which uses AT) 24 separate times - one for each hour - every day.
by ray.wurlod
Fri Feb 13, 2009 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: failed to create stage server
Replies: 4
Views: 1951

... which you've now marked as Resolved. Please make a post indicating how it was resolved, to aid future searchers.
by ray.wurlod
Fri Feb 13, 2009 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture with 1.5 million rows
Replies: 4
Views: 1994

1.5 million is not a lot of rows for a parallel job. Go for it.
by ray.wurlod
Fri Feb 13, 2009 4:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Grouping the records of DS_AUDIT
Replies: 15
Views: 5584

Code: Select all

SELECT *
FROM DS_AUDIT
WHERE DTM >= '2008-01-01'
AND DTM < '2009-01-01'
WHEN DTM >= '2008-01-01'
AND DTM < '2009-01-01' ;
by ray.wurlod
Fri Feb 13, 2009 4:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation of Mainframe jobs
Replies: 7
Views: 1549

It's exactly the same installation process; you just add the mainframe (MVS edition) licence code when requested.
by ray.wurlod
Fri Feb 13, 2009 4:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unique Properties to pass to a Java Transform Stage?
Replies: 2
Views: 1091

Can you not simply create another job parameter that will be held unique?
by ray.wurlod
Fri Feb 13, 2009 4:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash building job running longer than normal
Replies: 5
Views: 1303

What's changed? In particular, what else is now happening on the server machine?
by ray.wurlod
Fri Feb 13, 2009 4:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract data from Websphere commerce Server?
Replies: 3
Views: 1384

I don't yet have version 8.1. Someone else will need to.