SQL/MX 3.2 Programming Manual for C and COBOL (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Programming Manual for C and COBOL—663854-002
vi
8. Name Resolution, Similarity Checks, and
Automatic Recompilation
Selecting From Rowset-Derived Tables 7-32
Selecting From Rowset-Derived Tables With a Cursor 7-35
Inserting Rows From Rowset-Derived Tables 7-37
Limiting the Size of a Rowset-Derived Table 7-38
Inserting Null 7-39
Updating Rows by Using Rowset-Derived Tables 7-40
Deleting Rows by Using Rowset-Derived Tables 7-42
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
SQL Item Descriptors 10-2