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]
factors filter 2nd 3rd formulas 2nd failures CF stored procedures controlling 2nd Family (DB2) code bases differences 2nd 3rd database structures directories optimizer prodcuts FAQs Internet FAQs (Frequently Asked Questions) far off pages FARINDREF column FAROFFPOSF column fast application development online TSO applications Fast Path databases FCT (File Control Table) FD(colon)OCA (Formatted Data( colon )Object Content Architecture) feasibility operating environments 2nd FENCED UDF characteristic FETCH FIRST n ROWS ONLY clause FETCH statement cursors FETCH statements host variables field names PREFIX field procedures data integrity FIELDPROC exit routine FIELDPROCs MQT fields SQLCA 2nd 3rd SQLDA. SQLTYPE values 2nd FIFO (first-in FIFO algorithm buffer pools File Control Table. file processing commands (CICS) File UDF text Filename UDF audio image video files DAD DSNDB07 flat. log active archiving output buffer size problem resolution synchronizing logs changed information, augmenting I/O, tuning 2nd 3rd 4th offloading 2nd statistics reports suspending tuning 2nd volumes SYSXLAT DSN1COPY utility unloaded flat DSNTIAUL utility filter factors 2nd 3rd 4th formulas 2nd filtering data WHERE clause finding mailing lists FindInstrument UDF audio FindTrackName UDF audio firing triggers 2nd 3rd first key cardinality (DB2 Catalog statistics) FIRST keyword scrollable cursors first normal form first-in first-time effect DB2 Catalog FIRSTKEYCARDF column five DRDA levels 2nd distributed requests distributed unit of work remote request remote unit of work user -assisted distribution fixed-list SELECT dynamic SQL 2nd 3rd flexibility listing parameter markers 2nd prepared statements SQLDA flag bytes flames Internet Flashcopy disaster recovery 2nd flat files embedded SQL, compared 2nd flexibility dynamic SQL stored procedures FLOAT data type FLOAT function floating point data loading unloading FLOOR function Foedero Technologies Inc. FOR FETCH ONLY clause cursors FOR READ ONLY clause cursors 2nd FOR UPDATE OF clause data integrity DECLARE CURSOR statement SELECT statements FORCE option MODE parameter foreign keys indexes Format UDF audio image text video Formatted Data(colon)Object Content Architecture. formatted reports creating 2nd forms QMF DBID/PSID/OBID queries SYSCOPY queries forms (Web pages) formulas filter factors 2nd fourth-generation languages (4GLs) fourth-generation languages. fragmentation 2nd data loss 2nd horizonatal vertical FREE command FREE LOCATOR statements Free Plan option DB2I free space increasing indexes 2nd table spaces calculating growth rate formula insert activity space search algorithm free spaces table spaces 2nd 3rd freeing packages DB2I plans DB2I FREEPAGE parameter DSN1COMP utility table spaces 2nd 3rd frequency reorganizations 2nd 3rd Frequently Asked Questions. FREQVAL parameter RUNSTATS utility full image copies incremental copies, balancing JCL listing MERGECOPY utility small table spaces FULL OUTER JOIN outer join full recovery JCL FULLCOPY parameter DSN1COMP utility FULLKEYCARDF column FUNCTION class privileges function tables FUNCTION_NAME column DSN_FUNCTION_TABLE table FUNCTION_TEXT column DSN_FUNCTION_TABLE table FUNCTION_TYPE column DSN_FUNCTION_TABLE table functionality SQL statements TSO functions built-in 2nd built-in. CAST data type equivalency UDFs casting UDTs 2nd COALESCE outer joins 2nd table expressions column 2nd AVG COUNT 2nd COUNT_BIG MAX MIN STDDEV SUM VARIANCE DRDA application requesters application server database server returns external MQSeries built-in 2nd 3rd 4th MQREAD MQREADALL MQREADALLCLOB MQREADCLOB MQRECEIVE MQRECEIVEALL MQRECEIVECLOB MQRECEIVECLOBALL MQSEND MULTIPLY_ALT overloading RAISE_ERROR 2nd resolution DSN FUNCTION TABLE 2nd 3rd 4th information 2nd 3rd UDFs, selecting scalar ABS ABSVAL ACOS ADD_MONTHS ASIN ATAN ATAN2 ATANH BLOB CCSID_ENCODING CEIL CEILING CHAR CLOB COALESCE CONCAT COS COSH DATE DAY DAYOFMONTH DAYOFWEEK DAYOFWEEK_ISO DAYS DBCLOB DEC DECIMAL DECRYPT_BIT DECRYPT_CHAR DECRYPT_DB DEGREES DIGITS DOUBLE ENCRYPT_TDES EXP FLOAT FLOOR GENERATE_UNIQUE GETHINT GETVARIABLE GRAPHIC GREATEST HEX HOUR IDENTITY_VAL_LOCAL IFNULL INSERT INT INTEGER JULIAN_DAY LAST_DAY LCASE LEAST LEFT LENGTH LN LOCATE LOG LOG10 LOWER LTRIM MAX MICROSECOND MIDNIGHT_SECONDS MIN MINUTE MOD MONTH MULTIPLY_ALT NEXT_DAY NULLIF POSSTR POWER QUARTER RADIANS RAND REAL REPEAT REPLACE RIGHT ROUND ROUND_TIMESTAMP ROWID RTRIM SECOND SIGN SIN SINH SMALLINT SPACE SQRT STRIP SUBSTR TAN TANH TIME TIMESTAMP TIMESTAMP_FORMAT TRANSLATE TRUNC TRUNC_TIMESTAMP TRUNCATE UCASE UPPER VALUE VARCHAR VARCHAR_FORMAT VARGRAPHIC WEEK WEEKL_ISO WHERE clauses sourced UDTs 2nd SQL column scalar system-defined user-defined SQLError() ODBC STOGROUP table 2nd TRANSLATE UPPER function, compared UPPER TRANSLATE function, comapred user-defined application programs names user-defined. XML publishing 2nd 3rd
|
| < Day Day Up > |