Hi Friends,
I have Created a Store Procedure and have 3 data input Parameter OrderStart , OrderEnd and ContractStart.
The Parameter works fine at the Database level.
The problem that I am facing is the when I am importing this in Framework manager I am getting the following error.
Can anyone help me to pass a prompt parameter from Framework manager to the Store procedure
Error message:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-56'.
UDA-SQL-0115 Inappropriate SQL request.
UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Syntax error, permission violation, or other nonspecific error (SQLSTATE=42000, SQLERRORCODE=0)
Also Please find attached how I have configured the parameter in the FM.
Please let me know what step am I missing
This might be one thing to try.
http://www-01.ibm.com/support/docview.wss?uid=swg21611587
"Resolving the problem
In Framework Manager, when you first double click on the stored procedure, up at the top of the dialog you'll see the "Stored Procedure Name", and beside that you'll see the "Type", which (by default) is set to "Data Query". Change that to "Data Modification" and the stored procedure should validate correctly."