SQL Programming Manual for Pascal

NonStop SQL Version Issues
HP NonStop SQL Programming Manual for Pascal—528614-001
D-3
Summary of C30 Changes Incompatible With C10
Summary of C30 Changes Incompatible With
C10
Table D-2 summarizes the incompatible C30 feature changes that affect programs
running in a C10 and C30 mixed environment. This table lists the program operation
and the C10 program changes required for C30. These changes are described on
subsequent pages in this subsection.
Table D-1. Summary of New Columns in Version 2 Catalogs
COLUMNS Catalog Table
Catalog Table/Column Name Column Declaration Column Description
DATETIMESTARTFIELD SMALLINT Date-time starting field
DATETIMEENDFIELD SMALLINT Date-time ending field
DATETIMEQUALIFIER VARCHAR (28) Date-time/INTERVAL
field
UPSHIFT CHAR (1) Upshifted Y,N
HEADING CHAR (1) Heading Y,N
HEADINGTEXT VARCHAR (132) Heading text
FILES Catalog Table
Catalog Table/Column Name Column Declaration Column Description
AUDITCOMPRESS CHAR(1) Audit compression Y,N
Note. An object version and catalog version do not necessarily match the NonStop SQL
release version of the system on which the object and catalog reside. NonStop SQL C10
software can create only Version 1 objects and Version 1 catalogs. Version 1 objects and
catalogs, however, can reside on both NonStop SQL C10 and C30 systems. NonStop SQL
C30 software creates only Version 2 catalogs and creates either Version 1 or 2 objects
depending on the features used in the objects.