Search found 53125 matches

by ray.wurlod
Mon Dec 13, 2010 11:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: long datatype issue in Oracle EE stage
Replies: 3
Views: 1156

Learn patience. If you truly need answers within an hour, particularly when it's midnight in DSXchange-land, sign up with your official support provider for priority service. Learn just how much "urgent" is worth. DSXchange is an all-volunteer site, whose members post as and when they can...
by ray.wurlod
Mon Dec 13, 2010 10:24 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Execute Column Analysis in IA
Replies: 13
Views: 6144

Are you logging locally or to the common metadata repository? What are the values of ORLogging and RTLogging in the DSParams file in your analyzer project?
by ray.wurlod
Mon Dec 13, 2010 10:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg Architecture
Replies: 2
Views: 1363

Please try to maintain a professional standard of written English on DSXchange. It helps those whose first language is not English. Have you looked in the manuals and on the IBM website? There is more than one possible architecture for Information Server or, to put that another way, there's no sing...
by ray.wurlod
Mon Dec 13, 2010 10:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CSV file with column value with double quote
Replies: 4
Views: 2644

You've been here long enough to know about Search function.

Why did you specify Quote=double when clearly this is not true? Why not specify Quote=none (000)?
by ray.wurlod
Mon Dec 13, 2010 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Junk character
Replies: 1
Views: 1008

A Search of DSXchange may have saved you waiting for an answer. The usual approach to this kind of problem is to convert the junk characters to "". A more generic approach is nested Convert() functions, the inner to convert all the "good" characters to "" and the outer ...
by ray.wurlod
Mon Dec 13, 2010 7:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup_int16_from_string
Replies: 4
Views: 1365

You can do either lookup. But there's only one format for the {table_definition} that you include in the function. Review the manual carefully - it is properly explained there.
by ray.wurlod
Mon Dec 13, 2010 7:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query on Score Dump
Replies: 6
Views: 2000

The actual lookup operation is performed by LUT_ProcessOp. If that's running in parallel then the lookups are being performed on all nodes, all referring to the single copy in shared memory used to implement the Entire partitioning algorithm.
by ray.wurlod
Mon Dec 13, 2010 7:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine Retruning error code 126
Replies: 1
Views: 2433

There should be a file somewhere on your system called something like err.h where the common UNIX error codes may be documented.
by ray.wurlod
Mon Dec 13, 2010 6:59 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Cross Column Analysis in IA
Replies: 5
Views: 2796

I'm not sure whether or not you've run the Cross Domain analyses on virtual columns but, assuming that you have, then your requirement would seem to me to be one for Foreign Key analysis.
by ray.wurlod
Mon Dec 13, 2010 3:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while sending mail.
Replies: 2
Views: 3034

What's different between dev region and other region? "Nothing" is not the correct answer.
by ray.wurlod
Mon Dec 13, 2010 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Nullability Issue
Replies: 5
Views: 1652

From which stage was this error message generated? Check nullability of the column on the input link to this stage.
by ray.wurlod
Mon Dec 13, 2010 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete statement in DRS Stage for Oracle database
Replies: 4
Views: 1511

You would need two jobs to achieve this or, perhaps, user-defined SQL to call a stored procedure.
by ray.wurlod
Mon Dec 13, 2010 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query on Score Dump
Replies: 6
Views: 2000

The LUT_CreateOp operator (one of two operators in the composite operator generated from a Lookup stage performing "=" lookups) is running on a single node in this score. There are at least three possible reasons for this: the stage is configured for Sequential operation (check the number ...
by ray.wurlod
Mon Dec 13, 2010 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage 390 to DataStage 7.5 Parallel jobs conversion
Replies: 1
Views: 997

1. Feasible. 2. Analyze the logic of the mainframe jobs (they're usually very simple) and reproduce in server/parallel jobs. 3. Impossible for me to determine. Will you, for example, be relinquishing the mainframe DataStage license? Will you continue to need to access data on the mainframe and, if s...
by ray.wurlod
Mon Dec 13, 2010 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No output from job using vectors
Replies: 2
Views: 814

Show us what "combine" actually means. Also, since there's no such thing as a "subrecord stage", please confirm the actual stage type that you're using.