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

NAME field,

syntax, sqls, 1-433

with DESCRIBE, sqls, 1-342

Named row data type, sqlr, Glossary-12

updating fields, sqls, 1-803

Named row type, sqlr, 2-56 to , sqls, 1-875, sqlt, 10-5 to

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

dropping, sqlt, 10-12

dropping with DROP ROW TYPE, sqls, 1-372

example, sqlt, 10-5

inheritance, sqls, 1-200

naming conventions, sqlt, 10-7

restrictions on, sqlt, 10-7

unloading, sqls, 1-771, 1-775

when to use, sqlt, 10-6

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

Natural join, sqlt, 2-69

Navigation,

actions, vis_ug, 9-4

creating, vis_ug, 8-3 to

features, vis_ug, 1-4, 1-7

NCHAR data type, instll32, 29, 30, sqls, 1-863, sqlt, 9-21

collation order, sqlr, 2-57, sqlt, 2-24

loading, sqls, 1-520

multibyte characters, sqlr, 2-57

querying on, sqlt, 2-10

syntax, sqls, 1-862

syscolumns coltype code for, sqlr, 1-24

with relational operators, sqls, 1-1020

negate() operator function, sqls, 1-960

Negator function, sqlr, Glossary-12

Nested,

collection, sqlt, 10-19

Nested ordering, in SELECT, sqls, 1-637

Network environment variable,

DBPATH, sqlr, 3-31

Network parameters, instll32, 30

NLS environment,

character attributes, instll32, 30

collation sequence, instll32, 29

database locale, instll32, 29

date and time formatting, instll32, 30

enabling, instll32, 28

monetary formatting, instll32, 30

numeric formatting, instll32, 30

regular expression searches, instll32, 30

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

Non-variant function, sqlr, Glossary-13

Noncursor,

function, sqlr, Glossary-12

noncursor procedure, sqlr, Glossary-13

Nondecomposable attributes, sqlt, 8-17

Nonprintable characters,

with CHAR data type, sqlr, 2-37

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. 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() operator function, sqls, 1-1020

NULL comparator, sqls, 1-845

NULL relational operator, sqlt, 2-34

Null value, sqlr, Glossary-13, sqlt, 9-33

allowed or not allowed, sqlr, 1-25

AND and OR operators with, sqls, 1-854

BETWEEN operator with, sqls, 1-842

checking for in SELECT, sqls, 1-387, 1-392

detecting in ESQL, sqlt, 5-16

GET DESCRIPTOR with, sqls, 1-438

IN operator results with, sqls, 1-844

in SPL IF statement, sqls, 2-36

inserting, sqlt, 4-8

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

syscolumns coltype code for, sqlr, 1-24

testing for, sqls, 1-623, 1-845, 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

NULLABLE field,

with DESCRIBE, sqls, 1-342

Number data type,

literal, sqls, 1-1002

syntax, sqls, 1-1002

Numbers, formatting in property expressions, vis_ug, 7-12

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

NVARCHAR data type, instll32, 29, 30, sqlr, 2-58, sqls, 1-863

collation order, sqlr, 2-58, sqlt, 2-24

length (syscolumns), sqlr, 1-28

loading, sqls, 1-520

multibyte characters, sqlr, 2-58

querying on, sqlt, 2-10

syntax, sqls, 1-862

syscolumns coltype code for, sqlr, 1-24

with relational operators, sqls, 1-1020