Previous Topic: CREATE TRIGGER StatementNext Topic: CXX Upgrade


SQL COBOL Preprocessor

The SQL COBOL Preprocessor now puts the translated SQL statements in SRCOUT. The translated statements were formerly put in SYSPCH. Modify your existing JCL to take this change into account.

SQL COBOL Precompiler

The SQL COBOL Precompiler DBXMMPR now writes the translated statements to SRCOUT and not to IJSYSPH as was the case with Version 11.0.

SQL Additional Memory Requirement

With Version 12.0, the CA Datacom Multi-User Facility (MUF) requires a minimum recommended partition size of 16M for systems with the SQL option enabled. The partition size requirement may be slightly larger for sites with large buffer pool allocations.

As a rule of thumb, a CA Datacom MUF running the SQL Option requires an additional 300K per task as defined in the "number" option of the TASKS Multi-User Startup Option. Failure to provide adequate memory can lead to the following abend error message:

CEE3322C EXECUTION ABNORMALLY TERMINATED WITH USER-ABEND CODE 4093

VSAM Transparency

The following change is for CA Datacom VSAM Transparency users running against a CA Datacom/DB Version 12 environment.

CODE CSP=NO in Online VSAM Interface Table (VIT)

To use VSAM Transparency to access tables that are defined in a CA Datacom/DB V12 environment, code the CSP=NO parameter in the Online VSAM Interface Table. If the parameter is not coded, CSP=NO is the default.

Note: For more information, see the CA Datacom VSAM Transparency Guide.