Calling Stored Procedure from datastage

[lathalr]

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

[ray.wurlod]

The Stored Procedure didn't return anything. DataStage has informed you of that fact.