Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Error While Creating a Synonym for DB2 Stored Proc
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Error While Creating a Synonym for DB2 Stored Proc
 Login/Join
 
Guru
posted
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
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Error While Creating a Synonym for DB2 Stored Proc

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.