How to resolve error "CMINIT14-F Invalid value for Environment option, Primary SQL"?

Products

• Datacom
• DATACOM - AD
• Ideal
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Description

Compiling a program under CA Ideal 11.0 fails with error "CMINIT14-F Invalid value for Environment option, Primary SQL".

Solution

There have been changes made to the compiler under CA Ideal 11.0. This change is documented in the CA Ideal for CA Datacom Release Summary Guide.

Basically, In the Environment section a program, the "Primary SQL database" defaults to DB2. Under CA Ideal 2.2, if a site does not have the Ideal/DB2 option, the compile would abend (prior to Ideal APAR QO45502) if the procedure contained embedded SQL code. APAR QO45502 was sourced for CA Ideal r11, requiring the Environment section to specify a supported database, even when the program did not contain embedded SQL code.

The default value for "Primary SQL database" can be changed from DB2 to DB with the Ideal command SET SITE ENV SQL DB . This site option will only affect programs that do not currently have an Environment section. For programs that already have an Environment section, they will have to be updated with the correct database value to avoid a compiler error.

Environment

Release:
Component: IDEAL