SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-8
N
Names buffer (continued)
declaring for dynamic SQL 7-8
estimating size of 7-15
for dynamic SQL 7-23
using with a parameter 2-25
NAMES INTO clause
of DESCRIBE INPUT statement 7-23
NEWPROCESS system procedure 5-30
NO AUDITCOMPRESS attribute 4-20
NO INVALIDATE option, CREATE INDEX
statement 5-23
NOEXPLAIN option, SQL compiler 5-9
NOFORCE option, SQL compiler 5-8
NonStop SQL database
overview 1-1
sample of A-1
using embedded SQL for 1-1
NonStop SQL directives
BEGIN DECLARE SECTION 1-3
, 2-2
coding of 3-1
comments in 3-2
CONTROL EXECUTOR 3-8
CONTROL QUERY 3-8
CONTROL TABLE 3-8
END DECLARE SECTION 1-3, 2-2
INCLUDE SQLCA 3-19, 4-22, 6-9, 7-8
INCLUDE SQLDA 3-19, 6-14
INCLUDE SQLSA 3-19, 6-10, 7-8
INVOKE 2-8, 2-17, 2-20, 3-22, A-1
locating information about 3-4
placing in source file 3-2
table of 1-3, 3-4
WHENEVER 6-4
NonStop SQL statements
BEGIN WORK 7-13
CLOSE 3-7, 3-34
coding of 3-2
comments in 3-2
COMMIT WORK 7-14
CREATE INDEX 5-23
NonStop SQL statements (continued)
CREATE TABLE 2-20
, 7-2
DECLARE CURSOR 3-11
DELETE 3-13
DESCRIBE 3-16
DESCRIBE INPUT 3-16
DROP 3-17
dynamically preparing 3-30
EXECUTE 1-5, 3-18, 7-13
EXECUTE IMMEDIATE 1-5, 3-18
FETCH 3-18
INSERT 3-19, 3-26
locating information about 3-4
OPEN 3-29, 3-34
placing in source file 3-2
PREPARE 3-30, 7-10, 7-15
RELEASE 3-31
SELECT 2-15, 3-25, 3-31
table of 1-2, 3-4
UPDATE 3-42
UPDATE STATISTICS 5-11, 5-14,
5-23
, 5-29
WHENEVER 7-9
NonStop SQL system procedures
SQLCADISPLAY 1-3
, 2-4, 4-2, 6-9
SQLCAFSCODE 4-7, 6-9
SQLCAGETINFOLIST 4-8, 6-9
SQLCATOBUFFER 4-13, 6-9
SQLGETCATALOGVERSION 4-19,
D-11
SQLGETOBJECTVERSION 4-19, D-11
SQLGETSYSTEMVERSION 4-21,
D-11
SQLSADISPLAY 4-22
table of 4-1
NOOBJECT option, SQL compiler 5-9
NORECOMPILE option, SQL
compiler 5-10
, 5-24
NOSQLMAP option, SQL directive 3-37
Not found condition, WHENEVER 6-4