Reg odbc stored procedure
Moderators: chulett, rschirm, roy
Reg odbc stored procedure
We are getting warning while accessing a stored procedure, which takes a single parameter from a sequential file and returns a result set of 3 columns. we need to know how to pass parameter value by taking from a file to the ODBC stage to trigger SP and capture the result set in a file.
Reg odbc stored procedure
[quote="chulett"]Warning? What warning?[/quote
The warning is
"
CopyOfTEST_SP..Transformer_20.Ref_data: DSD.BCIPut call to SQLExecute failed.
SQL statement:{call IntlHeadCount.dbo.sp_user_scope_ifeed(?)}
SQLSTATE=24000, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Invalid cursor state
AG_USER_ID = "utester1124""
Pls let me know if any furher input is needed
The warning is
"
CopyOfTEST_SP..Transformer_20.Ref_data: DSD.BCIPut call to SQLExecute failed.
SQL statement:{call IntlHeadCount.dbo.sp_user_scope_ifeed(?)}
SQLSTATE=24000, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Invalid cursor state
AG_USER_ID = "utester1124""
Pls let me know if any furher input is needed