"Before Job SQL" in PX

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

"Before Job SQL" in PX

Post by Sreenivasulu »

Hi Guys,

You might be knkowing that there is a feature of "Before Job SQL" in Oracle Enterprise stage of Server edition. I came to know that this feature is not present in Oracle Enterprise stage of Parallel edition. :shock:


Any idea of how you guys are implementing "Before Job SQL" in Parallel jobs (Oracle enterprise stage)

Regards
Sreeni
Top
mahadev.v
Participant
Posts: 111
Joined: Tue May 06, 2008 5:29 am
Location: Bangalore

Post by mahadev.v »

There are options in Oracle Enterprise stage called "Open Command" and "Close Command" for implementing this.
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
Top
srinivas.g
Participant
Posts: 251
Joined: Mon Jun 09, 2008 5:52 am

Post by srinivas.g »

Use DRS stage . this stage contains before and after stage sql options
Srinu Gadipudi
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So does the OCI stage, but neither one is a PX "Enterprise" stage. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”