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.
PL/SQL
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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".
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".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
alexysflores
- Participant
- Posts: 18
- Joined: Mon Jan 12, 2004 7:20 am
- Location: USA
Re: PL/SQL
[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.
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.