SQL Programming Manual for TAL

HP NonStop SQL Programming Manual for TAL—527887-001
xi
About This Manual
This manual describes the programmatic interface to NonStop SQL for the Transaction
Application Language (TAL). 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 TAL programmers who are coding embedded SQL
statements in a TAL program. A reader should be familiar with:
•
TAL
•
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 TAL programmatic interface to NonStop SQL.
Section 2
Describes how to declare and use host variables and parameters in a TAL
program.
Section 3
Describes the statements and directives that have unique TAL
considerations, data structures, or examples.
Section 4
Describes the SQL system library procedures and shows how to call them
from a TAL program.
Section 5
Describes how to compile and execute a TAL program that contains
embedded SQL statements.
Section 6
Describes how to process error and status messages and statistics
information using the SQLCODE variable and the SQLCA, SQLDA, and
SQLSA data structures.
Section 7
Describes how to use dynamic SQL operations.
Appendix A
Describes the sample NonStop SQL database that is used by the
programming examples.
Appendix B
Includes two programming examples that use static SQL operations.
Appendix C
Includes two programming examples that use dynamic SQL operations.
Appendix D
Describes version issues for NonStop SQL release C10 and release C30
software.
Appendix E
Describes how to use constraints and to check for referential integrity.