SQL/MP Version Management Guide

Index
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
Index-7
Q
Program format version (PFV)
BACKUP utility 6-10
catalog tables 5-8
catalog version 5-8
data structure version 5-15
database versions 5-5
description of 1-5, 5-5
file label 5-9
FILEINFO utility 5-9, 5-10
GET VERSION OF PROGRAM
statement 5-4
object version 5-4
querying catalog 5-11
RESTORE utility 5-11, 6-10
Program invalidation
mixed version network 7-16
, 7-18
Program versions
data structure versions 5-15
description of 1-5, 5-5
mixed version network 6-4
RESTORE utility 5-11
rules for relationships 5-5
SQL utilities 6-9
storage 5-7/5-9
VERIFY utility 5-9
version 1 software in mixed version
network 6-7
version 2 software in mixed version
network 6-6
PROGRAMCATALOGVERSION column,
PROGRAMS table 5-8, 5-9, 5-11
PROGRAMFORMATVERSION column,
PROGRAMS table 5-8, 5-9, 5-11
PROGRAMS table 5-8/5-11
Programs, creating 5-1
PURGE utility 6-11
Q
Queries, catalog
See Catalog queries
Query execution plans
CAST AS function 7-12
collating sequence 7-12
exponentiation 7-13
hash joins 7-12
MCSS character type 7-12
newer versions 7-12/7-14
OR connectors 7-13
SQL recompilation 7-12
unsigned decimal numbers 7-13
R
Recompilation
description of 7-11
query execution plans 7-12, 7-17
version compatibility 7-10
Release
categories 2-1
numbers 2-1/2-2
relationship to versions 2-1
support for previous 1-1
updates 2-3
RELEASE option, version
compatibility 7-4
RELEASE1 option 7-2
RELEASE2 option 7-2
Remote catalogs
access 1-2
newer version software 6-11
version 2 software 6-6, 6-7
Remote nodes, newer version catalogs 6-3
Remote objects, newer version
software 6-11
Remote programs, newer version
software 6-11
RESTORE utility
AUTOCREATECATALOG option 3-4
,
6-10
catalog version 6-10
collation version 6-12