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: S

$SIG{_ _DIE_ _} signal handler: 4.5.1.2. Automatic error checking
6.1.4. Common Attributes
$SIG{_ _WARN_ _} signal handler: 4.5.1.2. Automatic error checking
6.1.4. Common Attributes
$sth statement handle: 4.2.3. Statement Handles
5.1.5. Deallocating Statement Handles
sacred sites, charter: C. ASLaN Sacred Site Charter
SCALE statement handle attribute: 6.1.7. Statement Handle Attributes or Statement Metadata
A.7.2. Statement Handle Attributes
schemas: 3.1. The Relational Database Methodology
6.1.6. Database Metadata
sdbm database manager: 2.7. DBM Files and the BerkeleyDatabase Manager
SDBM_File module: 2.7. DBM Files and the BerkeleyDatabase Manager
SearchServer (see DBD\\SearchServer driver)
security
cipher mechanism and: 8.2.2.3. Ciphers
Taint attribute and: A.5. Attributes Common to All Handles
SELECT SQL statement: 3.3. Querying Data
5.1. Issuing Simple Queries
active statement handles: 5.1.4. Finishing a Data Fetch Early
dbish and: 8.1.2. Handling Statements
executing: 5.1.2. Executing Select Statements
fetching data: 5.1.3. Fetching Data
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
seq(): 2.7.3.5. Chaining multiple values into a hash
Shared SQL Cache: 5.3.1. Bind Values Versus Interpolated Statements
signal handling in Perl: A.8.2. Signal Handling and Canceling Operations
significant digits: 6.1.7. Statement Handle Attributes or Statement Metadata
split(): 2.4.1. Querying Data
2.5.1. The Perl Data::Dumper Module
Sql(): 7.4.2. Win32::ODBC
SQL Access Group: 7.1. ODBC--Embraced and Extended
SQL datatypes (see datatypes)
SQL-level portability: 7.3.1. A Standard SQL Syntax
SQL queries: 3.3. Querying Data
aliasing table names: 3.3.3. Queries over Multiple Tables
condition clauses: 3.3.2. Queries and Condition Clauses
joining tables: 3.3.3. Queries over Multiple Tables
narrowing searches: 3.3.2. Queries and Condition Clauses
outer joins: 3.3.3. Queries over Multiple Tables
primary keys and foreign keys: 3.3.3. Queries over Multiple Tables
rows, retrieving: 3.3.1. Simple Queries
simple queries: 3.3.1. Simple Queries
SQL statements
binding parameters to: 5.3. Binding Parameters to Statements
building dynamically: 6.1.6. Database Metadata
custom-built: 5.1.1.1. Constructing "on-the-fly" statements
dbish and: 8.1.2. Handling Statements
DELETE: 3.4.2. Deleting Data
DESC: 3.3.4.1. Ordering data
executing: 5.1.2. Executing Select Statements
INSERT: 3.4.1. Inserting Data
interpolated: 5.3.1. Bind Values Versus Interpolated Statements
preparing: 5.1.1. Preparing SQL Statements
SELECT: 3.3. Querying Data
5.1. Issuing Simple Queries
5.1.2. Executing Select Statements
5.1.3. Fetching Data
transaction handling (see transaction handling)
TRUNCATE TABLE: 3.4.2. Deleting Data
UPDATE: 3.4.3. Updating Data
WHERE: 3.3.2. Queries and Condition Clauses
SQL syntax, standardized: 7.3.1. A Standard SQL Syntax
SQLSTATE error indicator: 7.3.2. Standard Error Codes
standard drivers: 4.3. Data Source Names
statement buffer: 8.1.2. Handling Statements
statement handles: 4.2.3. Statement Handles
active: 5.1.4. Finishing a Data Fetch Early
attributes: 6.1.7. Statement Handle Attributes or Statement Metadata
batch fetching and: 5.6.2. Batch Fetching
creating via DBI: 5.1.1. Preparing SQL Statements
deallocating: 5.1.5. Deallocating Statement Handles
improving performance with prepare() and execute(): 5.5. do( ) Versus prepare( )
preparing from an SQL statement: 5.1.1. Preparing SQL Statements
$sth: 4.2.3. Statement Handles
5.1.5. Deallocating Statement Handles
statement metadata: 6.1.7. Statement Handle Attributes or Statement Metadata
Statement statement handle attribute: 6.1.7. Statement Handle Attributes or Statement Metadata
A.7.2. Statement Handle Attributes
Storable module: 2. Basic Non-DBI Databases
2.5.2. The Storable Module
storage managers: 2.1. Storage Managers and Layers
MLDBM module: 2.8. The MLDBM Module
strings
formatting: 4.6.3. Neat and Tidy Formatting
packing values into: 2.7.3.2. Packing in Perl objects
Perl, processing of: 1.2. Perl
5.1.1.1. Constructing "on-the-fly" statements
5.3.1. Bind Values Versus Interpolated Statements
support: A.14. Support/ Warranty
dbi-users mailing list: A.9.4. Mailing List
Sybase (see DBD\\Sybase driver)
system catalogs: 6.1.6. Database Metadata


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.