Book Home

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

4.4.1. Connection
A.3.1. DBI Class Methods

$dbh database handle: 4.2.2. Database Handles

$dbh variable: A.3.1. DBI Class Methods

$DBI::err variable: 4.5.2. Error Diagnostics

A.3.3. DBI Dynamic Attributes

$DBI::errstr variable: 4.5.2. Error Diagnostics

A.3.3. DBI Dynamic Attributes

$DBI::rows variable ) (see rows()

$DBI::state variable: 4.5.2. Error Diagnostics

7.3.2. Standard Error Codes
A.3.3. DBI Dynamic Attributes

$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: A.6.1. Database Handle Methods
selectcol_arrayref(): A.6.1. Database Handle Methods
selectrow_array(): 5.6.1. Atomic Fetching: A.6.1. Database Handle Methods
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

2.5.1. The Perl Data::Dumper Module

Storable: 2. Basic Non-DBI Databases

2.5.2. The Storable Module

modifying within tables: 3.4. Modifying Data Within Tables

committing changes: 3.4.4. Committing and Rolling Back Modifications

6.3.1. Automatic Transaction Handling

deleting data: 3.4.2. Deleting Data

inserting data: 3.4.1. Inserting Data

undoing changes: 3.4.4. Committing and Rolling Back Modifications

6.3.3. Rolling Back Changes

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

2.4.1. Querying Data

serializing: 2.5. Putting Complex Data into Flat Files

2.8. The MLDBM Module

storing (see data, inserting)

trailing blanks, removing: 6.1.4. Common Attributes

truncating long values: 6.1.4. Common Attributes

6.2. Handling LONG/LOB Data

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

available_drivers(): 4.3. Data Source Names

connect() and: 4.3. Data Source Names

6.1.2. Connecting with Attributes

data_sources(): 4.3. Data Source Names

name=value pairs: 4.3. Data Source Names

data structures, storing complex: 2.8. The MLDBM Module

data warehousing: 1.1. From Mainframes to Workstations

3.1. The Relational Database Methodology
3.4. Modifying Data Within Tables

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

B.1. Acquiring the DBI and Drivers

prefixes: 4.3. Data Source Names

6.1.3. The Significance of Case
A.2.5. Naming Conventions and Name Space

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: 6.1.3. The Significance of Case
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

7. ODBC and the DBI

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

3.5. Creating and Destroying Tables

disconnecting from: 4.4.2. Disconnection

6.3.4. Disconnecting, One Way or Another

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

6.1.6. Database Metadata

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

2.5.1. The Perl Data::Dumper Module
displaying restored data: 2.8. The MLDBM Module

DataHash(): 7.4.2. Win32::ODBC

data_sources(): A.3.1. DBI Class Methods

available_drivers() and: 4.3. Data Source Names
driver handles and: 4.2.1. Driver Handles

datatypes: 3.2. Datatypes and NULL Values

binary large object: 3.2. Datatypes and NULL Values

6.1.4. Common Attributes

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

6.2. Handling LONG/LOB Data

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

2.7.3.5. Chaining multiple values into a hash

DBD::ADO 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

DBD::CSV 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
SQL dialect: B. Driver and Database Characteristics
table metadata: B. Driver and Database Characteristics

DBD::DB2 driver: B. Driver and Database Characteristics

connect syntax: B. Driver and Database Characteristics
datatypes: 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::Empress driver: B. Driver and Database Characteristics

connect syntax: B. Driver and Database Characteristics
datatypes: 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::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

connect syntax: B. Driver and Database Characteristics
datatypes: 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::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

connect syntax: B. Driver and Database Characteristics
datatypes: B. Driver and Database Characteristics
SQL dialect: B. Driver and Database Characteristics
table metadata: B. Driver and Database Characteristics

DBD::ODBC module

vs. Win32::ODBC: 7.4.1. DBD::ODBC

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

8.2.1.2. Connecting to the proxy server
A.3.1. DBI Class Methods

DBDs (see database drivers)

DBD::SearchServer driver: B. Driver and Database Characteristics

connect syntax: B. Driver and Database Characteristics
datatypes: 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

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

connect syntax: B. Driver and Database Characteristics
datatypes: 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

DB_File module: 2.7. DBM Files and the BerkeleyDatabase Manager

2.8. The MLDBM Module
default values: 2.7.1. Creating a New Database
using for storage: 2.8. The MLDBM Module
using seq(): 2.7.3.5. Chaining multiple values into a hash

DB_HASH storage format: 2.7.1. Creating a New Database

2.7.3.5. Chaining multiple values into a hash

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

A.3.1. DBI Class Methods

DBI_DSN environment variable: 4.3. Data Source Names

6.1.2. Connecting with Attributes
A.3.1. DBI Class Methods

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

8.2.2.1. Access configuration

DBI::ProxyServer module: 8.2.1. The Database Proxy Architecture

8.2.2. Advanced Topics

dbish (DBI shell): 8.1. dbish--The DBI Shell

command syntax: 8.1.2. Handling Statements
issuing ad-hoc SQL statements: 8.1.2. Handling Statements
miscellaneous commands: 8.1.3. Some Miscellaneous dbish Commands

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

2.7.3. Inserting and Retrieving Values

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

deleting data: 2.4.4. Deleting Data
inserting data: 2.4.2. Inserting Data
querying data: 2.4.1. Querying Data
updating data: 2.4.3. Updating Data

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

6.3.4. Disconnecting, One Way or Another
A.6.1. Database Handle Methods

diagnostics, error (see error diagnostics)

die(): 4.5.1. Automatic Versus Manual Error Checking

5.1.2. Executing Select Statements
5.1.4. Finishing a Data Fetch Early
automatic error checking: 4.5.1.2. Automatic error checking
used with RaiseError: 6.1.4. Common Attributes

disconnect(): 4.4.2. Disconnection

5.1.4. Finishing a Data Fetch Early
A.6.1. Database Handle Methods
transaction handling: 6.3.4. Disconnecting, One Way or Another

distributed environments: 1.1. From Mainframes to Workstations

DML (Data Manipulation Language) commands: 3.3. Querying Data

3.4. Modifying Data Within Tables

do(): 5.2. Executing Non-SELECT Statements

A.6.1. Database Handle Methods
vs. prepare(): 5.5. do( ) Versus prepare( )

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

A.7.1.1. 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