SQL/MP Programming Manual for COBOL

Hewlett-Packard Company—529758-003
i
HP NonStop SQL/MP
Programming Manual for
COBOL
Index Examples Figures Tables
Legal Notices
What’s New in This Manual xi
Manual Information xi
New and Changed Information xi
About This Manual xiii
Who Should Read This Guide xiii
Related Manuals xiii
Notation Conventions xvi
HP Encourages Your Comments xix
1. Introduction
Advantages of Using Embedded SQL Statements 1-1
Development of a COBOL Program 1-2
Host Variables 1-2
SQL/MP Statements and Directives 1-2
SQL/MP System Procedures 1-4
Program Compilation and Execution 1-4
Error and Status Reporting
1-5
Dynamic SQL Operations
1-6
SQL/MP Version Management
1-7
COBOL in the Open System (OSS) Environment 1-7
Effect on Conformance to ISO/ANSI Standards 1-8
2. Host Variables
Specifying a Declare Section 2-1
Coding Host Variable Names 2-2
Using Corresponding SQL and COBOL Data Types
2-2
Specifying Host Variables in SQL Statements
2-6
Using the COBOL PICTURE Clause
2-7
Fixed-Length Character Data
2-7
Variable-Length Character Data 2-7