Focal Point
[CASE-OPENED] Error while Executing DB2 Stored Procedure

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

November 11, 2010, 10:09 AM
Ramkumar - Webfous
[CASE-OPENED] Error while Executing DB2 Stored Procedure
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
November 23, 2010, 11:57 AM
Kerry
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.