SQL Programming Manual for Pascal

Contents
HP NonStop SQL Programming Manual for Pascal—528614-001
iii
3. NonStop SQL Statements and
Directives (continued)
3. NonStop SQL Statements and Directives (continued)
INVOKE and Null Values 3-26
INVOKE With the NULL STRUCTURE Clause 3-27
INVOKE With the PREFIX and SUFFIX Clauses 3-28
OPEN 3-28
Static SQL Cursors 3-28
Dynamic SQL Cursors 3-28
All Cursors 3-29
PREPARE 3-29
RELEASE 3-29
SELECT 3-29
Single-Row SELECT 3-30
Multirow SELECT 3-32
SELECT Syntax Consideration for IN EXCLUSIVE MODE and IN SHARE
MODE 3-34
SQL 3-35
UPDATE 3-36
UPDATE and Locks 3-37
UPDATE and Access 3-37
UPDATE WHERE CURRENT With Static SQL Cursors 3-37
UPDATE WHERE CURRENT With Dynamic SQL Cursors 3-37
UPDATE and Error Processing 3-37
Single-Row Update Operation 3-38
Multirow Update Operation Using a Single Statement 3-39
Multirow Update Operation Using a Cursor 3-40
Updating Columns With Null Values 3-42
WHENEVER 3-42
4. NonStop SQL System Procedures
Procedure Descriptions 4-2
SQLCADISPLAY 4-2
SQLCAFSCODE 4-7
SQLCAGETINFOLIST 4-8
SQLCATOBUFFER 4-14
SQLGETCATALOGVERSION 4-19
SQLGETOBJECTVERSION 4-19
SQLGETSYSTEMVERSION 4-21
SQLSADISPLAY 4-22