Getting Started › Procedures and Triggers › Restrictions

Restrictions

Following is a partial list of functions that are not supported. If a feature, API, or other item does not appear on this list, its absence does not imply support for it. CA reserves the right to add items to this list or change or delete them at any time.

• Non-SQL requests (record-at-a-time, set-at-a-time, or other) are forbidden inside procedures.
• Procedures cannot contain COMMIT or ROLLBACK statements.
• Requests that trigger execution of any CA Datacom Transparency product are forbidden inside procedures.
• Procedures cannot issue INSERT, UPDATE, or DELETE statements against any CA Datacom DL1 Transparency-constrained table.
• COBOL, PL/I, and C procedures must be made Language Environment (LE) conforming by being written and compiled using the Language Environment. In z/OS, support for procedures and triggers requires a minimum of z/OS Version 2 Release 5 and compatible Language Environment for z/OS with the following IBM compiler products: z/OS C/C++ (only the C subset is supported), COBOL for z/OS, and PL/I for MVS. Assembler procedures must also be made LE-conforming by use of the CEEENTRY and associated macros. A z/VSE operating system is required, along with IBM Language Environment for z/VSE and compatible compilers.
• The depth of nesting of recursive procedure execution, whether procedures are triggered or called explicitly, is limited. See CALL/EXECUTE PROCEDURE for more information.