SQL/MP Installation and Management Guide

Contents

HP NonStop SQL/MP Installation and Management Guide—523353-004

vii

10. Managing Database Applications

Program Validity 10-1

Operations That Invalidate a Program 10-1

Unexpected Events That Can Invalidate a Program 10-2

Operations That Do Not Invalidate a Program 10-3

Determining Validity of a Program 10-4

SQL Compilation and Recompilation 10-6

Explicit Compilation 10-6

Automatic Recompilation 10-7

Deferring Name Resolution 10-13

CONTROL QUERY BIND NAMES Directive 10-14

Avoiding Automatic SQL Recompilations 10-14

Using Similarity Checks 10-15

Using the CHECK Option 10-15

Using the COMPILE Option 10-23

Enabling the Similarity Check for Tables and Protection Views 10-26

Planning for TS/MP Requirements 10-29

Planning for Pathmaker Requirements 10-29

Using DEFINEs 10-30

Entering DEFINE Commands 10-30

DEFINE Rules 10-30

Using DEFINEs During Compilation 10-32

Using DEFINE Names With Programs 10-32

Using DEFINEs From SQLCI 10-34

Using DEFINEs to Switch Databases 10-35

Using DEFINEs With PATHMON 10-37

Manipulating Program Files 10-38

Moving Programs 10-39

Moving Programs Without Recompilation 10-40

Using BACKUP and RESTORE 10-42

Using SQLCI DUP 10-44

11. Performing Recovery Operations

Restoring Individual SQL Objects 11-2

Restoring Catalogs 11-2

Restoring Collations 11-2

Restoring Tables 11-2

Restoring Views 11-6

Restoring Indexes 11-6