DataStage stored procedure stage is a stage which gives us an opportunity to connect to a database and call a SP. This stage will add the power of database into the DataStage job. Stored Procedure stage can pass parameters to the database stored procedure as return result set to the downstream links. However following are few points which one should remember while using the SPs:
1. SPs will get executed for every single records and DataStage will make context switch between DataStage and database for every record. Hence be careful while designing your job using SPs.
2. SP stage needs username and password however user name can be passed as parameter but password needs to be actual. SP stage does not display the password it encrypt it but one can struggle if passed the parameter as password.
3. SP stage is good when used with less number of input records or just to invoke the DS tasks.
DataStage stored procedure stage is a stage which gives us an opportunity to connect to a database and call a SP. This stage will add the power of database into the DataStage job. Stored Procedure stage can pass parameters to the database stored procedure as return result set to the downstream links. However following are few points which one should remember while using the SPs:
ReplyDelete1. SPs will get executed for every single records and DataStage will make context switch between DataStage and database for every record. Hence be careful while designing your job using SPs.
2. SP stage needs username and password however user name can be passed as parameter but password needs to be actual. SP stage does not display the password it encrypt it but one can struggle if passed the parameter as password.
3. SP stage is good when used with less number of input records or just to invoke the DS tasks.