SQL/MP Version Management Guide

Contents
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
iv
7. Version Compatibility for SQL Programs
Version 300 or Newer Utilities and Newer Version Software 6-11
7. Version Compatibility for SQL Programs
When to Modify and Recompile Programs 7-1
SQL Statements That Cause Version Errors
7-1
RELEASE1 and RELEASE2 Options in Older Version Programs
7-2
Developing Version Independent SQL Programs
7-3
Version Independent Statements and Directives
7-3
Version Independence and Existing SQL Programs
7-3
Version Independent SQL Data Structures
7-4
SQL Compilation for Version Independence
7-7
Host Language Compilation for Version Independence
7-7
SQL Compilation in a Mixed Version Network
7-7
Reverting to an Older Version
7-8
Reverting to an Older Release
7-9
Migrating to a Newer Version
7-11
Using Parallel Execution Plans in a Mixed Version Network
7-14
SQL Execution in a Mixed Version Network
7-15
SQL Execution and Fallback Nodes
7-16
Execution Performance in Mixed Version Networks
7-17
Program Invalidation in Mixed Version Network
7-18
A. Summary of Feature, Catalog, and Data Structure Changes
Features Introduced by Different Versions A-1
Version 1 Features
A-1
Version 2 Features
A-1
Version 300 Features
A-2
Version 310 Features
A-3
Version 315 Features
A-3
Version 335 Features
A-3
Version 345 Features
A-3
Version 350 Features
A-3
Compiler Options
A-4
Features Used in Programs
A-4