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

Contents

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004

7. Static Rowsets (continued)

Using Rowset Arrays in DML Statements 7-6

Selecting Rows Into Rowset Arrays 7-6

Selecting Rowsets With a Cursor 7-12

Inserting Rows From Rowset Arrays 7-14

Updating Rows by Using Rowset Arrays 7-17

Deleting Rows by Using Rowset Arrays 7-19

Specifying Size and Row ID for Rowset Arrays 7-20

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