Topic
No replies
SystemAdmin
SystemAdmin
93 Posts
ACCEPTED ANSWER

Pinned topic issue with calling stored procedure

‏2006-11-13T04:11:18Z |
I am new to dtastage designerETL tool.
I want to call a stored procedure by creating a job in data stage designer. Can you please suggest me which job shall i select among server or parallel to do the same.

After selecting a server/parallel job i need to call the stored procedure in sybase data base. We have 4 different scenarios.

1) The called stored procedre updates sometables in sybase. So i need a job that just executes the stored procedure in sybase{Stored procedure dont have any input or output

2)Need to call a stored procedure with some input parameters and stored procedure dont return any thing.

3)Need to call stored procedure with some input parameters and 1 error code output parameter need to be put in a sequential file kept on unix server.

4)Need to call stored procedure with some input parameters and that stored procedure may update some tables and that output need to be put to a sequential file..

Can any one provide me necessary guidelines to create the jobs mentioned above.