Search found 53125 matches

by ray.wurlod
Tue Apr 25, 2006 1:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: QUERY UNIVERSE DATABASE
Replies: 18
Views: 7773

Doesn't Search work in your browser? The URL you require is that of the IBM UniVerse manuals library for version 9.6, the version at which both products were most recently in sync.
by ray.wurlod
Tue Apr 25, 2006 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine does not produce desired o/p in datastage job
Replies: 13
Views: 3335

No, you have not expressed it correctly.

The file name that the routine was being given was set to "" - not the file name that the routine was coming up with. The routine does not generate a file name. Your language looks like an exercise in blame shifting.
by ray.wurlod
Tue Apr 25, 2006 1:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Internal mechanism of Hashfile while job is running
Replies: 12
Views: 2525

As far as I am aware, hashed files are not cached when being used to feed a stream link such as the design described here. What occurs instead is a "fast group read" in which the hashed file is read one group (page) at a time and the records within that group are fed onto the stream. This approach s...
by ray.wurlod
Tue Apr 25, 2006 1:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: connect failed --Oracle error: -2127
Replies: 9
Views: 4728

Check that your Oracle client software is at the same version as your Oracle server.
What stage type are you using in your DataStage job?
by ray.wurlod
Tue Apr 25, 2006 1:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Arithmetic inDatastage
Replies: 5
Views: 4542

[THREAD HIJACK!!!]

Please start a new thread for this question. It is not related to the topic of this thread.
by ray.wurlod
Tue Apr 25, 2006 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nullable warning
Replies: 16
Views: 5701

Try specifying any nine-character string as the null value (in the Sequential File stage), for example "*********".
by ray.wurlod
Mon Apr 24, 2006 6:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file error
Replies: 7
Views: 3154

What's changed? Presumably this job ran successfully prior - or is it a new job that has never been run?
by ray.wurlod
Mon Apr 24, 2006 5:47 pm
Forum: Site/Forum
Topic: Unread Posts
Replies: 4
Views: 2434

Unread Posts

When one opens DSXchange, unread posts are highlighted using a different colour. However, if one has to leave before reading the 150 or so posts that seem to come in each day, there is no easy way to determine which remain unread. With that volume of posts it's almost impossible to leave - one finis...
by ray.wurlod
Mon Apr 24, 2006 5:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look Up Stage Error
Replies: 3
Views: 977

Do you (that is, the user ID that runs the job) have rwx permission to /usr/tmp and at least x permission to / and /usr ?
by ray.wurlod
Mon Apr 24, 2006 5:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Multiple instance job
Replies: 9
Views: 2081

Look in the log for JOB A. Look for processes associated with JOB A (in Cleanup Resources). Has JOB A aborted without being able to update its status and log records? (If so, you won't find any process associated with it, in which case clear its status file and look in &PH& directory for any...
by ray.wurlod
Mon Apr 24, 2006 5:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: (DSOpenJob) Cannot open job - not a runnable job
Replies: 10
Views: 7744

Verify that the job is in a runnable state just before running the batch.
Check the job log for job XYZ both before and after running the batch.
Post your results.
by ray.wurlod
Mon Apr 24, 2006 5:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error reading unix fixed width file from remote server
Replies: 7
Views: 2161

"Termination characters not at expected location" usually indicates either that there's a short line in your data (check line number 1921) or that there is a data field in which a line terminator appears. You can handle thes using the Columns grid - set the "contains terminator" and "missing columns...
by ray.wurlod
Mon Apr 24, 2006 5:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS Oracle metadata import problems
Replies: 5
Views: 1233

The UNIX environment variable NLS_LANG can affect this. What is its setting? Have you asked your support provider about this - there may be strangeness(es) in the interface to Oracle 10g NLS.
by ray.wurlod
Mon Apr 24, 2006 5:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compare dsx files
Replies: 7
Views: 1914

Probably the easiest is to use diff and ignore the couple of properties (host name, timestamp) that you would expect to be different. In the next ("Hawk") release there is a side-by-side comparison tool where you can perform this task at a component level (job, routine, etc.) and generate a differen...
by ray.wurlod
Mon Apr 24, 2006 5:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Essbase - DataStage
Replies: 4
Views: 2935

Challenge IBM (via your support provider). The marketing material IBM puts out makes the "any source, any target" claim.