SQL/MX 3.2.1 Programming Manual for C and COBOL (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Programming Manual for C and COBOL—663854-005
vi
8. Name Resolution, Similarity Checks, and
Automatic Recompilation
Using Rowset-Derived Tables in DML Statements 7-33
Selecting From Rowset-Derived Tables 7-33
Selecting From Rowset-Derived Tables With a Cursor 7-36
Inserting Rows From Rowset-Derived Tables 7-38
Limiting the Size of a Rowset-Derived Table 7-39
Inserting Null 7-40
Updating Rows by Using Rowset-Derived Tables 7-41
Deleting Rows by Using Rowset-Derived Tables 7-43
8. Name Resolution, Similarity Checks, and Automatic
Recompilation
Name Resolution 8-1
Table and View Name References 8-1
Precedence of Object Name Qualification 8-5
Compile-Time Name Resolution for SQL/MP Objects 8-6
Late Name Resolution 8-6
Distributed Database Considerations 8-8
RDF Considerations 8-8
Similarity Checks and Automatic Recompilation 8-9
Similarity Check 8-9
Automatic Recompilation 8-18
Recommended Recompilation Settings for OLTP Programs 8-19
9. Dynamic SQL
Statements for Dynamic SQL With Arguments 9-2
Input Parameters and Output Variables
9-2
Floating-Point Variables 9-2
Steps for Using Dynamic SQL With Argument Lists
9-3
Declare a Host Variable for the Dynamic SQL Statement 9-4
Move the Statement Into the Host Variable
9-5
Prepare the SQL Statement 9-5
Set Explicit Input Values
9-6
Execute the Prepared Statement
9-6
Deallocate the Prepared Statement 9-7
Using EXECUTE IMMEDIATE
9-7
Setting Default Values Dynamically
9-8
10. Dynamic SQL With Descriptor Areas
Statements for Dynamic SQL With Descriptors 10-1
SQL Descriptor Areas 10-2