Can I call a stored procedure from an isCobol program?

Estimated Reading Time: < 1 Minute

203 Support KB Author March 17, 2023 Data Access 7512

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

Can I call a stored procedure from an isCobol program?

Estimated Reading Time: < 1 Minute Support KB Author March 17, 2023 7512