SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-4
Compiler Options
Compiler Options
The following version SQL compiler (SQLCOMP) options raise the catalog version
number of a compiled program to at least 310:
•
The COMPILE option directs the SQL compiler to perform similarity checks for
SQL objects during explicit SQL compilation to explicitly SQL compile only
statements with inoperable plans.
•
The CHECK option directs the SQL executor to perform similarity checks for SQL
objects at run time to automatically recompile only statements with inoperable
plans. The CHECK INOPERABLE PLANS option also prevents certain DDL
operations performed on SQL objects from invalidating SQL programs that
reference the objects.
•
The REGISTERONLY option directs the compiler to register a previously compiled
program in a catalog without recompiling it.
•
The NOREGISTER option directs the SQL compiler to compile a program without
registering the program in a catalog.
For a description of the compiler options, see the SQL/MP programming manual for
your particular programming language.
Features Used in Programs
Features used in an SQL program can affect the catalog version of the program when:
•
No features in a version 1 or version 2 SQL program affect the catalog version of the
program.
•
An explicit reference to a collation through the COLLATE clause in a static SQL
statement affects the SQL program’s catalog version. Using this feature causes the
version of the SQL program to become at least 300.
Table A-5. Version 350 Features
Feature Description
Table feature
Format 2 enabled tables. New value for
PARITIONARRAY clause, FORMAT2ENABLED.
New limits for EXTENT for Format 2 enabled
partitions.
Catalog manipulation
statements
Create a Version 350 catalog. Catalog tables remain
Format 1 tables themselves.
Table manipulation
statements
Allow creation of Format 2 enabled tables and indexes, and
Format 2 partitions.
PARTITION clause Allow creation of Format 2 partitions.
FORMAT clause Enable FORMAT 2 tables.