index_E

[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]

e-business enhancemens
        DB2 Version 7 2nd
edit procedures
        data integrity
editing
        ROWID columns
EDITPROC clause
        compression routines
EDITPROC exit routine
EDM Pool
EDM Pool (Environmental Descriptor Management Pool)
EDM pools
        data sharing
       monitoring
                statistics reports
        prepared statements, caching
        size 2nd 3rd
        tuning 2nd 3rd 4th 5th
                authorization cache
                average package size query
                average plan size query
                column average per table query
                concurrent package query
                concurrent plans query
                DSNZPARMs
                EDM pool size 2nd 3rd
                package authorization caching query
                plan authorization caching query
                storage areas
                storage, moving
                table average per database query
EDT tools 2nd
education
        support 2nd
                industry periodicals 2nd 3rd 4th
                mailing lists
education (DB2)
        advanced topics
        external training
        in-house training
        introductory courses
        on-site library
        reference material
effectiveness
        variable character columns 2nd
efficient performance
        online TSO applications
efficieny
        TSO
EJBs (Enterprise Java Beans)
Embarcadero Technologies
embedded SQL
        4GL applications
        application programs 2nd 3rd
                comments
                DB2 tables, declaring
                delimiting statements
                error codes
                error trapping statement 2nd
                error-handling paragraph 2nd 3rd
                flat files, compared 2nd
                GETDIAGNOSTICS statement 2nd 3rd 4th 5th
                names 2nd 3rd
                SQLCA 2nd 3rd
                SQLCODE statement 2nd
                types
        existence checking 2nd
        ODBC applications
        overhead, reducing
        pretesting
       SELECT statements
                host variables 2nd
EMENDATE column
emoticons
        Internet
employee assignment table
employee photo & resume table 2nd
employee table 2nd
empty tables
        rows, adding
EMSTDATE column
ENABLE parameters
        BIND statements 2nd
ENABLE QUERY OPTIMIZATION parameter
enabling
        environments
encoding schemes
        table spaces 2nd
        tables
        unloaded data
ENCRYPT_TDES function
encrypting
        passwords
encryption
        DB2 data 2nd
        userids/passwords
END command
ENDBR command
        CICS file processing
Enterprise Edition (DB2 Connect) 2nd
        multi-users
        thread pooling 2nd
Enterprise Java Beans.
entity integrity
entries
       COMD
                CICS
        indexes 2nd
ENTRY macro parameters
        RCT 2nd 3rd 4th
                AUTH
                DPMODE
                PLAN
                PLNEXIT
                PLNPGME
                ROLBE
                TASKREQ
                THRDM
                THRDS
                TOKENE
                TWAIT
                TXID
entry threads
        CICS
entry- sequenced data sets.
environment commands
        administrative commands 2nd 3rd 4th
                active traces
                ALTER BUFFERPOOL
                ALTER UTILITY
                ARCHIVE LOG 2nd
                RECOVER INDOUBT
                START DATABASE 2nd
                START PROCEDURE
                START RLIMIT
                START TRACE 2nd
                START/STOP
                STOP
                STOP DATABASE
                system parameters
                TERM UTILITY 2nd
        information-gathering 2nd
                active objects, viewing
                buffer pools, monitoring
                buffer pools, tuning
                centralized areas
                database information, viewing
                database usage
                grouping buffer pools
                information, limiting
                LIMIT parameter
                LIST/LSTATS parameters
                locking information, viewing
                logging, monitoring
                LPLs, viewing
                objects, monitoring 2nd 3rd 4th
                OVERVIEW parameter
                restricted objects
                stored procedures, monitoring
                UDF statistics, monitoring
                utilities, monitoring 2nd
                wildcards
        issuing with DB2I 2nd
        structure
environment control commands 2nd
        security
Environmental Descriptor Management Pool.
environmental support (DB2)
environments
       client/server
                Net.Data support
        disaster recovery 2nd
        enabling/disabling
        operating.
        processing
       technical
                CASE tools support
       teleprocessing
                tuning 2nd 3rd
       three- tier
                Net.Data support
        TSO 2nd
                batch applications 2nd 3rd
                online applications 2nd 3rd 4th 5th 6th 7th 8th
       two-tier
                Net.Data support
        z/OS.
equality
       expressions
                testing
equivalent data types 2nd
equivalent functionality features (SQL)
ERASE parameter
        table spaces
Eric Loriaux MVS Web site
ERR parameter
        SSMs
ERRDEST RCT INIT macro parameter
error handling
        DSNTEP2 utility
        DSNTIAD
