Page 1 of 1
before SQL and After SQL in paralllel jobs
Posted: Thu Mar 01, 2007 1:25 am
by jprasannakumar
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 .
Posted: Thu Mar 01, 2007 2:31 am
by Kirtikumar
Whats the problem? Which DB stage you are using for writing the SQL?
Posted: Thu Mar 01, 2007 9:59 am
by jprasannakumar
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 ?
Posted: Thu Mar 01, 2007 11:39 am
by us1aslam1us
Kumar,You can check it by yourself.
Posted: Thu Mar 01, 2007 1:19 pm
by samsuf2002
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
Posted: Thu Mar 01, 2007 4:56 pm
by DSguru2B
The OPEN and CLOSE commands are similar to the before/after sql. Read about them in DataStage help.