SQL Programming Manual for Pascal

Hewlett-Packard Company—528614-001
i
HP NonStop SQL Programming
Manual for Pascal
Index Figures Tables
What’s New in This Manual ix
Manual Information ix
New and Changed Information ix
About This Manual xi
Audience xi
Organization xi
Related Manuals xii
Notation Conventions xiii
1. Introduction
Benefits of Using Embedded SQL 1-1
Developing a Program With Embedded SQL 1-1
Embedding SQL Statements 1-2
Declaring Host Variables 1-3
Calling SQL System Procedures 1-3
Using Static SQL Statements 1-3
Using Dynamic SQL 1-4
Compiling and Executing a Program 1-5
2. Host Variables and Parameters
Host Variables 2-1
Declaring Host Variables 2-1
Using Host Variables 2-6
Parameters 2-12
Using Parameters in Loops 2-13
Using Indicator Parameters 2-13
3. NonStop SQL Statements and Directives
Embedding SQL Statements and Directives 3-1
Coding Statements and Directives 3-1
Placing Statements and Directives in a Program 3-2
Locating Information About SQL Statements and Directives 3-3