Search found 53125 matches

by ray.wurlod
Tue Mar 15, 2011 6:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Surrogate Key generator stage in 8.1 PX version
Replies: 2
Views: 1967

With the value 1080019000000000000 you have achieved a arithmetic underflow. Research the term "twos complement" to see why.
by ray.wurlod
Tue Mar 15, 2011 6:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how can i get the received file timestamp in datastage
Replies: 2
Views: 2026

Re: how can i get the received file timestamp in datastage

Currently we are handling the basic- routine but going forward we wont use server jobs and basic routines. Why ever not? BASIC routines are going to be around for sequences (the routine called from a Routine activity is a BASIC routine). And that makes it really easy to obtain the file timestamps (...
by ray.wurlod
Tue Mar 15, 2011 6:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: issue on Type30 files
Replies: 13
Views: 7029

Yes it does. analyze.shm, smat, semaphore_status and list_readu all share the same executable.

(And I mean the Windows version. Some AIX versions also don't support these commands.)
by ray.wurlod
Tue Mar 15, 2011 6:35 pm
Forum: General
Topic: connect to datasources issue
Replies: 4
Views: 2266

1. Not correct, though the DS_CONNECT test utility is used from this environment. 2. Once you've invoked DS_CONNECT successfully you are acting as a client to the ODBC-connected database, so can enter SQL statements that are legal for that environment. (Use the .Q command to exit from DS_CONNECT.) 3...
by ray.wurlod
Tue Mar 15, 2011 4:58 pm
Forum: General
Topic: Parameter Sets - Password Maintenance by Support Staff
Replies: 3
Views: 5160

I am not aware of any method for updating the encrypted password values in Values Files of Parameter Sets without using DataStage. At least not legally. You could have passwords stored en clair but in Values Files with 700 permissions and only the owner permitted to update them. I have seen this app...
by ray.wurlod
Tue Mar 15, 2011 4:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage error
Replies: 1
Views: 1658

You don't get input or output tabs until you draw links that connect to the stage. It's not clear what you're doing that might involve node pools; you can ignore this warning for the time being until you get some complete job designs. Are you running on a supported Windows operating system (Windows ...
by ray.wurlod
Tue Mar 15, 2011 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage processes
Replies: 1
Views: 1251

It's never been true that Modify stage never creates processes. It's still true that the modify operator *may* be incorporated into the downstream stage's input link processing. This will be determined when the score is composed.
by ray.wurlod
Tue Mar 15, 2011 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orcadmin utility
Replies: 4
Views: 2654

Sauron: the original orc admin
:lol:
by ray.wurlod
Tue Mar 15, 2011 4:47 pm
Forum: General
Topic: Datastage 8.5 Trial Version
Replies: 2
Views: 11941

No.

You might be able to sweet talk your vendor into an "evaluation version" but that's still contingent on a sale being likely.
by ray.wurlod
Tue Mar 15, 2011 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calculating subtotals
Replies: 4
Views: 2960

Fork join. (Search)

In the Aggegregtor stage count the rows for each group (each key value).

Funnel based on the key value.

Make sure your data are properly sorted and partitioned on the key value (or, for a small enough number of rows, process on a single node).
by ray.wurlod
Tue Mar 15, 2011 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to understand job score (1)
Replies: 11
Views: 7198

Data sets are virtual or physical. In the example, ds0 is a phyiscal data set. There is a virtual data set associated with each link in the job that is actually executed. eAny is actually "(Auto)", not Round Robin. Likewise eCollectAny is "(Auto)". When eOther is used the actual ...
by ray.wurlod
Tue Mar 15, 2011 4:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Recursive Select with DB2
Replies: 6
Views: 6081

Or use AS clauses to give your columns names in the user-defined SQL. These column names must match those on the Columns grid.
by ray.wurlod
Tue Mar 15, 2011 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LANG Environment variable
Replies: 4
Views: 2940

As a general rule, if someone can contribute something they will. Learn patience.
by ray.wurlod
Tue Mar 15, 2011 4:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create or import PACKAGE from IS manager
Replies: 3
Views: 1440

Don't have access to ISM at the moment, but would guess Tools > Preferences (or Options, or whatever it's called).
by ray.wurlod
Tue Mar 15, 2011 4:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modifying Job Export XML
Replies: 7
Views: 3282

Keep in mind that importing from XML involves (a) converting from XML to DSX then (b) importing from DSX. So if you start playing around with the XML, you may also have to write your own XML to DSX functionality.