SQL/MX Programming Manual for C and COBOL (H06.10+, J06.03+)

Contents

HP NonStop SQL/MX Programming Manual for C and COBOL—544617-003

7. Static Rowsets (continued)

Limiting the Size of the Input Rowset 7-22

Limiting the Size of the Input Rowset When Declaring a Cursor 7-23

Limiting the Size of the Output Rowset 7-24

Using the Index Identifier 7-25

Specifying Rowset-Derived Tables 7-28

Using Rowset-Derived Tables in DML Statements 7-29

Selecting From Rowset-Derived Tables 7-29

Selecting From Rowset-Derived Tables With a Cursor 7-32

Inserting Rows From Rowset-Derived Tables 7-34

Limiting the Size of a Rowset-Derived Table 7-35

Inserting Null 7-36

Updating Rows by Using Rowset-Derived Tables 7-37

Deleting Rows by Using Rowset-Derived Tables 7-39

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-7

RDF Considerations 8-7

Similarity Checks and Automatic Recompilation 8-8

Similarity Check 8-8

Automatic Recompilation 8-12

Recommended Recompilation Settings for OLTP Programs 8-13

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