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

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
formatting and displaying data: 6.1.7. Statement Handle Attributes or Statement Metadata
getting or setting values: 6.1. Handle Attributes and Metadata
passing to DBI methods: 6.1.1. Passing Attributes to DBI Methods

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