Hi All,
I have defined following stored procedure(macro) in the Terdata (database):
REPLACE MACRO SP_MACRO_3 (SID INTEGER,S_FREQUENCY VARCHAR(10))
AS (
SELECT SID, BU_ID, SF_CODE, S_IND
FROM TableS
WHERE SID IN (:SID) AND
S_FREQUENCY in ( :S_FREQUENCY);
);
Please Note this a simple select statement from a table where filters are put according to parameters passed. Also Note, All the columns which are displayed are integer except S_ID which is Varchar.
This is giving me an error in report studio (and not in framework):
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0283 Metadata describing 'S_IND'; does not match results from the database.
This works fine on framework and I am able to test it and see the result set, When I remove column S_IND (which is a varchar ) , it run fines. Can any one Tell me what the issue can be?
Thanks in advance.
I have already tried following link resolution which is not working:
http://www-01.ibm.com/support/docview.wss?uid=swg21342310
No idea about the generated error code, but why on earth do you call a stored procedure when you can define all of it in a Cognos SQL subject?
Hi nexgen,
Even i m getting same kind of error. I would be helpful if you can post the solution