Search found 53125 matches

by ray.wurlod
Wed Aug 17, 2005 8:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Will there ever be an 'IN' clause for the Filter Stage
Replies: 10
Views: 4605

Pressed for time would be my guess - "they" would have been applying immense pressure to push product out the door. Manuals can always be fixed in the next release. :x
by ray.wurlod
Wed Aug 17, 2005 8:53 pm
Forum: IBM QualityStage
Topic: USING RULES Need help Overiding and stripping
Replies: 6
Views: 3379

There is no such thing as URGENT here.

If you have DataStage it's very easy to pre-process your data. It's more tedious to do using QualityStage stages, but in general it's possible.

Do you have DataStage?
by ray.wurlod
Wed Aug 17, 2005 4:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to add data to same seq file from more than one jobs
Replies: 8
Views: 1897

Not possible if the jobs are running at the same time. This is an O/S restriction, not a DataStage restriction. If the jobs are run consecutively, use "Append" as the rule. Updating rows in a text file is very difficult, and can really only be done through the ODBC driver for text files (and will be...
by ray.wurlod
Wed Aug 17, 2005 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: BW Load Pack - Push option with Process chain
Replies: 2
Views: 1029

I don't have this, so can't answer. What does the manual or on-line help tell you? Please post here so we can all know.
by ray.wurlod
Wed Aug 17, 2005 4:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: C Stage PlugIn function "Get" required
Replies: 7
Views: 2518

"Get" is the generic name of the method exposed by the passive stage and invoked by the active stage to retrieve the next row.
That it's "required" suggests that the plug-in has not properly registered its "Get" function.
by ray.wurlod
Wed Aug 17, 2005 4:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: constraints in transformer stage
Replies: 5
Views: 1817

So you really need Not(IsNull(In.Column))
by ray.wurlod
Wed Aug 17, 2005 4:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error adding project
Replies: 10
Views: 2203

The Template does not have a VOC and does not have any indexing. No, the problem has occurred when trying to create the indexes after copying the template the project. That's why I'm surprised there's no entry in UV.ACCOUNT - maybe it's removed if the install script doesn't complete successfully. Ca...
by ray.wurlod
Wed Aug 17, 2005 4:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cobol copybook to SQL conversion
Replies: 4
Views: 7310

If you import the Table Definition from the COBOL FD, it will be stored in and displayable from the Repository as if it were SQL data types. There is a post way back of a function to dump table definitions in various forms, one of which is standard CREATE TABLE statements. Search for it; get back if...
by ray.wurlod
Wed Aug 17, 2005 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DaysSinceFromDate function
Replies: 3
Views: 6240

my requirement is it use only the DaysSinceFromDate function Who made that a requirement? There is usually more than one way to achieve a result in DataStage, being forced to use one method may prevent your finding more efficient techniques. Neither did you tell us what the integer represents. Is i...
by ray.wurlod
Wed Aug 17, 2005 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Vs PX
Replies: 7
Views: 3103

Welcome aboard! :D You can do both pipeline parallelism and partition parallelism in server jobs; it's just that it's more automatic in parallel jobs. In server jobs pipeline parallelism is mainly effected through row buffering (and/or IPC stages), and partition parallelism through either multi-inst...
by ray.wurlod
Wed Aug 17, 2005 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Version History of DataStage
Replies: 9
Views: 6115

A short history is in the book Ascential legal would not allow to be published.
by ray.wurlod
Wed Aug 17, 2005 4:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NULL vs SPACE vs EMPTY String [Caution Rant Included]
Replies: 3
Views: 1199

Text files only have one data type. Text. :D
by ray.wurlod
Wed Aug 17, 2005 4:24 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Importing Oracle Meta
Replies: 10
Views: 5183

Is the Oracle instance running? For example can you connect to it using sqlplus from the ProfileStage machine? Indeed, is the Oracle client software installed and configured on that machine?
by ray.wurlod
Wed Aug 17, 2005 1:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Administrator Problems
Replies: 4
Views: 1448

Not sure that it's documented anywhere, as it's a "paragraph" (the UniVerse word for a script). You can inspect its contents in lots of ways; it's an entry in the VOC file. For example LIST.ITEM VOC 'DS.REINDEX' This will show some logic to select which Repository tables will have their indices rebu...
by ray.wurlod
Wed Aug 17, 2005 1:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error adding project
Replies: 10
Views: 2203

Are you in the Administrators group?