Multiple SQL in Before/Afer sql

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
major
Premium Member
Premium Member
Posts: 167
Joined: Mon Nov 26, 2007 12:21 am

Multiple SQL in Before/Afer sql

Post by major »

Hi all,

I just wanted to know whether we can write multiple sql statements in before/after sql in Oracle OCI stage.

when i try wiht multiple queries it shows an error 'sql statement not properly ended'

Thansk,
ejazsalim
Premium Member
Premium Member
Posts: 51
Joined: Wed Apr 09, 2003 6:42 am
Location: VA, USA

Re: Multiple SQL in Before/Afer sql

Post by ejazsalim »

Yes you can separate them with ";"
major
Premium Member
Premium Member
Posts: 167
Joined: Mon Nov 26, 2007 12:21 am

Post by major »

Thanks its working fine.

Just want to share we should not put ; at last statement
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

Very good trick. Thanks for the updates
Post Reply