SQL/MX 3.2.1 Programming Manual for C and COBOL (H06.26+, J06.15+)

Hewlett-Packard Company—663854-005
i
HP NonStop SQL/MX Release
3.2.1 Programming Manual for C
and COBOL
Index Examples Figures Tables
Legal Notices
What’s New in This Manual xv
Manual Information xv
New and Changed Information xv
About This Manual xix
Audience xix
Organization xix
Related Documentation xx
Examples in This Manual xxiii
Notation Conventions xxiii
Change Bar Notation xxvi
HP Encourages Your Comments xxvi
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