Question ID : 203
Created on 2013-07-15 at 4:09 AM
Author : Veryant Support [support@veryant.com]
Online URL : http://support.veryant.com/support/phpkb/question.php?ID=203
isCOBOL's ESQL engine supports the CALL statement, making calling a stored procedure from isCOBOL easy.
Here's an example of a call to a procedure with parameters and their types specified, returning a status:
exec sql
call proc1(:p1 IN, :p2 OUT) into :exit-status
end-exe
You can read more about the syntax of a stored procedure CALL in the Language Reference/Embedded SQL Statements/CALL section of the isCOBOL documentation