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

Hewlett-Packard Company—523627-004
i
HP NonStop SQL/MX
Programming Manual for C and
COBOL
Index Examples Figures Tables
What’s New in This Manual xvii
Manual Information xvii
New and Changed Information xvii
About This Manual xix
Audience xix
Organization xix
Related Documentation xxi
Examples in This Manual xxiv
Notation Conventions xxiv
1. Introduction
Referencing Database Object Names 1-1
NonStop SQL/MX Release 2.x 1-1
NonStop SQL/MX Release 1.x 1-1
Embedding SQL Statements 1-2
Declaring and Using Host Variables 1-2
Declaring Host Variables 1-3
Using Host Variables 1-3
Using DML Statements to Manipulate Data
1-4
Declaring and Using Static SQL Cursors
1-5
Using Dynamic SQL 1-6
Using Descriptor Areas for Dynamic SQL 1-6
Using Dynamic SQL Cursors 1-7
Using DML Statements With Rowsets 1-7
Improving Performance by Using Rowsets 1-7
Declaring a Rowset 1-8
Using a Rowset in a Query 1-8