start page | rating of books | rating of authors | reviews | copyrights

Book Home

Programming the Perl DBISearch this book

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

Library Navigation Links

Copyright © 2001 O'Reilly & Associates, Inc. All Rights Reserved.