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: 4.3. Data Source Names
- $dbh database handle: 4.2.2. Database Handles
- $dbh variable: A.3.1. DBI Class Methods
- $DBI::err variable: 4.5.2. Error Diagnostics
- $DBI::errstr variable: 4.5.2. Error Diagnostics
- $DBI::rows variable ) (see rows()
- $DBI::state variable: 4.5.2. Error Diagnostics
- $drh driver handle: 4.2.1. Driver Handles
- data
- compression: 8.2.2.2. Compression
- deleting: 2.2. Query Languages and Data Functions
- 3.4.2. Deleting Data
- 5.2. Executing Non-SELECT Statements
- delimited-field files: 2.4.4. Deleting Data
- fixed-length record files: 2.4.4. Deleting Data
- encryption: 8.2.2.3. Ciphers
- fetching: 2.2. Query Languages and Data Functions
- using DBI: 5.1.3. Fetching Data
- fetchrow_array(): 5.1.3. Fetching Data
- fetchrow_arrayref(): 5.1.3. Fetching Data
- fetchrow_hashref(): 5.1.3. Fetching Data
- finishing early: 5.1.4. Finishing a Data Fetch Early
- piece-by-piece: 6.2. Handling LONG/LOB Data
- printing and: 5.1.3.1. A quick way to fetch and print
- selectall_arrayref(): 5.6.2. Batch Fetching
- selectcol_arrayref(): A.6.1. Database Handle Methods
- selectrow_array(): 5.6.1. Atomic Fetching
- selectrow_arrayref(): 5.6.1. Atomic Fetching
- inserting: 2.2. Query Languages and Data Functions
- 3.4.1. Inserting Data
- 5.2. Executing Non-SELECT Statements
- delimited-field files: 2.4.2. Inserting Data
- fixed-length record files: 2.4.2. Inserting Data
- using quote(): 4.6.1. Database-Specific Quote Handling
- long values, truncating: 6.1.4. Common Attributes
- marshalling modules
- Data::Dumper: 2. Basic Non-DBI Databases
- Storable: 2. Basic Non-DBI Databases
- modifying within tables: 3.4. Modifying Data Within Tables
- committing changes: 3.4.4. Committing and Rolling Back Modifications
- deleting data: 3.4.2. Deleting Data
- inserting data: 3.4.1. Inserting Data
- undoing changes: 3.4.4. Committing and Rolling Back Modifications
- updating data: 3.4.3. Updating Data
- querying: 2.4.1. Querying Data
- delimited-field files: 2.4.1. Querying Data
- fixed-length record files: 2.4.1. Querying Data
- from multiple tables: 3.3.3. Queries over Multiple Tables
- from single tables: 3.3.2. Queries and Condition Clauses
- using SQL: 3.3. Querying Data
- rolling back: 6.3. Transactions, Locking, and Isolation
- selecting: 2.2. Query Languages and Data Functions
- serializing: 2.5. Putting Complex Data into Flat Files
- storing (see data, inserting)
- trailing blanks, removing: 6.1.4. Common Attributes
- truncating long values: 6.1.4. Common Attributes
- updating: 2.2. Query Languages and Data Functions
- 3.4.3. Updating Data
- 5.2. Executing Non-SELECT Statements
- delimited-field files: 2.4.3. Updating Data
- fixed-length record files: 2.4.3. Updating Data
- data source names: 4.3. Data Source Names
- data structures, storing complex: 2.8. The MLDBM Module
- data warehousing: 1.1. From Mainframes to Workstations
- database drivers
- connection syntax examples
- CSV: 4.3. Data Source Names
- mSQL: 4.3. Data Source Names
- Oracle: 4.3. Data Source Names
- DBI: 4.1. DBI Architecture
- prefixes: 4.3. Data Source Names
- standard: 4.3. Data Source Names
- database handles: 4.2.2. Database Handles
- atomic fetching and: 5.6.1. Atomic Fetching
- attributes: 6.1.5. Database Handle Attributes
- connecting with: 6.1.2. Connecting with Attributes
- driver-specific: 6.1. Handle Attributes and Metadata
- error checking: 6.1.4. Common Attributes
- getting or setting values: 6.1. Handle Attributes and Metadata
- passing to DBI methods: 6.1.1. Passing Attributes to DBI Methods
- $dbh: 4.2.2. Database Handles
- retrieving entity metadata: 6.1.6. Database Metadata
- database-independent programming interfaces: 1.1. From Mainframes to Workstations
- database metadata: 6.1.6. Database Metadata
- databases
- accessing using proxying: 8.2. Database Proxying
- basic attributes: 2. Basic Non-DBI Databases
- Berkeley (see Berkeley databases)
- committing changes: 6.3. Transactions, Locking, and Isolation
- concurrent access to: 2.6. Concurrent Database Access and Locking
- connecting to: 4.4.1. Connection
- requirements: 4.4.1. Connection
- with dbish: 8.1.1. Starting Up dbish
- creating new tables: 3.5. Creating and Destroying Tables
- cursors: 5.1.3. Fetching Data
- deleting tables: 3.5. Creating and Destroying Tables
- disconnecting from: 4.4.2. Disconnection
- evolution from mainframes to workstations: 1.1. From Mainframes to Workstations
- executing SQL statements: 5.1.2. Executing Select Statements
- extracting table information, example: 6.1.7. Statement Handle Attributes or Statement Metadata
- fetching data: 5.1. Issuing Simple Queries
- using DBI: 5.1.3. Fetching Data
- file locking: 2.6. Concurrent Database Access and Locking
- flat-file (see flat-file databases)
- generating dynamic views: 6.1.6. Database Metadata
- locking
- Berkeley databases: 2.7.2. Locking Strategies
- flat-file databases: 2.6. Concurrent Database Access and Locking
- preparing SQL statements: 5.1.1. Preparing SQL Statements
- proxying: 8.2. Database Proxying
- queries, issuing simple: 5.1. Issuing Simple Queries
- query languages (see query languages)
- quoting and escaping SQL statements: 4.6.1. Database-Specific Quote Handling
- relational: 3.1. The Relational Database Methodology
- result sets: 5.1.3. Fetching Data
- retrieving entity metadata: 6.1.6. Database Metadata
- rolling back changes: 6.3. Transactions, Locking, and Isolation
- schemas: 3.1. The Relational Database Methodology
- storage managers and layers: 2.1. Storage Managers and Layers
- system catalogs: 6.1.6. Database Metadata
- Data::Dumper module: 2. Basic Non-DBI Databases
- DataHash(): 7.4.2. Win32::ODBC
- data_sources(): A.3.1. DBI Class Methods
- datatypes: 3.2. Datatypes and NULL Values
- binary large object: 3.2. Datatypes and NULL Values
- bind values and: 5.3.2. Bind Values and Data Typing
- character: 3.2. Datatypes and NULL Values
- date: 3.2. Datatypes and NULL Values
- LOB (large object): 6.2. Handling LONG/LOB Data
- LONG: 6.1.4. Common Attributes
- numeric: 3.2. Datatypes and NULL Values
- date datatype: 3.2. Datatypes and NULL Values
- DB2 (see DBD\\DB2 driver)
- db database manager: 2.7. DBM Files and the BerkeleyDatabase Manager
- DB_BTREE storage format: 2.7.1. Creating a New Database
- DBD::ADO driver: B. Driver and Database Characteristics
- DBD::CSV driver: B. Driver and Database Characteristics
- DBD::DB2 driver: B. Driver and Database Characteristics
- DBD::Empress driver: B. Driver and Database Characteristics
- DBD::EmpressNet driver (see DBD\\Empress driver)
- DBD::Informix driver: B. Driver and Database Characteristics
- connect syntax: B. Driver and Database Characteristics
- datatypes: B. Driver and Database Characteristics
- SQL dialect: B. Driver and Database Characteristics
- stored procedures: B. Driver and Database Characteristics
- table metadata: B. Driver and Database Characteristics
- transactions: B. Driver and Database Characteristics
- DBD::Ingres driver: B. Driver and Database Characteristics
- connect syntax: B. Driver and Database Characteristics
- datatypes: B. Driver and Database Characteristics
- driver-specific attributes: B. Driver and Database Characteristics
- parameter binding: B. Driver and Database Characteristics
- SQL dialect: B. Driver and Database Characteristics
- table metadata: B. Driver and Database Characteristics
- transactions: B. Driver and Database Characteristics
- DBD::InterBase driver: B. Driver and Database Characteristics
- DBD::mSQL driver (see DBD\\mysql driver)
- DBD::mysql driver: B. Driver and Database Characteristics
- connect syntax: B. Driver and Database Characteristics
- datatypes: B. Driver and Database Characteristics
- driver-specific attributes and methods: B. Driver and Database Characteristics
- locking: B. Driver and Database Characteristics
- parameter binding: B. Driver and Database Characteristics
- SQL dialect: B. Driver and Database Characteristics
- table metadata: B. Driver and Database Characteristics
- DBD::ODBC driver: B. Driver and Database Characteristics
- DBD::ODBC module
- DBD::Oracle driver: B. Driver and Database Characteristics
- connect syntax: B. Driver and Database Characteristics
- datatypes: B. Driver and Database Characteristics
- driver-specific methods: B. Driver and Database Characteristics
- parameter binding: B. Driver and Database Characteristics
- SQL dialect: B. Driver and Database Characteristics
- stored procedures: B. Driver and Database Characteristics
- table metadata: B. Driver and Database Characteristics
- transactions: B. Driver and Database Characteristics
- DBD::Pg driver: B. Driver and Database Characteristics
- connect syntax: B. Driver and Database Characteristics
- datatypes: B. Driver and Database Characteristics
- driver-specific attributes: B. Driver and Database Characteristics
- parameter binding: B. Driver and Database Characteristics
- SQL dialect: B. Driver and Database Characteristics
- transactions: B. Driver and Database Characteristics
- DBD::Proxy module: 8.2.1. The Database Proxy Architecture
- DBDs (see database drivers)
- DBD::SearchServer driver: B. Driver and Database Characteristics
- DBD::Sybase driver: B. Driver and Database Characteristics
- connect syntax: B. Driver and Database Characteristics
- datatypes: B. Driver and Database Characteristics
- driver-specific attributes and methods: B. Driver and Database Characteristics
- parameter binding: B. Driver and Database Characteristics
- SQL dialect: B. Driver and Database Characteristics
- stored procedures: B. Driver and Database Characteristics
- transactions: B. Driver and Database Characteristics
- DBD::XBase driver: B. Driver and Database Characteristics
- DB_File module: 2.7. DBM Files and the BerkeleyDatabase Manager
- DB_HASH storage format: 2.7.1. Creating a New Database
- DBI: 1. Introduction
- application architecture: A.2.1. Architecture of a DBI Application
- architecture: 4.1. DBI Architecture
- combining with ODBC: 7.5. The Marriage of DBI and ODBC
- connecting to databases: 4.3. Data Source Names
- conventions: A.2.2. Notation and Conventions
- data flow through: 4.1. DBI Architecture
- data source names (see data source names)
- database drivers: 4.1. DBI Architecture
- database proxying: 8.2. Database Proxying
- downloading source code: B.1. Acquiring the DBI and Drivers
- error codes: 7.3.2. Standard Error Codes
- error handling (see error handling)
- execution tracing: 4.6.2. Tracing DBI Execution
- formatting output generated by tracing: 4.6.3. Neat and Tidy Formatting
- handles (see handles)
- home page: A.1.1. Getting Help
- implementing drivers: 4.1. DBI Architecture
- implementing SQL: 7.3.1. A Standard SQL Syntax
- installing: B.1. Acquiring the DBI and Drivers
- integrating databases and web sites: 5.1.1.1. Constructing "on-the-fly" statements
- interface rules: A.2.4. General Interface Rules and Caveats
- metadata functions: 7.3.3. Rich Metadata
- module: 4.1. DBI Architecture
- naming conventions: A.2.5. Naming Conventions and Name Space
- proxy architecture: 8.2.1. The Database Proxy Architecture
- proxy servers (see proxy servers)
- real-world uses: 1.3. DBI in the Real World
- shell program (dbish): 8.1. dbish--The DBI Shell
- specification: A. DBI Specification
- statement preparation data flow: 5.1.1. Preparing SQL Statements
- supporting databases: 4.1. DBI Architecture
- synopsis: A.1. Synopsis
- transaction handling (see transaction handling)
- usage summary: A.2.3. Outline Usage
- utility functions (see utility functions)
- utility methods (see utility methods)
- using Win32::DBIODBC module: 7.7. 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: 6.1.1. Passing Attributes to DBI Methods
- dbi-users mailing list: A.9.4. Mailing List
- DBI_AUTOPROXY environment variable: 8.2.1.2. Connecting to the proxy server
- DBI_DSN environment variable: 4.3. Data Source Names
- DBI::neat_list(): 8.1.2. Handling Statements
- DBI_PASS environment variable: A.3.1. DBI Class Methods
- dbiproxy script: 8.2.1.1. Setting up a proxy server
- DBI::ProxyServer module: 8.2.1. The Database Proxy Architecture
- dbish (DBI shell): 8.1. dbish--The DBI Shell
- DBI_TRACE environment variable: 4.6.2. Tracing DBI Execution
- DBI_USER environment variable: A.3.1. DBI Class Methods
- DBM file libraries: 2.1. Storage Managers and Layers
- DBM files: 2.7. DBM Files and the BerkeleyDatabase Manager
- accessor methods: 2.7.3.3. Object accessor methods
- Berkeley databases and: 2.7. DBM Files and the BerkeleyDatabase Manager
- chaining multiple values into a hash: 2.7.3.5. Chaining multiple values into a hash
- creating new databases: 2.7.1. Creating a New Database
- deleting values: 2.7.4. Deleting Values
- file descriptors: 2.7.2. Locking Strategies
- hashtables, querying limitations: 2.7.3.4. Querying limitations of DBM files and hashtables
- key/value pairs: 2.7. DBM Files and the BerkeleyDatabase Manager
- localized storage and retrieval: 2.7.3.1. Localized storage and retrieval
- packing in Perl objects: 2.7.3.2. Packing in Perl objects
- storing data using join() or pack(): 2.7.3.1. Localized storage and retrieval
- DBperl: 7.2. DBI--Thrashed and Mutated
- DB_RECNO storage format: 2.7.1. Creating a New Database
- DDL (Data Definition Language) commands: 3.5. Creating and Destroying Tables
- debugging ) (see trace()
- delete operator, Perl: 2.7.4. Deleting Values
- DELETE SQL statement: 3.4.2. Deleting Data
- delimited-field files
- delimited fields, choosing vs. fixed-length records: 2.4.1. Querying Data
- delimiting characters: 2.4. Flat-File Databases
- DESC SQL statement: 3.3.4.1. Ordering data
- DESTROY method: 4.4.2. Disconnection
- diagnostics, error (see error diagnostics)
- die(): 4.5.1. Automatic Versus Manual Error Checking
- disconnect(): 4.4.2. Disconnection
- distributed environments: 1.1. From Mainframes to Workstations
- DML (Data Manipulation Language) commands: 3.3. Querying Data
- do(): 5.2. Executing Non-SELECT Statements
- Driver database handle attribute: A.6.2.3. Databases in which a transaction must be explicitly started
- driver handles: 4.2.1. Driver Handles
- driver-specific attributes: 6.1. Handle Attributes and Metadata
- dump_results(): 5.1.3.1. A quick way to fetch and print
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
Copyright © 2001 O'Reilly & Associates, Inc. All Rights Reserved.