SQL/MP Programming Manual for COBOL

Index
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
Index-13
S
SQLMAP option, SQLCOMP command 9-2
SQLMEM, COBOL compiler directive 3-7,
B-4
SQLMSG file
description 5-2
file number 5-31, 5-36
with SQLCA_DISPLAY2_
procedure 5-36
SQLSA structure
FETCH statement 4-18
fields 9-23
guidelines 9-22
SQLSADISPLAY procedure
syntax 5-27
SQLSA-RESERVED, SQLSA structure
field 9-24
SQLVAR, SQLDA structure field 10-12
SQL, COBOL compiler directive 3-7, 6-7
SQL-ERROR, SQLCA structure field 9-14
SQL-STATEMENT-TYPE, SQLSA structure
field 9-24
SQL/MP directives
BEGIN DECLARE SECTION 1-2, 2-1
Declare Section 2-2
description 1-2, 3-3
END DECLARE SECTION 1-2, 2-1
INCLUDE SQLCA 9-12
INCLUDE STRUCTURES 9-1, D-1
INVOKE 2-13
SQL/MP optimizer 4-15
SQL/MP sample database A-1
SQL/MP statements
ADD CONSTRAINT 8-5
ALTER INDEX 8-5
ALTER TABLE 8-5
ALTER VIEW 8-5
CLOSE 4-23
CREATE COLLATION 11-1
DECLARE CURSOR 4-15
DELETE 4-10, 4-22
SQL/MP statements (continued)
description 1-2
, 3-3
DROP CONSTRAINT 8-5
DROP INDEX 8-5
DROP TABLE 8-5
DROP VIEW 8-5
FETCH 4-17
OPEN 4-16
placement 3-2
SELECT 4-4
UPDATE STATISTICS 6-35
SQL/MP system procedures
description 1-4, 5-1
SQLCAFSCODE 9-12
SQLCAGETINFOLIST 9-12
SQLCA_DISPLAY2_ 9-12
SQLCA_TOBUFFER2_ 9-12
SQLGETCATALOGVERSION 5-24
SQLGETOBJECTVERSION 5-25
SQLGETSYSTEMVERSION 5-26
SQL/MP version, similarity check 8-11
SRC-NAME-BUFFER, SQLCA structure
field 9-15
SRC-NAME-BUFFER-LEN, SQLCA
structure field 9-13
STABLE ACCESS option, cursor
declaration 4-14
Statements
embedding 3-1
format 3-1
Static SQL statements, COBOL
program 1-4
Statistics
SQL compilation 6-35
SQLCADISPLAY procedure 5-32
SQLCAGETINFOLIST procedure 5-17
SQLSA 9-21
SQLSADISPLAY procedure 5-27
updating with UPDATE
STATISTICS 6-35
STATS, SQLSA structure field 9-23