Focal Point
[CLOSED] Error While Creating a Synonym for DB2 Stored Proc

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6247029495

December 07, 2010, 04:39 AM
Ramkumar - Webfous
[CLOSED] Error While Creating a Synonym for DB2 Stored Proc
Hi...

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,


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
December 07, 2010, 12:14 PM
GamP
From the DB2 mauals:
quote:

-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.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
December 09, 2010, 09:35 AM
T.Peters
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".


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702