SQL/MX Programming Manual for Java

Contents
HP NonStop SQL/MX Programming Manual for Java—523726-003
iv
4. SQL/MX Programming
Considerations (continued)
4. SQL/MX Programming Considerations (continued)
CONTROL Statements 4-6
ANSI Compliance and Portability 4-6
Static and Dynamic CONTROL Statements 4-6
Static CONTROL Statements 4-7
Dynamic CONTROL Statements 4-8
Placement of the CONTROL Statements 4-10
SET TABLE TIMEOUT Statement 4-11
ANSI Compliance and Portability 4-11
Scope of the SET TABLE TIMEOUT Statement 4-11
Placement of the SET TABLE TIMEOUT Statement 4-11
MODULE Directive 4-12
ANSI Compliance and Portability 4-12
Placement of the MODULE Directive 4-12
Connection Context of the MODULE Directive 4-13
Catalog and Schema of the Module Name 4-13
External Qualification of the Module Name 4-14
Delimited Identifiers in the Module Name 4-14
System-Defined Module Name 4-15
DECLARE and SET Statements for Object Name Qualification 4-16
ANSI Compliance and Portability 4-16
DECLARE Statements for Static SQL 4-16
SET Statements for Dynamic SQL 4-18
Precedence of Object Name Qualification 4-19
Name Resolution 4-20
Table and View Name References 4-20
Precedence of Object Name Qualification 4-22
Compile-Time Name Resolution for SQL/MP Objects 4-23
Late Name Resolution for SQL/MP Objects 4-23
Distributed Database Considerations 4-24
RDF Considerations 4-24
Similarity Checks and Automatic Recompilation 4-26
Similarity Check 4-26
Automatic Recompilation 4-29
Recommended Recompilation Settings for OLTP Programs 4-30