Search found 42189 matches

by chulett
Sun Apr 19, 2009 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup not working
Replies: 8
Views: 1597

Two questions, one answer. Batting 500.
by chulett
Sun Apr 19, 2009 7:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation problem
Replies: 18
Views: 3484

That needs explaining. Describe the job and what "not compiling" means here, the specific problem / error reported would be swell, too.
by chulett
Sun Apr 19, 2009 7:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle 10g
Replies: 8
Views: 1970

You read the UNIX instructions, you need to find the DOS/Windows instructions as there's no "dsenv" file on a Windows server.
by chulett
Sun Apr 19, 2009 7:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job execution order
Replies: 6
Views: 1550

You mean 'Stage execution order' it seems. Being serious here with a somewhat silly answer, but... it starts with the first stage and continues following the links until the last stage. And that's more like what each record does, inside the job all of the stages are basically running simultaneously....
by chulett
Sat Apr 18, 2009 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: connection issue
Replies: 14
Views: 4324

Apparently not.
by chulett
Sat Apr 18, 2009 11:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle 10g
Replies: 8
Views: 1970

It's all in the docs that ship with the product, Installation and Configuration Guide and elsewhere. Not able to connect how? What happens?
by chulett
Sat Apr 18, 2009 11:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of I/P & O/P connection per transformer
Replies: 7
Views: 1519

No, not simply because of that and any 'max' would be theoretical and based on too many factors to list here or worry about. A lookup is a lookup, whether it's 35 on one transformer or 35 split across two or more transformers. Perhaps with multiple transformers and IPC use so that multiple processes...
by chulett
Sat Apr 18, 2009 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create and implement datastage API programms
Replies: 5
Views: 1747

Yup. For the record, there are dsjob command line equivalents for all of the "DSGet" functions.
by chulett
Sat Apr 18, 2009 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: if i have more than 10 keys columns to vertical pivot logic
Replies: 7
Views: 1775

And their number doesn't change the "how" of that processing.
by chulett
Fri Apr 17, 2009 4:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsapi process
Replies: 1
Views: 918

None, they are client connections.
by chulett
Fri Apr 17, 2009 1:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set Environment Variable
Replies: 9
Views: 5250

One mechanism you could use is the UtilityRunJob() function which lets you run a job from a transformer, one job per record. And if that record contained all of the needed parameters...
by chulett
Fri Apr 17, 2009 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set Environment Variable
Replies: 9
Views: 5250

You cannot 'see' the BASIC Transformer because it's not on the palette by default, you need to add it manually. How to do that has been discussed here several times, a search should find it.
by chulett
Fri Apr 17, 2009 1:40 pm
Forum: General
Topic: Null Values from ODBC stage
Replies: 1
Views: 889

Sure, after you repost this in the correct forum. This one is for discussion possible FAQ topics. Yours need to be in either the Server or PX/EE forum, depending on the job type in question.

*Note: Topic Relocated - Content Editor*
by chulett
Fri Apr 17, 2009 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set Environment Variable
Replies: 9
Views: 5250

Sure, a UserVariables stage could be set up to grab values from somewhere and instantiate them for other jobs, including an Oracle table I would think. Unless you pull them all at once and parse out what you need, however, pulling one at a time from a database will be pretty slow I'd wager.
by chulett
Fri Apr 17, 2009 12:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: couldn't set locale correctly
Replies: 5
Views: 1412

Best if you post the actual, unedited message from the log.