SQL/MP Programming Manual for C
Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-9
N
Modifying data
DELETE statement 4-12, 4-23
UPDATE statement 4-10
Moving SQL files, effect on SQL
validity 8-2
Multirow operation
DELETE statement 4-13
SELECT statement 4-21
UPDATE statement 4-12
N
Names buffer
determining length 10-7
indicator parameters 10-18
using with parameter 10-14
Naming conventions for host variables 2-2
Native mode C compiler (NMC)
Guardian environment 6-10
SQL pragma 6-7
SQLMEM pragma 3-7, B-2
NEWPROCESS procedure B-5
NO INVALIDATE option, CREATE INDEX
statement 8-3
NOEXPLAIN option, SQL compiler 6-16
NOFORCE option, SQL compiler 6-16
NOOBJECT option, SQL compiler 6-16
NOPURGEUNTIL attribute, similarity check
rules 8-12
NORECOMPILE option, SQL
compiler 6-17
, 8-6
NOSQLMAP option, SQL pragma 6-7
Not found condition, WHENEVER
directive 9-6
NOWHENEVERLIST option, SQL
pragma 6-7
NOXMEM pragma B-2
NULL keyword
with INSERT statement 4-9
with UPDATE statement 4-12
NULL STRUCTURE clause with INVOKE
directive 2-23
Null terminator
C strings 2-7
host variables in arrays 2-7
Null value
definition 2-1
dynamic SQL 10-16, 10-27
input parameters 10-17
INSERT statement 2-17, 4-9
INVOKE directive 2-22
names buffer 10-18
output variables 10-17
parameters 10-17
retrieving rows 2-18
SELECT statement 2-17
testing 2-17
UPDATE statement 4-12
O
OBEY command file, format for EXPLAIN
report 6-16
OBEYFORM option
EXPLAIN report 6-27
SQL compiler 6-16
Object file
Accelerator 6-14
Binder program 6-11
C compiler 6-9
SQL compilation 6-12, 6-14
TACL RUN command 7-3
validation 8-1
OBJECT option, SQL compiler 6-16
Object, SQL
access authority for program
execution 7-1
changes and program file validity 8-3
with SQLGETOBJECTVERSION 5-19
OPEN procedure 10-36
OPEN statement 4-15, 4-19, 4-22, 4-24