STOPROC

On entering a stored procedure, converts character data on DB2 LUW stored procedure parameters to CHARSET(EBCDIC), and converts it back to CHARSET(ASCII) on exiting the stored procedure.

Syntax:

[NO]STOPROC

Properties:

Default:

NOSTOPROC

Limitations:

STOPROC is limited to single-byte character parameters and is intended for use only when the routine cannot be called directly from a COBOL application. We do not recommend using STOPROC in cases where the routine can be called directly from a COBOL application.

Comments:

STOPROC enables DB2 LUW stored procedures to be compiled with CHARSET(EBCDIC) and remain accessible to non-EBCDIC enabled languages such as C# or JAVA. In addition, this directive replaces all parameters defined as COMP variables with COMP format on entry, and with COMP-5 format on exit.