[CLOSED] Error While Creating a Synonym for DB2 Stored Proc
I am trying to create a webfocus Synonym for a Stored procedure in DB2.
But I am not able to do that...
The Following error occurs, while searching for Sps.
Where in I am able to acess the Tables and View and able to create Synonyms sucessfully. But for STored procedures, It is throwing the above error.
I tried for all webforums. No useful information I got through all over.
If anyone had faced on such issue, Please do help...This message has been edited. Last edited by: Kerry,
Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5
December 07, 2010, 12:14 PM
From the DB2 mauals:
-822 THE SQLDA CONTAINS AN INVALID DATA ADDRESS OR INDICATOR VARIABLE ADDRESS
Explanation: The application program has placed an invalid address in the SQLDA.
System Action: The statement cannot be executed.
Programmer Response: Correct the application program such that valid addresses are placed in SQLDA.
You're using webfocus 762. What DB2 version are you reporting against? Is that a combination that is fully supported? If in doubt, you had best open a case with IB tech support to help you out.
- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
December 09, 2010, 09:35 AM
If you look at your server log, you should be able to find a 'TYPE n' number. I am seeing 8 different possible issues depending on what that number is. My SQLCODE book says:
'For Types 1, 2, 3, or 8, change the address in entry &1 to a valid address. For types 4 and 5, allocate enough area for all of the rows being requested. For types 6 and 7, initialize the SQLDATA or SQLIND fields to a valid value. Try the request again.'
If you want to find this book, GOOGLE "DB2 UNIVERSAL DATABASE FOR iSERIES SQL MESSAGE AND CODES".