Hi All,
In datastage we are calling stored procedure to load the main tables from staging tables.
our job looks like row_generator -> transformer -> stored procedure stage -> output file
We are creating and passing input parameter to stored procedure and also passing the status to output file using parameter
Stored procedure is running fine in back end, but getting error while running it from datastage.
And the job got hanged after this error:
Stored_Procedure_0,0: Info: Stored_Procedure.Stored_Procedure_0: CLI_NO_DATA
Please help me on this.
thanks in advance
Calling Stored Procedure from datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: