SQL Programming Manual for TAL

NonStop SQL Version Issues

HP NonStop SQL Programming Manual for TAL—527887-001

D-3

Summary of Incompatible Changes

Table D-4 on page D-4 summarizes the NonStop SQL release C30 features that are

incompatible with NonStop SQL release C10. These features can affect programs

running in a mixed-version environment and C10 programs that are migrated to a C30

system. These features are described on subsequent pages in this section.

Table D-3. Summary of New Columns in Version 2 Catalogs

Catalog Table/Column

Name Column Declaration Column Description

COLUMNS Catalog Table

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

AUDITCOMPRESS CHAR(1) Audit compression Y,N

Note. Object version and catalog version do not necessarily match the NonStop SQL release

version of the system where they reside. NonStop SQL C10 software can only create 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.