before SQL and After SQL in paralllel jobs

jprasannakumar · 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 .

Kirtikumar · Post by **Kirtikumar** » Thu Mar 01, 2007 2:31 am

Whats the problem? Which DB stage you are using for writing the SQL?

jprasannakumar · 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 ?

us1aslam1us · Post by **us1aslam1us** » Thu Mar 01, 2007 11:39 am

Kumar,You can check it by yourself.

samsuf2002 · 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

DSguru2B · 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.