SQL Programming Manual for Pascal

HP NonStop SQL Programming Manual for Pascal—528614-001
xi
About This Manual
This manual describes:
•
The programmatic interface to NonStop SQL for Pascal
•
How to embed SQL statements and directives in a Pascal program
•
How to call the SQL system library procedures
The NonStop SQL relational database management system (RDBMS) uses the
structured query language (SQL) to define and manipulate data in NonStop SQL
databases.
NonStop SQL provides both a conversational and a programmatic interface. Using the
programmatic interface, a C, COBOL85, Pascal, or TAL programmer can use
embedded SQL statements to access a NonStop SQL database.
Audience
This manual is intended for Pascal programmers who are coding embedded SQL
statements in a Pascal program. You should be familiar with:
•
The Pascal programming language
•
NonStop SQL terms and concepts (as described in the Introduction to NonStop
SQL)
•
The HP NonStop Kernel operating system
Organization
Section 1 Provides an overview of the programmatic interface to NonStop SQL.
Section 2
Describes the declaration and use of host variables and parameters in a
Pascal program.
Section 3
Describes the SQL statements and directives that have unique Pascal
considerations, data structures, or examples.
Section 4
Describes the SQL system library procedures and shows how to call them
from a Pascal program.
Section 5
Describes the compilation and execution of a Pascal program that contains
embedded SQL statements.
Section 6
Describes the processing of error and status messages and statistics
information using the SQLCODE variable and the SQLCA, SQLDA, and
SQLSA control blocks.
Section 7
Describes the use of dynamic SQL operations in a Pascal program. It
includes two Pascal programs that use dynamic SQL operations.