Symbols | 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

Index: D

• $data_source argument: Data Source Names
• • Connection
  • DBI Class Methods
• $dbh database handle: Database Handles
• $dbh variable: DBI Class Methods
• $DBI::err variable: Error Diagnostics
• • DBI Dynamic Attributes
• $DBI::errstr variable: Error Diagnostics
• • DBI Dynamic Attributes
• $DBI::rows variable ) (see rows()
• $DBI::state variable: Error Diagnostics
• • Standard Error Codes
  • DBI Dynamic Attributes
• $drh driver handle: Driver Handles
• data
• • compression: Compression
  • deleting: Query Languages and Data Functions
  • • Deleting Data
    • Executing Non-SELECT Statements
    • • delimited-field files: Deleting Data
      • • fixed-length record files: Deleting Data
  • encryption: Ciphers
  • fetching: Query Languages and Data Functions
  • • • using DBI: Fetching Data
      • • fetchrow_array(): Fetching Data
        • • fetchrow_arrayref(): Fetching Data
          • • fetchrow_hashref(): Fetching Data
            • • finishing early: Finishing a Data Fetch Early
              • • piece-by-piece: Handling LONG/LOB Data
                • • printing and: quick way to fetch and print
                  • • selectall_arrayref(): Batch Fetching
                    • • Database Handle Methods
                    • • selectcol_arrayref(): Database Handle Methods
                      • • selectrow_array(): Atomic Fetching
                        • • Database Handle Methods
                        • • selectrow_arrayref(): Atomic Fetching
  • inserting: Query Languages and Data Functions
  • • Inserting Data
    • Executing Non-SELECT Statements
    • • delimited-field files: Inserting Data
      • • fixed-length record files: Inserting Data
        • • using quote(): Database-Specific Quote Handling
  • long values, truncating: Common Attributes
  • marshalling modules
  • • • Data::Dumper: Basic Non-DBI Databases
      • • The Perl Data::Dumper Module
      • • Storable: Basic Non-DBI Databases
        • • The Storable Module
  • modifying within tables: Modifying Data Within Tables
  • • • committing changes: Committing and Rolling Back Modifications
      • • Automatic Transaction Handling
      • • deleting data: Deleting Data
        • • inserting data: Inserting Data
          • • undoing changes: Committing and Rolling Back Modifications
            • • Rolling Back Changes
            • • updating data: Updating Data
  • querying: Querying Data
  • • • delimited-field files: Querying Data
      • • fixed-length record files: Querying Data
        • • from multiple tables: Queries over Multiple Tables
          • • from single tables: Queries and Condition Clauses
            • • using SQL: Querying Data
  • rolling back: Transactions, Locking, and Isolation
  • selecting: Query Languages and Data Functions
  • • Querying Data
  • serializing: Putting Complex Data into Flat Files
  • • The MLDBM Module
  • storing (see data, inserting)
  • trailing blanks, removing: Common Attributes
  • truncating long values: Common Attributes
  • • Handling LONG/LOB Data
  • updating: Query Languages and Data Functions
  • • Updating Data
    • Executing Non-SELECT Statements
    • • delimited-field files: Updating Data
      • • fixed-length record files: Updating Data
• data source names: Data Source Names
• • available_drivers(): Data Source Names
  • connect() and: Data Source Names
  • • Connecting with Attributes
  • data_sources(): Data Source Names
  • name=value pairs: Data Source Names
• data structures, storing complex: The MLDBM Module
• data warehousing: From Mainframes to Workstations
• • The Relational Database Methodology
  • Modifying Data Within Tables
• database drivers
• • connection syntax examples
  • • • CSV: Data Source Names
      • • mSQL: Data Source Names
        • • Oracle: Data Source Names
  • DBI: DBI Architecture
  • • Acquiring the DBI and Drivers
  • prefixes: Data Source Names
  • • The Significance of Case
    • Naming Conventions and Name Space
  • standard: Data Source Names
• database handles: Database Handles
• • atomic fetching and: Atomic Fetching
  • attributes: Database Handle Attributes
  • • • connecting with: Connecting with Attributes
      • • driver-specific: Handle Attributes and Metadata
        • • The Significance of Case
        • • error checking: Common Attributes
          • • getting or setting values: Handle Attributes and Metadata
            • • passing to DBI methods: Passing Attributes to DBI Methods
  • $dbh: Database Handles
  • retrieving entity metadata: Database Metadata
• database-independent developing interfaces: From Mainframes to Workstations
• • ODBC and the DBI
• database metadata: Database Metadata
• databases
• • accessing using proxying: Database Proxying
  • basic attributes: Basic Non-DBI Databases
  • Berkeley (see Berkeley databases)
  • committing changes: Transactions, Locking, and Isolation
  • concurrent access to: Concurrent Database Access and Locking
  • connecting to: Connection
  • • • requirements: Connection
      • • with dbish: Starting Up dbish
  • creating new tables: Creating and Destroying Tables
  • cursors: Fetching Data
  • deleting tables: Creating and Destroying Tables
  • • Creating and Destroying Tables
  • disconnecting from: Disconnection
  • • Disconnecting, One Way or Another
  • evolution from mainframes to workstations: From Mainframes to Workstations
  • executing SQL statements: Executing Select Statements
  • extracting table information, example: Statement Handle Attributes or Statement Metadata
  • fetching data: Issuing Simple Queries
  • • • using DBI: Fetching Data
  • file locking: Concurrent Database Access and Locking
  • flat-file (see flat-file databases)
  • generating dynamic views: Database Metadata
  • locking
  • • • Berkeley databases: Locking Strategies
      • • flat-file databases: Concurrent Database Access and Locking
  • preparing SQL statements: Preparing SQL Statements
  • proxying: Database Proxying
  • queries, issuing simple: Issuing Simple Queries
  • query languages (see query languages)
  • quoting and escaping SQL statements: Database-Specific Quote Handling
  • relational: The Relational Database Methodology
  • result sets: Fetching Data
  • retrieving entity metadata: Database Metadata
  • rolling back changes: Transactions, Locking, and Isolation
  • schemas: The Relational Database Methodology
  • • Database Metadata
  • storage managers and layers: Storage Managers and Layers
  • system catalogs: Database Metadata
• Data::Dumper module: Basic Non-DBI Databases
• • The Perl Data::Dumper Module
  • displaying restored data: The MLDBM Module
• DataHash(): Win32::ODBC
• data_sources(): DBI Class Methods
• • available_drivers() and: Data Source Names
  • driver handles and: Driver Handles
• datatypes: Datatypes and NULL Values
• • binary large object: Datatypes and NULL Values
  • • Common Attributes
  • bind values and: Bind Values and Data Typing
  • character: Datatypes and NULL Values
  • date: Datatypes and NULL Values
  • LOB (large object): Handling LONG/LOB Data
  • LONG: Common Attributes
  • • Handling LONG/LOB Data
  • numeric: Datatypes and NULL Values
• date datatype: Datatypes and NULL Values
• DB2 (see DBD\\DB2 driver)
• db database manager: DBM Files and the BerkeleyDatabase Manager
• DB_BTREE storage format: Creating a New Database
• • Chaining multiple values into a hash
• DBD::ADO driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
• DBD::CSV driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • driver-specific attributes: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
• DBD::DB2 driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::Empress driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::EmpressNet driver (see DBD\\Empress driver)
• DBD::Informix driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • stored procedures: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::Ingres driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • driver-specific attributes: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::InterBase driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::mSQL driver (see DBD\\mysql driver)
• DBD::mysql driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • driver-specific attributes and methods: Driver and Database Characteristics
  • locking: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
• DBD::ODBC driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
• DBD::ODBC module
• • vs. Win32::ODBC: DBD::ODBC
• DBD::Oracle driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • driver-specific methods: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • stored procedures: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::Pg driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • driver-specific attributes: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::Proxy module: The Database Proxy Architecture
• • Connecting to the proxy server
  • DBI Class Methods
• DBDs (see database drivers)
• DBD::SearchServer driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • locking: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
• DBD::Sybase driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • driver-specific attributes and methods: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • stored procedures: Driver and Database Characteristics
  • transactions: Driver and Database Characteristics
• DBD::XBase driver: Driver and Database Characteristics
• • connect syntax: Driver and Database Characteristics
  • datatypes: Driver and Database Characteristics
  • parameter binding: Driver and Database Characteristics
  • SQL dialect: Driver and Database Characteristics
  • table metadata: Driver and Database Characteristics
• DB_File module: DBM Files and the BerkeleyDatabase Manager
• • The MLDBM Module
  • default values: Creating a New Database
  • using for storage: The MLDBM Module
  • using seq(): Chaining multiple values into a hash
• DB_HASH storage format: Creating a New Database
• • Chaining multiple values into a hash
• DBI: Introduction
• • application architecture: Architecture of a DBI Application
  • architecture: DBI Architecture
  • combining with ODBC: The Marriage of DBI and ODBC
  • connecting to databases: Data Source Names
  • conventions: Notation and Conventions
  • data flow through: DBI Architecture
  • data source names (see data source names)
  • database drivers: DBI Architecture
  • database proxying: Database Proxying
  • downloading source code: Acquiring the DBI and Drivers
  • error codes: Standard Error Codes
  • error handling (see error handling)
  • execution tracing: Tracing DBI Execution
  • formatting output generated by tracing: Neat and Tidy Formatting
  • handles (see handles)
  • home page: Getting Help
  • implementing drivers: DBI Architecture
  • implementing SQL: Standard SQL Syntax
  • installing: Acquiring the DBI and Drivers
  • integrating databases and websites: Constructing "on-the-fly" statements
  • interface rules: General Interface Rules and Caveats
  • metadata functions: Rich Metadata
  • module: DBI Architecture
  • naming conventions: Naming Conventions and Name Space
  • proxy architecture: The Database Proxy Architecture
  • proxy servers (see proxy servers)
  • real-world uses: DBI in the Real World
  • shell program (dbish): dbish--The DBI Shell
  • specification: DBI Specification
  • statement preparation data flow: Preparing SQL Statements
  • supporting databases: DBI Architecture
  • synopsis: Synopsis
  • transaction handling (see transaction handling)
  • usage summary: Outline Usage
  • utility functions (see utility functions)
  • utility methods (see utility methods)
  • using Win32::DBIODBC module: Moving Between Win32::ODBC and the DBI
• DBI->available_drivers() ) (see available_drivers()
• DBI->connect() ) (see connect())
• DBI->data_sources() ) (see data_sources()
• DBI->trace() ) (see trace()
• DBI->trace_msg() ) (see trace_msg()
• DBI methods, passing attributes to: Passing Attributes to DBI Methods
• dbi-users mailing list: Mailing List
• DBI_AUTOPROXY environment variable: Connecting to the proxy server
• • DBI Class Methods
• DBI_DSN environment variable: Data Source Names
• • Connecting with Attributes
  • DBI Class Methods
• DBI::neat_list(): Handling Statements
• DBI_PASS environment variable: DBI Class Methods
• dbiproxy script: Setting up a proxy server
• • Access configuration
• DBI::ProxyServer module: The Database Proxy Architecture
• • Advanced Topics
• dbish (DBI shell): dbish--The DBI Shell
• • command syntax: Handling Statements
  • issuing ad-hoc SQL statements: Handling Statements
  • miscellaneous commands: Some Miscellaneous dbish Commands
• DBI_TRACE environment variable: Tracing DBI Execution
• DBI_USER environment variable: DBI Class Methods
• DBM file libraries: Storage Managers and Layers
• DBM files: DBM Files and the BerkeleyDatabase Manager
• • accessor methods: Object accessor methods
  • Berkeley databases and: DBM Files and the BerkeleyDatabase Manager
  • chaining multiple values into a hash: Chaining multiple values into a hash
  • creating new databases: Creating a New Database
  • deleting values: Deleting Values
  • file descriptors: Locking Strategies
  • hashtables, querying limitations: Querying limitations of DBM files and hashtables
  • key/value pairs: DBM Files and the BerkeleyDatabase Manager
  • • Inserting and Retrieving Values
  • localized storage and retrieval: Localized storage and retrieval
  • packing in Perl objects: Packing in Perl objects
  • storing data using join() or pack(): Localized storage and retrieval
• DBperl: DBI--Thrashed and Mutated
• DB_RECNO storage format: Creating a New Database
• DDL (Data Definition Language) commands: Creating and Destroying Tables
• debugging ) (see trace()
• delete operator, Perl: Deleting Values
• DELETE SQL statement: Deleting Data
• delimited-field files
• • deleting data: Deleting Data
  • inserting data: Inserting Data
  • querying data: Querying Data
  • updating data: Updating Data
• delimited fields, choosing vs. fixed-length records: Querying Data
• delimiting characters: Flat-File Databases
• DESC SQL statement: Ordering data
• DESTROY method: Disconnection
• • Disconnecting, One Way or Another
  • Database Handle Methods
• diagnostics, error (see error diagnostics)
• die(): Automatic Versus Manual Error Checking
• • Executing Select Statements
  • Finishing a Data Fetch Early
  • automatic error checking: Automatic error checking
  • used with RaiseError: Common Attributes
• disconnect(): Disconnection
• • Finishing a Data Fetch Early
  • Database Handle Methods
  • transaction handling: Disconnecting, One Way or Another
• distributed environments: From Mainframes to Workstations
• DML (Data Manipulation Language) commands: Querying Data
• • Modifying Data Within Tables
• do(): Executing Non-SELECT Statements
• • Database Handle Methods
  • vs. prepare(): do( ) Versus prepare( )
• Driver database handle attribute: Databases in which a transaction must be explicitly started
• driver handles: Driver Handles
• driver-specific attributes: Handle Attributes and Metadata
• dump_results(): quick way to fetch and print
• • Datatypes for placeholders

Symbols | 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