HP NonStop SQL/MP - Page 327

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-15
S
SQLSA structure (continued)
dynamic SQL statement statistics 9-13
fields 9-14, 9-17
INCLUDE SQLSA directive 9-13
SQLSADISPLAY procedure 5-20
static SQL statement statistics 9-13
SQLSADISPLAY procedure 5-20
SQL/MP database
overview 1-1
sample A-1
version management 1-7
SQL/MP directives
BEGIN DECLARE SECTION 1-2, 2-1
coding 3-1
description 1-3
END DECLARE SECTION 1-2, 2-1
INCLUDE SQLCA 5-4, 9-12
INCLUDE SQLDA 10-3, 10-24
INCLUDE SQLSA 9-13, 10-24
INCLUDE STRUCTURES 9-1, D-1
INVOKE 2-19
placing in source file 3-2
WHENEVER 9-6, 10-23
SQL/MP statements
ADD CONSTRAINT, program
invalidation 8-5
ALTER INDEX
error 8204 4-3
program invalidation 8-5
ALTER TABLE
error 8204 4-3
program invalidation 8-4
similarity check 8-13
ALTER VIEW 4-3
BEGIN WORK 10-27
coding guidelines 3-1
coding in source file 3-2
COMMIT WORK 10-28
CREATE CONSTRAINT 4-3
SQL/MP statements (continued)
CREATE INDEX
NO INVALIDATE option 8-3
program invalidation 8-5
DECLARE CURSOR 4-18
DELETE 4-12, 4-23
description 1-3
DROP CONSTRAINT
error 8204 4-3
program invalidation 8-5
DROP INDEX
error 8204 4-3
DROP INDEX, program
invalidation 8-5
DROP TABLE
error 8204 4-3
program invalidation 8-5
DROP VIEW
error 8204 4-3
program invalidation 8-5
EXECUTE 1-6
EXECUTE IMMEDIATE 1-6
FETCH 10-12
FREE RESOURCES 4-2, 4-24
GET VERSION 6-37, 7-7
INSERT 4-8
OPEN 4-19
placing in source file 3-2
PREPARE 10-25
RENAME 8-3
SELECT 4-4
UPDATE 4-10
UPDATE STATISTICS
error 8204 4-3
execution plans 6-21
local autonomy C-2
program invalidation 8-3, 8-5