Can I call a stored procedure from an isCobol program?

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

Article ID: 203
Created: July 15, 2013
Last Updated: March 17, 2023
Author: Support KB Author

Online URL: https://support.veryant.com/support/phpkb/article.php?id=203