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,

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