error resolution
        REPAIR DBD utility
error-handling
        error codes
        error trapping statement 2nd
error-handling paragraph
        application programs 2nd 3rd
errors
        BIND statements
        DSN1PRNT utility
escalating
        locks 2nd 3rd
                DSNZPARM parameter
                LOCKMAX parameter
ESDS (entry-sequenced data sets)
ESE (UDB Enterprise Server Edition)
ESMT parameter
        SSMs
‰SQL ‰ UDF characteristic
Estimator (DB2)
        table space space requirements
ETL tools 2nd
events
       trigger
                selecting
exception states
        online schema changes
exception tables
        defining
exceptions
        reporting
EXCEPTIONS parameter
        CHECK LOB utility
EXCLUDE clause
        LISTDEF statement 2nd
EXCLUDING COLUMN DEFAULTS parameter
EXEC SQL control statement 2nd 3rd 4th
        cursor-driven SELECT statements
        issuing 2nd
        non-SELECT dynamic statements
EXECUTE IMMEDIATE statement 2nd
        host variables
        one-time processing
        syntax
EXECUTE IMMEDIATE statements
        non-SELECT dynamic SQL, compared
executing
        external actions (UDFs)
        packages
        RUNSTATS utility 2nd 3rd
        SQL stored procedures
        stored procedures 2nd 3rd 4th
                calls 2nd
                WLM 2nd
        UDFs 2nd 3rd 4th
execution
       DDL
                planning
execution types
        SQL statements
existence
        SQL statements
        testing 2nd
existence, checking 2nd
existential SQL
exit routines 2nd
        EDITPROC
        FIELDPROC
        VALIDPROC
EXP function
expanding
        database object lists 2nd
                indexes
                LIST keyword 2nd
                LOBs 2nd
                referential integrity
EXPDL option
        TEMPLATE statement
EXPLAIN command
        auto rebinds
        simple statements 2nd
EXPLAIN feature
        cost estimations
        customizations, identifying
        DSN FUNCTION TABLE 2nd
                columns
                creating
                RUNSTATS
                version 8
        DSN STATEMENT TABLE 2nd
                columns 2nd 3rd
                creating
                RUNSTATS
                version 8
        historical information, recording
        optimizer, influencing
        overview 2nd
       PLAN TABLE
                access path efficiency
                access path examples
                columns 2nd 3rd 4th 5th 6th
                compressing
                indexes
                missing pieces 2nd
                QBLOCK TYPE column
                querying 2nd
                REMARKS column
                rows, deleting
                RUNSTATS
                version 7
                version 8
        PLAN TABLE access paths, populating 2nd 3rd
        PLAN TABLE, populating
        production packages
        production plans, binding
        SQL statement performance analysis 2nd 3rd
        statistics
        tools
        training
explain report sets
EXPLAIN TIME column
        DSN STATEMENT TABLE
EXPLAIN_TIME column
        DSN_FUNCTION_TABLE table
explicit consistency tokens
        BIND statements
explicit inner joins
explicit outer
explicit versions
        names
EXPORT commands
        QMF
Express (DB2)
expression
        arithmetic 2nd 3rd
                column renaming
                columns 2nd
                decimal precision/scale
                MULTIPLY_ALT
                two numbers
expressions
        averages
        CASE 2nd 3rd
                rows, counting
        equality, testing
        largest values, returning
        LOBs
        row 2nd
        smallest values, returning
        sum
       table
                multiple table data retrieval
        table.
expressions (rows)
        Version 7 enhancements
extended storage
extenders
        Net Search 2nd
        security 2nd
       UDFs
                audio extender created 2nd
                image extender created 2nd
                text extender created
                video extender created 2nd
        UDTs 2nd
        WLM requirements
        XML 2nd
                UDFs 2nd
Extensible Markup Language.
EXTENTS column
        INDEXSPACESTATS table
        TABLESPACESTATS table
external actions
        executing (UDFs)
external functions
EXTERNAL NAME UDF characteristic
external savepoints
        batch programs 2nd
external security 2nd
external stored procedures
        SQL stored procedures, compared
external training (DB2)
external UDFs
        program restrictions 2nd
externalizing
        RTS 2nd
extract/transformation/load tools 2nd
extractChar UDFs
extractCLOB UDFs
extractDate UDFs
extractDouble UDFs
extracting
       data
                4GL applications
extractInteger UDFs
extractReal UDFs
extractSmallint UDFs
extractTime UDFs
extractTimestamp UDFs
extractVarchar UDFs
extranets