Stored Procedure running fine in DB but throws warning in DS
Posted: Wed Nov 16, 2005 12:35 am
Hi DS Gurus,
I am calling a DB2 SP in a db stage. This SP is built with some Dynamic SQL statements but Execute immediate statements were not used in it.
This procedure works fine in database but while executing in dtastage it shows warning (Prepare or Execute Statement is blank or empty SQLSTATE=42617) which means NULL is returned to the execute statements. But I havn't used these Prepare and Execute Statements in the SP itself. More over I got the solution correctly.
Any solution
Vinod
I am calling a DB2 SP in a db stage. This SP is built with some Dynamic SQL statements but Execute immediate statements were not used in it.
This procedure works fine in database but while executing in dtastage it shows warning (Prepare or Execute Statement is blank or empty SQLSTATE=42617) which means NULL is returned to the execute statements. But I havn't used these Prepare and Execute Statements in the SP itself. More over I got the solution correctly.
Any solution
Vinod