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     [CASE-OPENED] Error while Executing DB2 Stored Procedure
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] Error while Executing DB2 Stored Procedure
 Login/Join
 
Guru
posted
I am trying to execute a DB2 Stored procedure from webfocus.

My code is


SQL DB2 PREPARE SQLOUT FOR
EX FMTSTDTAF1/BRANDLOAD_AARRD 'BR','ARC', NULL;

TABLE FILE SQLOUT
PRINT
*
END


I am getting the following error.

(FOC1400) SQLCODE IS -104 (HEX: FFFFFF98) XOPEN: 42000
L (FOC1405) SQL PREPARE ERROR.



Where in I am able to sucessfully execute a query or call a Stored procedure.

SQL DB2 PREPARE SQLOUT FOR
CALL FMTSTDTAF1/BRANDLOAD_AARRD('BR','ARC', NULL);

TABLE FILE SQLOUT
PRINT
*
END
This works... So Is not a connectivity issue.

But calling a Stored proc does'nt fetch me the Result set in SQLOUT.

How to go about this ?

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
Expert
posted Hide Post
Hi all,

FYI, Ramkumar has a case opened regarding this issue.

Ramkumar, when you have an update/solution from the case, can you please kindly share with all? Thank you.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Error while Executing DB2 Stored Procedure

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