SQL/MP Version Management Guide

Contents
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
iii
5. Program Versions
Retrieving the Version of an Alternate Language Message File 4-3
5. Program Versions
SQL Program Creation 5-1
SQL Versions of Host Language Compiler and Host Object File
5-1
Host Language Compiler SQL Version
5-1
Host Object SQL Version (HOSV)
5-2
Retrieving the Host Language Compiler SQL Version
5-3
Retrieving the Host Object’s SQL Version
5-4
SQL Program Versions
5-5
Program Format Version (PFV)
5-5
Program Catalog Version (PCV)
5-6
Where SQL Program Versions Are Stored
5-7
Retrieving SQL Program Versions
5-9
SQL Data Structure Versions
5-12
SQL Data Structure Version Assignment
5-13
Relation of Data-Structure Version to Program Format Version
5-15
Mixing Data Structure Versions
5-15
6. Mixed Version Networks
Mixed Version Compatibility 6-1
Fallback Nodes in a Network
6-2
Newer Version Catalogs on Remote Nodes
6-3
SQL Programs in a Mixed Version Network
6-4
Partitioned Objects in a Mixed Version Network
6-5
DDL Operations in a Mixed Version Network
6-5
Version 2 and Newer Version Software
6-6
Version 2 Access to Newer Version Remote Catalogs
6-6
Using Version 2 Catalogs in a Network
6-7
Using Version 2 Software and SQL Programs
6-7
Using a Version 2 Message File
6-7
Version 1 and Newer Version Software
6-7
Version 300 or Newer SQL Utilities in a Mixed Version Network
6-8
SQL Utilities and Fallback Nodes
6-9