SQL Programming Manual for Pascal

Contents
HP NonStop SQL Programming Manual for Pascal—528614-001
ii
3. NonStop SQL Statements and
Directives (continued)
3. NonStop SQL Statements and Directives (continued)
BEGIN DECLARE SECTION and END DECLARE SECTION 3-6
Example 3-6
INVOKE and SOURCE in the Declare Section 3-7
CLOSE 3-7
CONTROL Directives 3-8
Static SQL Statements 3-8
Dynamic SQL Statements 3-9
DECLARE CURSOR 3-9
Static SQL Cursors 3-9
Dynamic SQL Cursors 3-10
All Cursors 3-10
DELETE 3-11
DELETE and Access 3-11
Single-Row Delete Operation 3-11
Multirow Delete Operation Using a Single Statement 3-12
Multirow Delete Operation Using a Cursor 3-13
DELETE WHERE CURRENT and Static SQL Cursors 3-13
DELETE WHERE CURRENT and Dynamic SQL Cursors 3-14
DESCRIBE and DESCRIBE INPUT 3-14
EXECUTE 3-14
Examples 3-15
EXECUTE IMMEDIATE 3-16
Example 3-17
FETCH 3-17
Static SQL Cursor 3-17
Dynamic SQL Cursor 3-17
All Cursors 3-17
INCLUDE Directives 3-18
INSERT 3-18
INSERT and Access 3-19
Inserting a Scaled Value 3-19
Inserting a Null Value 3-19
Inserting Date-Time and INTERVAL Values 3-20
Inserting a Timestamp 3-21
INVOKE 3-22
INVOKE Guidelines 3-22
Handling Columns of Date-Time and INTERVAL Types 3-24
INVOKE and Indicator Variables 3-26