Page 1 of 1
Before/After sql
Posted: Wed Feb 23, 2005 1:20 pm
by madhonrougeuri
Hi,
Could any body tell me in what case is before/after sql used in OCI stage..any examples?
Thanks.
Posted: Wed Feb 23, 2005 2:09 pm
by denzilsyb
I do think there are many applications of the before/after subs, but one could be to check the value of a column in another table and depending on that value something could happen to the input column... far fetched though...
I do not think before and after for a stage is the best thing because every row is evaluated against the before/after routine, so the I/Os could easily becme tedious and slow down the process.
Re: Before/After sql
Posted: Wed Feb 23, 2005 2:16 pm
by kcbland
madhonrougeuri wrote:Hi,
Could any body tell me in what case is before/after sql used in OCI stage..any examples?
Thanks.
For Oracle, you could find uses such as:
Code: Select all
ALTER SESSION DISABLE PARALLEL QUERY;
Or
Code: Select all
ALTER SESSION ENABLE PARALLEL DML;
Or
Code: Select all
Grants, Drops, Creates, Stored Procs, etc
Re: Before/After sql
Posted: Wed Feb 23, 2005 2:20 pm
by denzilsyb
kcbland wrote:a double gargle blaster!
thats one helluva drink KC!
Posted: Wed Feb 23, 2005 2:32 pm
by kcbland
Posted: Wed Feb 23, 2005 2:39 pm
by madhonrougeuri
Thanks...
Posted: Thu Apr 21, 2005 9:46 am
by sck
Suppose if no rows were processed that is the number of rows to the input link (lets take the case of error processing then) will the after SQL still get executed???
Thanks
SCK
Posted: Thu Apr 21, 2005 9:57 am
by wnogalski
Yes.