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
jprasannakumar
Participant
Posts: 6 Joined: Sun Jan 29, 2006 3:57 am
Post
by jprasannakumar » Thu Mar 01, 2007 1:25 am
hi,
we have just moved from server to parallel Edition.
can any one help me to write before sqls and After SQL in the Parallel job .
PRASANNAKUMAR JAYARAJ
Kirtikumar
Participant
Posts: 437 Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India
Post
by Kirtikumar » Thu Mar 01, 2007 2:31 am
Whats the problem? Which DB stage you are using for writing the SQL?
Regards,
S. Kirtikumar.
jprasannakumar
Participant
Posts: 6 Joined: Sun Jan 29, 2006 3:57 am
Post
by jprasannakumar » Thu Mar 01, 2007 9:59 am
im using Oracle stage ..
i need to update few columns after the insert process. in server edition there is an option to execute the after SQl queries. is there any similar feature in PX ?
PRASANNAKUMAR JAYARAJ
us1aslam1us
Charter Member
Posts: 822 Joined: Sat Sep 17, 2005 5:25 pm
Location: USA
Post
by us1aslam1us » Thu Mar 01, 2007 11:39 am
Kumar,You can check it by yourself.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
samsuf2002
Premium Member
Posts: 397 Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse
Post
by samsuf2002 » Thu Mar 01, 2007 1:19 pm
You can use close command for after and open command for before. It will be in the option propety in oracle stage. please check it out
hi sam here
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Thu Mar 01, 2007 4:56 pm
The OPEN and CLOSE commands are similar to the before/after sql. Read about them in DataStage help.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.