DB2 Developers Guide (5th Edition)
| < Day Day Up > |
| [SYMBOL] [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] [Z]
NACTIVE column INDEXSPACESTATS table TABLESPACESTATS table name columns views NAME column INDEXSPACESTATS table TABLESPACESTATS table names aliases automatic versions CF structures check constraints collections columns 2nd 3rd CTEs returning columnsLESS renaming compliance conventions 2nd data sharing data sharing conventions 2nd 3rd group -level member-level databases DBRMs 2nd DCLGEN declare members default program preparation distinct type explicit versions GROUP ATTACH host variables indexes 2nd 3rd LOB table spaces packages 2nd 3rd 4th plans 2nd 3rd 4th 5th programs 2nd 3rd qualified UDF referential constraints storage groups stored procedures synonyms table spaces tables 2nd auxiliary temporary templates three-part system-directed distribution 2nd triggers 2nd UDFs 2nd 3rd UDTs 2nd user -defined functions utility IDs variables 2nd 3rd views naming conventions aliases automatic versions characters check constraints collections columns 2nd compliance creating 2nd databases DBRMs DCLGEN declare members distinct type explicit versions indexes 2nd 3rd LOB table spaces objects packages plans 2nd referential constraints storage groups stored procedures synonyms table spaces tables auxiliary temporary triggers user-defined functions utility IDs views native data types (DB2) 2nd native SQL SQL only applications navigational queries 2nd 3rd 4th 5th 6th 7th 8th aliases, listing auxiliary tables check constraints IDENTITY columns indexes LOBs materialized query tables performance referential constraints 2nd SEQUENCE objects specific database information storage groups, listing synonyms, listing table compositions table rows temporary tables triggers 2nd UDTs, listing view listing NBRSECOND option TEMPLATE statement near off pages NEARINDREF column NEAROFFPOSF column negation logic subqueries NEON Systems, Inc. nested loop joins 2nd parallelism nesting SELECT statements 2nd 3rd stored procedures 2nd 3rd triggers 2nd Net Search Extenders 2nd NET tools Net.Data 2nd 3rd 4th client/server environment support connections direct requests Java applets/JavaScript macro language training process flow 2nd programming techniques security stored procedures user-friendly development NetManage, Inc. network specific authids network traffic DB2 Internet applications networks TCP/IP member routing News Readers newsgroups cross-posting mailing lists, compared tips Usenet 2nd DB2 resources 2nd 3rd NEXT keyword scrollable cursors NEXT VALUE FOR clause sequence objects NEXT_DAY function NLEVELS column INDEXSPACESTATS table NO ACTION option referential constraints NO COLLID parameter stored procedures No_of_Matches UDF text non-clustered index access non-correlated subqueries 2nd non-critical applications DSN1COPY recovery strategy non-DB2 data sets buffering non-DB2 resources accessing triggers non-leaf pages 2nd Type 1 indexes Type 2 indexes non-matching index scans 2nd non- padded indexes non-partitioned indexes non-partitioned objects VSAM data sets 2nd non-partitioned secondary indexes. non-partitioning indexes. non-relational data joining non-segmented table spaces space search algorithm non-SELECT dynamic SQL 2nd 3rd EXECUTE IMMEDIATE statements, compared parameter markers 2nd prepared statements rows, deleting syntax non-SELECT dynamic statements non-standard dates 2nd non-uniform data dynamic SQL non-updatable cursors non-updateable cursors non-updateable views nonleaf pages indexes nonsargable processing NONTERMREL parameter DB2CONN parameter nonuniform distribution statistics deleting 2nd normalization 2nd 3rd first normal form second normal form third normal form normalized tables NOSYSREC option REORG utility Not DETERMINISTIC parameter UDFs NOT EXISTS predicate NOT IN predicate NOT keyword avoiding NOT PADDED parameter NPIs 2nd NPIs (non-partitioning indexes) NPSI (non-partitioned secondary indexes) null indicator variables DCLGEN command null indicators 2nd 3rd 4th 5th 6th avoiding 2nd column null status host variable association nullable columns, referencing null input parameters UDFs nullable columns NULLIF function nulls avoiding nulls column functions columns/rows 2nd 3rd 4th database design equivalency IS NOT DISTINCT FROM comparison operator IS NULL predicate multiple indexes overview 2nd NumAudioTracks UDF audio video numbers sequential assignments NumChannels UDF audio video NumColors UDF image NumFrames UDF video NUMLKTS parameter NUMLKUS parameter NUMPARTS parameter table spaces NumVideoTracks UDF video
|
| < Day Day Up > |