Master Index
Home Index Key

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Symbols ]

N

Condition,
IS, sqls, 1-845
-N processor option, esqlc, 1-55
NAME descriptor field, esqlc, 16-21, 16-6, 15-8
NAME field,
syntax, sqls, 1-433
with DESCRIBE, sqls, 1-342
Name space, shared by DataBlade module objects, udr, 3-5
Named row,
retrieving individual values from, dapi, 12-496
Named row data type, sqlr, Glossary-12
updating fields, sqls, 1-803
Named row data types, dbdkug, 3-41
Named row type, sqlr, 2-56 to , sqls, 1-875, sqlt, 10-5 to , extend, 1-15, 3-4, 1-8
after a DESCRIBE, esqlc, 17-8
assigning with ALTER TABLE, sqls, 1-86
casting, sqlt, 13-5
casting permitted, sqlr, 2-32
column of, sqlt, 10-10
constraints in table containing, sqls, 1-202
creating a typed table with, sqlt, 10-8
creating with CREATE ROW TYPE, sqls, 1-197
declaring host variable for, esqlc, 9-53
dropping, sqlt, 10-12
dropping with DROP ROW TYPE, sqls, 1-372
example, sqlt, 10-5
in a collection-derived table, esqlc, 9-54
in typed table, esqlc, 9-72
inheritance, sqls, 1-200
inserting into, esqlc, 9-71
literal values, esqlc, 9-75
naming conventions, sqlt, 10-7
restrictions on, sqlt, 10-7
See also Row type (SQL); Unnamed row type.,
unloading, sqls, 1-771, 1-775
updating, esqlc, 9-71
when to use, sqlt, 10-6
Named row variable, esqlc, 9-53
typed, esqlc, 9-53
untyped, esqlc, 9-53
named rows,
retrieving individual values from, dapi, 12-498
Names of ActiveX properties, dbdkug, 6-11
Naming convention,
constraint, sqls, 1-856
database, sqls, 1-858
index, sqls, 1-986
synonym, sqls, 1-1048
table, sqls, 1-1050
view, sqls, 1-1053
Naming routines, dbdkug, 2-23
National currency format, gls_api, 4-73, 3-6, 4-37
Native Language Support (NLS),
code-set conversion with, gls, 1-45
collation order, gls, 1-12
establishing a connection, gls, 1-34
information in systables, gls, 1-26
precedence of environment variables, gls, 1-37, 1-40, 1-25
reverting to, gls, 5-10
single-byte data, gls, 1-4
Natural join, sqlt, 2-69
NCHAR data type, sqls, 1-863, sqlt, 9-21
code-set conversion, gls, 1-48, 4-7
collation order, sqlr, 2-57, sqlt, 2-24, gls, 3-12, 1-11
corresponding ESQL/C data type, esqlc, 3-3, 2-4, 2-12
defined constant, esqlc, 2-8
description of, gls, 3-11
difference from CHAR, gls, 3-12
fetching, esqlc, 3-12
in ESQL/C program, gls, 8-6
in regular expressions, gls, 1-5
inserting into database, gls, 8-6
loading, sqls, 1-520
multibyte characters, sqlr, 2-57, gls, 3-12
nonprintable characters, gls, 3-13
performance considerations, gls, 3-16
querying on, sqlt, 2-10
See Character; Character string.,
sizing, gls, 3-12
syntax, sqls, 1-862
syscolumns coltype code for, sqlr, 1-24
transfering with host variables, esqlc, 3-11
with numeric values, gls, 3-13
with relational operators, sqls, 1-1020
Negate method/routine, dbdkug, 6-18, 7-9
negate() function, extend, 2-5
negate() operator function, sqls, 1-960
Negative sign, gls_api, 3-5, 3-6
Negator function, sqlr, Glossary-12, dbdkug, 3-30
Nested,
collection, sqlt, 10-19
Nested ordering, in SELECT, sqls, 1-637
Network environment variable,
DBPATH, sqlr, 3-31
Network parameter,
ASKPASSATCONNECT, esqlc, 1-108, 12-14, 12-15
HOST, esqlc, 1-107, 12-14
INFORMIXSERVER, esqlc, 1-105, 12-14
OPTIONS, esqlc, 1-108
PASSWORD, esqlc, 1-107, 12-14
precedence, esqlc, 1-112
PROTOCOL, esqlc, 1-108, 12-15
SERVICE, esqlc, 1-108, 12-15
setting with InetLogin, esqlc, 1-111
USER, esqlc, 1-107, 12-14
New object prefix, dbdkug, 3-9
new operator, dbdkug, 6-34
New-line character, gls_api, 4-64, 4-55, 2-12
Newline character,
See also Vertical white space.,
-nln preprocessor option, esqlc, 1-53, 1-65, 1-58
NLS. See Native Language Support (NLS).,
Node, sqlr, Glossary-12
NODEFDAC environment variable, sqls, 1-221, 1-129, 1-185
description of, sqlr, 3-56
effects on new routine, sqls, 1-129, 1-185
GRANT statement with, sqls, 1-474, 1-469
NODFDAC,
effect on privileges granted to public, sqlt, 14-76, udr, 3-19
Non-ASCII character,
definition of, gls, 1-8
examples, gls, 1-30
filtering, gls, 8-8
in cast names, gls, 4-17
in column names, gls, 1-5, 1-6, 3-5, 7-6
in comments, gls, 2-5, 7-6
in connection names, gls, 3-5
in constraint names, gls, 3-5, 7-6
in cursor names, gls, 1-5, 1-6, 3-5, 7-6
in database names, gls, 3-6, 6-4, 7-6
in delimited identifiers, gls, 3-10
in distinct-type names, gls, 4-18, 4-17
in ESQL filenames, gls, 7-4
in ESQL/C source files, gls, 7-6
in ESQL/COBOL source files, gls, 7-6
in filenames, gls, 3-6, 2-23, 7-7
in host variables, gls, 1-6, 3-6, 8-4, 7-6
in index names, gls, 3-6, 6-4
in indicator variables, gls, 1-6, 7-6
in INFORMIX-Universal Server filenames, gls, 4-4
in literal strings, gls, 2-5, 7-7
in LOAD FROM file, gls, 3-52
in OnLine filenames, gls, 5-4, 2-25
in opaque-type names, gls, 4-17
in operator-class names, gls, 4-18
in owner names, gls, 3-8
in quoted strings, gls, 3-33
in role names, gls, 3-6
in row-type names, gls, 4-18
in SE filenames, gls, 6-4, 2-25
in SQL comments, gls, 3-34
in statement IDs, gls, 1-5, 1-6, 3-6, 7-6
in stored procedures, gls, 1-5, 1-6, 3-6, 3-7
in synonym names, gls, 3-7
in table names, gls, 1-5, 1-6, 6-4, 3-7, 7-6
in triggers, gls, 3-7
in UNLOAD TO file, gls, 3-52
in view names, gls, 1-5, 1-6, 3-7, 7-6
processing, gls, 2-5, 8-8
See also Multibyte character.,
support for, gls, 1-31
with CC8BITLEVEL, gls, 2-5
with GLS8BITFSYS, gls, 2-23
Non-default compilation of ESQL/C programs,
options for, esqlc, 1-68
Non-default order of compilation,
for all ESQL/C files, esqlc, 1-68
Non-Gregorian calendar, gls, 1-16
Non-parameterized non-SELECT statements, esqlc, 14-40
Non-parameterized SELECT statements, esqlc, 14-43, 16-13, 15-24, 17-17
Non-SELECT statements,
definition of, esqlc, 14-40
known at compile time, esqlc, 14-40, 14-41
nonparameterized, esqlc, 14-40
not known at compile time, esqlc, 15-26
parameterized, esqlc, 17-43, 14-52, 16-46, 15-26
preparing, esqlc, 14-41
with sqlda structure, esqlc, 17-43
with system-descriptor area, esqlc, 16-46
Non-variant function, sqlr, Glossary-13
Noncursor,
function, sqlr, Glossary-12
Noncursor function,
definition of, esqlc, 14-48
known at compile time, esqlc, 14-49
not known at compile time, esqlc, 16-23, 17-28
parameterized, esqlc, 14-52
with sqlda structure, esqlc, 17-28
with system-descriptor area, esqlc, 16-23
noncursor procedure, sqlr, Glossary-13
Nondecomposable attributes, sqlt, 8-17
Nonprintable characters,
with CHAR data type, sqlr, 2-37
Nonvariant functions, dbdkug, 3-27
nonyielding class, dbdkug, 4-9
Nonyielding user-defined virtual processor class, dbdkug, 4-7
Normal form, sqlt, 8-31
Normalization,
benefits, sqlt, 8-31
first normal form, sqlt, 8-32
of data model, sqlt, 8-31
rules, sqlt, 8-31
rules, summary, sqlt, 8-35
second normal form, sqlt, 8-33
third normal form, sqlt, 8-34
NOT FOUND condition,
definition of, esqlc, 11-5
using SQLCODE, esqlc, 11-35
using SQLSTATE, esqlc, 11-20
using the WHENEVER statement, esqlc, 11-45
Not found condition. See End of data.,
NOT logical operator, sqls, 1-837
Not null constraint, sqlr, Glossary-13, 1-23
NOT NULL keywords,
use in CREATE TABLE, sqlt, 9-40
NOT relational operator, sqlt, 2-31
NOT VARIANT routine modifier, sqls, 1-1031
NotEqual method/routine, dbdkug, 7-10, 6-18
notequal() function, extend, 2-6
notequal() operator function, sqls, 1-1020
-nowarn preprocessor option, esqlc, 1-75, 1-53, 1-66, 1-58
-np preprocessor option, esqlc, 1-50
Null character, gls_api, 2-6, 2-37
NULL comparator, sqls, 1-845
NULL constant, dapi, 3-52, 1-8, 3-76, 3-34
NULL relational operator, sqlt, 2-34
Null terminator, gls_api, 4-72, 4-62, 2-6, 4-54, 2-41, 4-78
Null value, sqlr, Glossary-13, sqlt, 9-33
allowed or not allowed, sqlr, 1-25
AND and OR operators with, sqls, 1-854
argument for an overloaded routine, udr, 2-16
BETWEEN operator with, sqls, 1-842
checking for in SELECT, sqls, 1-387, 1-392
detecting in ESQL, sqlt, 5-16
determining in dynamic SQL, esqlc, 17-30, 15-8
for simple large-object values, esqlc, 8-30, 8-25, 8-18
for simple-large-object values, esqlc, 8-9
GET DESCRIPTOR with, sqls, 1-438
ifx_var_isnull(), esqlc, 10-41
ifx_var_setnull(), esqlc, 10-29, 10-46
in aggregate function, esqlc, 11-31, 11-15
in host variables, esqlc, 1-35
IN operator results with, sqls, 1-844
in SPL IF statement, sqls, 2-36
inserting, sqlt, 4-8
inserting code for check for, esqlc, 1-63
inserting into table, esqlc, 1-43
inserting with the VALUES clause, sqls, 1-507
LIKE and MATCHES results with, sqls, 1-845
loading, sqls, 1-518
NOT operator with, sqls, 1-837
restrictions in primary key, sqlt, 8-25
returned implicitly, sqls, 2-51
returned in indicator, esqlc, 1-43
risnull(), esqlc, 2-24, 1-36
rsetnull(), esqlc, 2-27, 1-36
See also Indicator variable.,
setting to, esqlc, 2-27, 10-29, 10-22, 10-46, 10-13, 1-36
syscolumns coltype code for, sqlr, 1-24
testing for, sqls, 1-623, 1-845, esqlc, 10-41, 10-31, 1-42, 10-23, 2-24, 10-14, 1-36, sqlt, 2-34
testing in BYTE expression, sqlr, 2-35
TEXT data type and, sqlr, 2-65
unloading, sqls, 1-771
updating a column, sqls, 1-788
used in the ORDER BY clause, sqls, 1-637
WHILE statement with, sqls, 2-61
with SET DESCRIPTOR, sqls, 1-710
Null-terminated string, gls_api, 2-38
NULLABLE descriptor field, esqlc, 16-21, 16-6, 15-8
NULLABLE field,
with DESCRIBE, sqls, 1-342
Number data type,
literal, sqls, 1-1002
syntax, sqls, 1-1002
Number of arguments in routines, dbdkug, 2-24
Number string, gls_api, 3-4
Numeric data,
base-4 representation, gls_api, 4-43, 4-79
binary representation, gls_api, 4-42, 4-79
converting, gls_api, 4-40
currency notation in, gls, 7-18
decimal separator, gls_api, 3-5, gls, 1-19, A-7, 7-19, 1-14
definition of, gls_api, 3-4, 3-5
end-user format, gls, 1-39, 1-19, A-7, 1-14
ESQL functions, gls, 7-17
field width, gls_api, 4-81, 4-43
floating-point representation, gls_api, 4-42, 4-79
format of, gls, A-7
format string, gls_api, 4-41, 4-78
formatting, gls_api, 4-77
formatting and conversion functions, gls_api, 4-10
formatting directives for, gls_api, 4-42, 4-79
grouping information, gls_api, 3-5
hexadecimal representation, gls_api, 4-43, 4-79
locale category for, gls_api, 3-4
locale-specific, gls, 1-6
locale-specific formats, gls_api, 3-4
negative, gls, 1-15, 1-19, A-7
negative sign, gls_api, 3-5
octal representation, gls_api, 4-42, 4-79
positive, gls, 1-15, 1-19, A-7
positive sign, gls_api, 3-5
precision, gls_api, 4-81
See also Data.,
SQL data types for, gls_api, 3-4
thousands separator, gls_api, 3-5, gls, 1-15, 1-19, A-7, 7-19
unsigned decimal representation, gls_api, 4-43, 4-79
Numeric data type, sqls, 1-864 to
casting between, sqlr, 2-26
casting to characters, sqlr, 2-27
list of, sqlr, 2-9
See also DECIMAL;DOUBLE PRECISION; FLOAT; INTEGER; INT8; MONEY; NUMERIC; REAL; SERIAL; SERIAL8; SMALLINT; SMALL FLOAT data types.,
NUMERIC data type. See DECIMAL data type.,
Numeric data types, sqlt, 9-9 to
Numeric expressions,
example formats, esqlc, 5-31
formatting, esqlc, 5-30
rfmtdec() function, esqlc, 5-37
rfmtdouble() function, esqlc, 5-41
rfmtlong() function, esqlc, 5-44
valid characters, esqlc, 5-30
NUMERIC locale category,
alternative digits, gls, 2-38, A-7, 2-31
description of, gls, A-4, A-7
end-user formats, gls, 1-15, A-7
in client locale, gls, 1-24
in default locale, gls, A-5
in locale source file, gls, A-12
in server-processing locale, gls, 1-40
numeric-formatting functions, gls, 7-19
NUMERIC locale category. See LC_NUMERIC locale-file category.,
Numeric notation, gls, 1-15
Numeric-fill character. See Fill character.,
-nup preprocessor option, esqlc, 1-50
NVARCHAR data type, sqlr, 2-58, sqls, 1-863
code-set conversion, gls, 1-48, 4-7
collation order, sqlr, 2-58, sqlt, 2-24, gls, 1-11, 3-14
corresponding ESQL/C data type, esqlc, 3-3, 2-4, 3-4, 3-5, 2-12
data conversion, esqlc, 3-12
defined constant, esqlc, 2-8
description of, gls, 3-13
difference from VARCHAR, gls, 3-14
fetching, esqlc, 3-15
in ESQL/C program, gls, 8-6
in regular expressions, gls, 1-5
inserting into database, gls, 8-6
length (syscolumns), sqlr, 1-28
loading, sqls, 1-520
multibyte characters, sqlr, 2-58, gls, 3-15
nonprintable characters, gls, 3-15
performance considerations, gls, 3-16
querying on, sqlt, 2-10
See Character; Character string.,
sizing, gls, 3-14
syntax, sqls, 1-862
syscolumns coltype code for, sqlr, 1-24
transfering with host variables, esqlc, 3-11
with relational operators, sqls, 1-1020


Copyright © 1997, Informix Software, Inc. All rights reserved.