Index

L

LANalyzer Diagnosing wiring problems
language library : messages file Overview of language issues
language support : about CHAPTER 12. Database Collations and International Languages
language support : collations Choosing a database collation
language support : multibyte character sets Using multibyte collations
language support : overview Introduction
languages : file names File naming conventions
LANVDD driver Using NetBIOS with OS/2
laptop computers : and transactions Replication and concurrency
leaf page : and indexes How indexes work
LEAVE statement : syntax Control statements
left-outer joins : FROM clause Inner, left-outer, and right-outer joins
less than : comparison operator Using comparison operators in the WHERE clause
less than : range specification Using ranges (between and not between) in the WHERE clause
less than or equal to : comparison operator Using comparison operators in the WHERE clause
levels : of isolation Isolation levels and consistency
levels of isolation : changing Setting the isolation level
levels of isolation : changing within a transaction Changing the isolation level within a transaction
levels of isolation : setting default Setting the isolation level
libctl.cfg file : dsedit Opening a Directory Services session
LIKE operator : wildcards Matching character strings in the WHERE clause
line breaks : SQL Entering queries
Links connection parameter : about Connection parameters
list, matching in SELECT Using lists in the WHERE clause
literal values : NULL Properties of NULL
live backups Using a live backup for machine redundancy
live backups : regular backups and Using a live backup for machine redundancy
LivenessTimeout connection parameter : about Connection parameters
LOAD DATABASE statement : unsupported Servers and databases
LOAD TABLE statement : about Loading data using the LOAD TABLE statement
LOAD TRANSACTION statement : unsupported Servers and databases
local variables : and result sets Returning result sets from Transact-SQL procedures
local variables : Java debugger Compiling classes for debugging
local variables : modifying Inspecting and modifying variables
locale : character sets Character set translation details
localhost : machine name Adding or changing the server address
Locals window : Java debugger The debugger windows
LocalSystem account : about Understanding Windows NT services
LocalSystem account : options Setting the account options
locking : about dirty reads Using locks to ensure consistency
locks Using locks to ensure consistency
locks : about CHAPTER 15. Using Transactions and Locks
How locking works
locks : anti-phantom The four types of locks
locks : blocking Transaction blocking
Locking conflicts
locks : choosing isolation levels Tutorial 2 - The non-repeatable read
locks : conflict handling Transaction blocking
Locking conflicts
locks : conflicting types The four types of locks
locks : deadlock Transaction blocking and deadlock
locks : early release of Two-phase locking
Typical transactions at various isolation levels
Early release of read locks—an exception
locks : exclusive The four types of locks
The four types of locks
locks : how locking works How locking works
locks : implementation at level 0 Selecting at isolation level 0
locks : implementation at level 1 Selecting at isolation level 1
locks : implementation at level 2 Selecting at isolation level 2
locks : implementation at level 3 Selecting at isolation level 3
locks : inconsistencies versus typical isolation levels Isolation levels and consistency
How Adaptive Server Anywhere implements locking
locks : insert The four types of locks
locks : isolation levels How locking works
Isolation levels and consistency
locks : nonexclusive The four types of locks
The four types of locks
The four types of locks
locks : orphans and referential integrity Locking during inserts
locks : phantom The four types of locks
The four types of locks
Locking during deletes
Locking during deletes
locks : phantom rows versus isolation levels Tutorial 3 - A phantom row
Tutorial 4 - Practical locking implications
locks : procedure for deletes Locking during deletes
locks : procedure for inserts Locking during inserts
locks : procedure for updates Locking during updates
locks : read The four types of locks
The four types of locks
Locking during deletes
locks : reducing the impact through indexes Reducing the impact of locking
locks : reducing to improve concurrency Improving concurrency
locks : shared versus exclusive The four types of locks
locks : two-phase locking Two-phase locking
locks : typical inconsistencies prevented by Typical inconsistencies
locks : typical transactions versus isolation levels Typical transactions at various isolation levels
locks : uses The four types of locks
locks : write The four types of locks
The four types of locks
LOG connection parameter : about Connection parameters
log files : checkpoint The checkpoint log
log files : rollback The rollback log
log files : transaction The transaction log
Log Transfer Manager : about Sybase applications and Adaptive Server Anywhere
log translation utility Converting transaction logs to SQL
Logfile connection parameter : about Connection parameters
logical operators : HAVING clauses The HAVING clause: selecting groups of data
logins : integrated Using integrated logins
Using integrated logins
LOGIN_MODE database option : integrated logins Enabling the integrated login feature
logs : rollback log Savepoints within transactions
LOOP statement : in procedures Using cursors on SELECT statements in procedures
LOOP statement : syntax Control statements
lost updates : and transactions Transactions for which no updates are lost
lost updates : preventing using cursors Cursor stability
Lotus format Input and output data formats
Lotus Notes : passwords Lotus Notes SQL 2.0 (2.04.0203))
Lotus Notes : remote data access Lotus Notes SQL 2.0 (2.04.0203))
LTM : Adaptive Server Anywhere character sets Adaptive Server Anywhere collations
LTM : Adaptive Server Anywhere collations Adaptive Server Anywhere collations
LTM : and transaction log management Using the DELETE_OLD_LOGS option
LTM : character set configuration Character set settings in the LTM configuration file
LTM : character sets Language and character set issues
LTM : collations Character set settings in the LTM configuration file
Character set settings in the LTM configuration file
Language and character set issues
Language and character set issues
Open Client/Open Server collations
LTM : configuration Set up the Open Servers in your system
Configuring the LTM
LTM : configuration file Configure and start the Adaptive Server Anywhere LTM
LTM : Open Client/Open Server character sets Open Client/Open Server collations
LTM : Open Client/Open Server collations Open Client/Open Server collations
LTM : starting Configure and start the Adaptive Server Anywhere LTM
LTM : supported operations Using the LTM
LTM configuration file : about Configuring the LTM
LTM configuration file : character sets Character set settings in the LTM configuration file
LTM configuration file : creating Configuring the LTM
LTM configuration file : format Configuring the LTM
LTM_admin_pw parameter Configure and start the Adaptive Server Anywhere LTM
LTM_admin_user parameter Configure and start the Adaptive Server Anywhere LTM
LTM_charset parameter Configure and start the Adaptive Server Anywhere LTM
LTM_charset parameter : LTM configuration file Character set settings in the LTM configuration file
LTM_language parameter : LTM configuration file Character set settings in the LTM configuration file
LTM_sortorder parameter : LTM configuration file Character set settings in the LTM configuration file
LTO connection parameter : about Connection parameters