Page 1 of 1
PL/SQL
Posted: Wed Oct 20, 2004 11:17 am
by srinu_p
Hi,
what purposes do we use stored procedures and functions in Data Stage in real time?
can we use them to load data from various source systems into staging area?
SP.
Posted: Wed Oct 20, 2004 4:07 pm
by ray.wurlod
What do you mean by "real time"?
Yes, you can use stored procedures, subject to some restrictions (for example the SP must process a record set).
The stored procedure definition must first be imported into the DataStage Repository (so that DataStage can check that the correct number of arguments is given when the SP is used).
You can use the SP (for example) using an ODBC stage where the selection/update rule is "use stored procedure".
Re: PL/SQL
Posted: Wed Oct 20, 2004 4:31 pm
by alexysflores
[quote="srinu_p"]Hi,
what purposes do we use stored procedures and functions in Data Stage in real time?
can we use them to load data from various source systems into staging area?
SP.[/quote]
The use of SP depends on your need and your design methodologies of DS jobs.