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

Hewlett-Packard Company—663854-002
i
HP NonStop SQL/MX Release
3.2 Programming Manual for C
and COBOL
Index Examples Figures Tables
Legal Notices
What’s New in This Manual xvii
Manual Information
xvii
New and Changed Information
xvii
About This Manual xxi
Audience xxi
Organization xxi
Related Documentation xxii
Examples in This Manual xxv
Notation Conventions xxv
Change Bar Notation xxviii
HP Encourages Your Comments xxviii
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
Embedding SQL Statements in DLL 1-2
Declaring and Using Host Variables
1-3
Declaring Host Variables
1-3
Using Host Variables
1-4
Using DML Statements to Manipulate Data 1-4
Declaring and Using Static SQL Cursors
1-5
Using Dynamic SQL
1-7
Using Descriptor Areas for Dynamic SQL 1-7
Using Dynamic SQL Cursors 1-8
Using DML Statements With Rowsets
1-8
Improving Performance by Using Rowsets
1-8
Declaring a Rowset 1-9
Using a Rowset in a Query 1-9