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

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
xix
About This Manual
This manual describes the NonStop SQL/MX programmatic interface for the ANSI C
and COBOL languages. It also includes some C++ language constructs. With this
interface, an application can access a database by using embedded SQL statements.
Throughout this manual, references to NonStop SQL/MX Release 2.x indicate SQL/MX
Release 2.0, 2.1, and subsequent releases until otherwise indicated in a replacement
publication.
Audience
This manual is intended for application programmers who are embedding SQL/MX
statements in a C, C++, or COBOL application. The reader should be familiar with
SQL/MX terms and concepts and the American National Standards Institute (ANSI)
database language SQL:1999.
•
ANSI C and C++: C programmers should write to the ANSI standard for code
portability. C programmers can use some, but not all, C++ language constructs in
embedded SQL applications.
•
ANSI COBOL85: COBOL programmers should write to the ANSI COBOL85
standard for code portability.
Organization
Section 1, Introduction Introduces the SQL/MX programmatic interface
for applications written in ANSI C/C++ or
COBOL.
Section 2, Embedded SQL Statements
Describes conventions and guidelines for
embedding SQL statements in an application.
Section 3, Host Variables in C/C++
Programs
Describes how to declare and use host
variables in a C/C++ application.
Section 4, Host Variables in COBOL
Programs
Describes how to declare and use host
variables in a COBOL application.
Section 5, Simple and Compound
Statements
Describes how to access data in the database
by using simple DML statements.
Section 6, Static SQL Cursors
Describes how to access data in the database
by using static SQL cursors.
Section 7, Static Rowsets
Describes how to use rowsets to retrieve
multiple rows from the database into the
application for processing and for transferring
multiple rows of values from the application to
the database.