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

Document ID : KB000054770
Last Modified Date : 14/02/2018
Show Technical Document Details

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.