SQL/MP Version Management Guide
Index
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
Index-6
P
Object version (continued)
automatic upgrading 3-16
catalog version 3-11
changing 3-16
DDL operations 3-16
dependencies 3-15
description of 1-5
DROP COLLATION statement 3-17
DROP CONSTRAINT statement 3-17
DROP INDEX statement 3-17
DROP statement 3-17
DROP TABLE statement 3-17
DROP VIEW statement 3-17
file label 3-12
FILEINFO utility 3-14
GET VERSION statement 3-13
initializing 3-10/3-11
older version utilities 6-11
program catalog version 5-4
program format version 5-4
querying catalog 3-13
retrieving 3-13/3-15
SQL utilities 6-9
SQLGETOBJECTVERSION
procedure 3-14
storage 3-12/3-13
user catalog 3-12
Objects, old, in new catalogs 3-11
OBJECTVERSION column
INDEXES catalog table 3-13
INDEXES table 3-12
TABLES table 3-12
Older version software
description of 1-3
performance 7-17
reinstalling 1-7
utilities 6-11
OR connectors, query execution plans 7-13
OSSFILE column, version 315 A-8
P
Parallel execution
mixed version network 7-14
newer version software 7-12
older version software 7-17
PARTITIONARRAY column
FILES table A-8
TABLES table A-8
Partitions
mixed version network 6-5
object version dependency 3-16
PCV
See Program catalog version
Performance
newer version software 7-18
older version software 7-17
PFV
See Program format version
Preprocessor, COBOL85 5-1
, 5-4
Procedures
SQLCAGETINFOLIST 7-5
SQLGETCATALOGVERSION 3-8
SQLGETOBJECTVERSION 3-14
SQLGETSYSTEMVERSION 2-5, 7-4
Product version 2-1
Program catalog version (PCV)
catalog tables 5-8
catalog version 5-8
database versions 5-6
description of 1-5, 5-6
file label 5-9
FILEINFO utility 5-9, 5-10
GET VERSION OF PROGRAM
statement 5-4
object version 5-4
older version utilities 6-12
querying catalog 5-11
RESTORE utility 5-11