SQL Programming Manual for TAL

Hewlett-Packard Company—527887-001
i
HP NonStop SQL Programming
Manual for TAL
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 xii
Related Manuals xii
Notation Conventions xv
1. Introduction
Why Use Embedded SQL Statements? 1-1
Developing a Program 1-2
Embedding SQL Statements 1-2
Declaring Host Variables 1-3
Calling SQL System Procedures 1-3
Using Static SQL Statements 1-4
Using Dynamic SQL Operations 1-5
Compiling and Executing a Program 1-7
2. Host Variables and Parameters
Host Variables 2-1
Declaring Host Variables 2-2
Using Corresponding SQL and TAL Data Types 2-2
Overriding Default Data Types 2-5
Using Host Variables 2-6
Using Indicator Variables for Null Values 2-17
Creating Host Variables With the INVOKE Directive 2-20
Parameters 2-23
Using a Parameter List 2-24
Using Parameters in Loops 2-25
Using Indicator Parameters 2-25
Using Default Parameter Data Types 2-26