Search found 53125 matches

by ray.wurlod
Sun Aug 26, 2007 3:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connect & Execute Oracle SQL by script
Replies: 12
Views: 3543

What is logged as the command executed?
I'd suggest you need a statement

Code: Select all

Command = ""

to initialize the dynamic array, prior to the statement that assigns a value to Command<1>
by ray.wurlod
Sun Aug 26, 2007 2:59 am
Forum: General
Topic: Creating Recursively Hierarchical XML files using DataStage
Replies: 11
Views: 8267

I would be inclined to solve this using a hashed file together with a little known command called WITHIN, designed specifically for this kind of nested, or recursive, traversal.
by ray.wurlod
Sat Aug 25, 2007 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage 8 /IS8 Server running on Win XP
Replies: 5
Views: 2060

You won't get any support from IBM either! :wink:
by ray.wurlod
Sat Aug 25, 2007 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job reports failure (code 139)
Replies: 5
Views: 3541

ANYTHING that has changed. For example are you now running under a different user ID? Has the user's ulimit changed? What stage types are there in your job? What other tasks are happening at the same time? (These are just examples. You need to be the detective.)
by ray.wurlod
Sat Aug 25, 2007 2:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash stage usage
Replies: 2
Views: 978

There are several ways to have one job "internally call" another, such as before-job subroutine or job control routine. That said, I would advocate keeping the execution modular, and creating a job sequence to run the one then the other. It would then be the job sequence that you execute, rather tha...
by ray.wurlod
Sat Aug 25, 2007 2:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How filtering is done by Datastage Engine.
Replies: 2
Views: 997

Think of it as an alert, rather than as a warning. It also serves as a convenient mechanism to detect later that one or more rows rejected; without it you would need to determine the row count from that particular link. Design either way, depending on your particular style.
by ray.wurlod
Sat Aug 25, 2007 2:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to load subroutine on host (30105
Replies: 19
Views: 13298

What's different about the third project?
by ray.wurlod
Sat Aug 25, 2007 2:50 pm
Forum: General
Topic: Creating Recursively Hierarchical XML files using DataStage
Replies: 11
Views: 8267

DataStage server edition is singularly well-equipped for this task, since data are processed within DataStage as character strings, exactly as they are in XML, and variable-length is a given. The actual approach taken would depend on how many levels of hierarchy are needed. Even so, an arbitrary num...
by ray.wurlod
Fri Aug 24, 2007 4:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Function 'get_next_output_row' failed - Error in datastage
Replies: 2
Views: 1611

Does your file lack a line terminator on the last line?
by ray.wurlod
Fri Aug 24, 2007 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combining Data with no Specific Key
Replies: 3
Views: 932

I hope you exercised great creativity in naming this column! :lol:
by ray.wurlod
Fri Aug 24, 2007 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dynamic configuration settings
Replies: 14
Views: 4201

A parallel job usually has one configuration file. You parameterize this by including $APT_CONFIG_FILE as a job parameter. However, there is no easy mechanism for changing configuration files once the job is running. IBM reserve unto themselves the ability to install dynamic configuration files such...
by ray.wurlod
Fri Aug 24, 2007 3:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Last 8 Digits
Replies: 6
Views: 1359

Apendix A, Parallel Job Developers Guide
by ray.wurlod
Fri Aug 24, 2007 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output stage Issue
Replies: 5
Views: 1457

Time to mark the thread as Resolved, then?
by ray.wurlod
Fri Aug 24, 2007 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IS DataStage 8.0.1 Mult Client Shut Down w DataStage 7.5.2
Replies: 2
Views: 1500

Version 7.5.2 does not have an active client, so would not need its client to be shut down. But then you confuse me by referring to dsenv, which is a file on the server. What's really happening here? If both versions are running on the server, then your shutdown script ought to shut down both. And t...