Search found 53125 matches

by ray.wurlod
Tue Jun 27, 2006 4:14 pm
Forum: Site/Forum
Topic: Australia/New Zealand User Group
Replies: 4
Views: 2333

Was it the thought of beer?

My initial concern is to gather expressions of interest for running the Server to Parallel Transition Lab in this part of the world.
by ray.wurlod
Tue Jun 27, 2006 12:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get Job Type (Sequence, Server or EE Job)
Replies: 8
Views: 1394

In case anyone is wondering, 1 is mainframe job.
by ray.wurlod
Mon Jun 26, 2006 9:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Advantage of Datastage over materialized views
Replies: 3
Views: 2529

Do you have any not-fully-additive facts? You will find that these are very difficult to maintain with DataStage, but that's better than the impossible with materialized views.
by ray.wurlod
Mon Jun 26, 2006 9:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: USS System ?
Replies: 8
Views: 2193

kduke wrote:It is my understanding that USS is to mainframes like MKS Toolkit is to Windows. It is a UNIX emulator that runs under a different OS.

Simplified. Highly simplified. But gets the idea across satisfactorily.
by ray.wurlod
Mon Jun 26, 2006 6:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Advantage of Datastage over materialized views
Replies: 3
Views: 2529

DataStage is not a tool for producing reports. :x
by ray.wurlod
Mon Jun 26, 2006 6:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with ORACLE 9I and NVarChar data type
Replies: 5
Views: 2485

Re: Problem with ORACLE 9I and NVarChar data type

Where could be the difference among this server and all others (my Lab and the environments from other posters)? It's easier for you to answer that question than for us to - we don't have access to your environments. I'd be looking first at differences in how the Oracle client software (particularl...
by ray.wurlod
Mon Jun 26, 2006 6:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Updating/Inserting a Record where key is NULL
Replies: 5
Views: 1594

That is true, but imho whoever designed a table that allows NULL as a key needs some reminding about sensible database design techniques.
by ray.wurlod
Mon Jun 26, 2006 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Array Size problem
Replies: 23
Views: 5483

Array size is more relevant when the OCI stage has input link. It's then where the array is a parameter array that better use may be made of transmission channels.
by ray.wurlod
Mon Jun 26, 2006 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Array Size problem
Replies: 23
Views: 5483

Only by changing the rules of arithmetic so that 30 is a whole divisor of 65.
by ray.wurlod
Mon Jun 26, 2006 3:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with ORACLE 9I and NVarChar data type
Replies: 5
Views: 2485

Leave it as VarChar; make the Display Width double the Precision. Change the Derivation of the column to CAST(column AS VARCHAR2(precision))
by ray.wurlod
Mon Jun 26, 2006 3:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: X-Stages in ETL cycle
Replies: 8
Views: 2963

The reseller from which your client purchased DataStage should also be able to supply technical information about, and technical presentations of, the other products in the suite.
by ray.wurlod
Mon Jun 26, 2006 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is the difference between Reset and Clear Status file
Replies: 3
Views: 2148

Have you read about each option in online help or in the manual (Director Guide (dsopsgde.pdf) )?
by ray.wurlod
Mon Jun 26, 2006 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: run time fatal error : Player 12 terminated unexpectedly
Replies: 23
Views: 9040

It would be nice to know what kind of "intermittent problems" have been observed when the job monitor was executing at an interval of too few rows. I can't see that "unexpected termination" of a single player process would be caused by the job monitor. I'd be more likely to suspect totally exhaustin...
by ray.wurlod
Mon Jun 26, 2006 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not open or create a temporary file
Replies: 1
Views: 1715

Get your user ID granted privilege in Informix to create temporary tables. These are used to hold result sets that are too large to hold in memory.
by ray.wurlod
Mon Jun 26, 2006 6:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: why does Datastage not support Datatype INT8(serial8)
Replies: 20
Views: 9199

How about

Code: Select all

SELECT o_abc_uid + 0 FROM tablename...

Hopefully the arithmetic will perform a legal implicit CAST.