Callable Statements Can Now Be Used for Functions

Owned by Jenni Wallin
Apr 25, 2023
Case IDInternal IDComponentPackage Name

MZ-28755

APL 

databasefunctions_8.2.0.0.mzp
docweb _8.2.0.0.mzp

It is now possible to use Callable Statements for stored functions. 

This has been done by adding a new optional parameter of boolean type called isFunction to the CallableStatement.prepareCall:

any CallableStatement.prepareCall
    ( string  dbProfile , 
      string  sqlProc(?,?) , 
      boolean  captureSQLError  (optional) ,
      boolean isFunction (optional) )

Default value is false.

For further information, see 9.2 Callable Statements  in the APL Reference Guide.