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]
valid data types listing of 2nd validating XML validation routines data integrity validation strategies validity denormalization testing VALIDPROC exit routine VALUE function value statistics gathering RUNSTATS utility value validation data cleansing 2nd values generated retrieving identity columns ROWID loading sequential online applications UDTs assigning 2nd VALUES statement triggers VARCHAR columns indexes LOBs, compared 2nd 3rd maximum size REORG utility VARCHAR data type promotability VARCHAR function VARCHAR_FORMAT function VARGRAPHIC columns LOBs, compared 2nd 3rd VARGRAPHIC data type promotability VARGRAPHIC function variable character columns 2nd compression compared customizing effectiveness 2nd variable columns indexes 2nd variable index keys customizing 2nd variables declarations LOBs 2nd host 2nd 3rd COBOL column data type changes DCLGEN, prefixing defining embedded SQL SELECT statements 2nd EXECUTE IMMEDIATE generating 2nd host structures 2nd initializing lists, simulating names null indicators 2nd 3rd 4th 5th 6th 7th REXX specifying UDTs 2nd without colons indicator LOB locators initializing names 2nd 3rd null indicator DCLGEN command null indicators 2nd 3rd 4th 5th 6th avoiding 2nd column null status host variable association nullable columns, referencing session 2nd DATA_SHARING_GROUP_NAME PACKAGE_NAME PACKAGE_SCHEMA PACKAGE_VERSION PLAN_NAME SECLABEL SYSTEM_ASCII_CCSID SYSTEM_EBCDIC_CCSID SYSTEM_NAME SYSTEM_UNICODE_CCSID user -created VERSION transition triggers 2nd 3rd VARIANCE function variances varying-list SELECT dynamic SQL 2nd 3rd 4th 5th listing minimal SQLDA SQLDA 2nd SQLTYPE values 2nd varying-list SELECT statemetns dynamic SQL VDWQT parameter buffer pools vendor tools CAF vendor tools guide vendors Ambeo Systems Aonix Ascential Software ASG Software Solutions BEZ Systems BMC Software Brio Technology Bunker Hill Business Objects, Inc. Candle Corporation CDB Software Inc. CHARONWARE Chicago-Soft Products Ltd. Cognos Inc. Computer Associates Compuware Corporation CoSORT Cross Access Corp. Crystal Decisions Data Junction DBE Software, Inc. Direct Computer Resources Embarcadero Technologies Foedero Technologies Inc. GoldenGate Software, Inc. Gupta Technologies, LLC HiT Software HLS Technologies, Inc. IBM IMSI Informatica Information Builders Inc. Infospace Infotel Corporation listing of 2nd 3rd 4th 5th 6th Magna Solutions ManTech Systems Solutions Micro Focus MicroStrategy, Inc. NEON Systems, Inc. NetManage, Inc. OuterBay Technologies Praxis International Princeton SOFTECH Prolifics Quest Software Relational Architects Inc. Responsive Systems Co. Sagent Technology, Inc. SAS Institute Inc. SEGUS Inc. Softbase Systems Inc. Starware Software Striva Corporation Sybase Corporation third-party Tone Software Corp. tools evaluating 2nd 3rd Treehouse Software verbs COBOL UNION UPDATE VERIFY parameter REPAIR LOCATE utility Version 4 (DB2) client/server features DB2 Catalog features DBA features performance features programming features Version 5 (DB2) DB2 Catalog features DBA features performance features programming features utility features Version 6 (DB2) database administration features dataset passwords DB2 Catalog features host variables performance features programming features REBUILD INDEX utility RECOVER INDEX utility 2nd SROD 2nd stored procedure registration 2nd Type 1 indexes 2nd Type 2 indexes utility features Version 7 (DB2) application development enhancements 2nd 3rd Precompiler Services row expressions rows fetched 2nd SAVEPOINTs 2nd scrollable cursors 2nd SPB 2nd SQL Assist business intelligence enhancements 2nd data management enhancements 2nd 3rd data sharing declared temporary tables 2nd deferred data set creation identity columns 2nd LOG SUSPEND command Unicode 2nd utilities 2nd 3rd DBA tools e-business enhancements 2nd migration utility packaging Version 8 (DB2) architecture 2nd DBAs 2nd 3rd log volumes multi-level security padded variable length indexes partitions 2nd Schema Evolution sequences 2nd migration 2nd 3rd programming 2nd 3rd CTEs Java recursion SQL system limits XML VERSION column PLAN TABLE version maintenance (packages) 2nd VERSION session variable versioning DB2 Internet application software indexes REBUILD INDEX utility online schema changes 2nd deactivating versions new versions packages 2nd 3rd precompiling versions automatic names explicit names VERSIONS parameter REPAIR utility vertical fragmentation VIEW class privileges VIEW DB2 object view listing navigational queries view materialization 2nd view merge VIEW_CREATOR column DSN_FUNCTION_TABLE table VIEW_NAME column DSN_FUNCTION_TABLE table viewing active objects LPLs multiple databases resource status restricted objects views 2nd 3rd access base table creating 2nd 3rd 4th 5th coding complexity, masking column data type changes column names columns, renmaing creating 2nd data derivation domain support 2nd 3rd materialization names non-updateable per base table columns, adding 2nd 3rd columns, deleting combined tables split tables 2nd restrictions sample 2nd 3rd security security, implementing 2nd synchronization rule 2nd table expressions, compared unloading updating WITH CHECK OPTION clause 2nd violations data integrity virtual storage . common areas private areas Visual Explain simple statements 2nd VOLCNT option TEMPLATE statement volumes DASD partitioned table spaces disk storage groups logs Version 8 storage groups VOLUMES option TEMPLATE statement VPSEQT parameter buffer pools 2nd 3rd 4th 5th 6th VPSIZE parameter buffer pools VSAM data sets closing table spaces 2nd 3rd deleting LOB table spaces 2nd non-partitioned objects 2nd pages 2nd partitioned objects 2nd RECOVER utility REORG utility user-defined storage groups 2nd 3rd VTAM online performance monitoring 2nd VTAM manager VTAM parameters distribution performance 2nd VTYPE parameter buffer pools
|
| < Day Day Up > |