Index

P

packages : installing INSTALL statement
packages : removing REMOVE statement
packages : supported Built-in Java classes
packages : unsupported Unsupported packages and classes
packet size : limiting - p command-line option
page size : maximum allowed -gp command-line option
page sizes : creating databases CREATE DATABASE statement
page usage : tables sa_table_page_usage system procedure
PageRelocations property Properties available for the server
pages : displaying usage in database files The Information utility
PageSize property Properties available for each database
parallel execution : processors -gt command-line option
parallel execution : threads -gx command-line option
PARAMETERS statement : syntax PARAMETERS statement [ISQL]
password : for the LTM The LTM configuration file
Password connection parameter Password connection parameter [PWD]
passwords : changing GRANT statement
passwords : encrypting EncryptedPassword connection parameter [ENP]
passwords : in the system tables SYSUSERPERM system table
passwords : minimum length MIN_PASSWORD_LENGTH option
PATH environment variable PATH environment variable
PATINDEX function PATINDEX function [String]
pattern matching : about LIKE conditions
pattern matching : and case-sensitivity LIKE conditions
pattern matching : and collations LIKE conditions
pattern matching : limits LIKE conditions
pattern matching : maximum length of pattern LIKE conditions
PendingReq property Properties available for the server
percent sign : modulo or comment PERCENT_AS_COMMENT option
PERCENT_AS_COMMENT option : about PERCENT_AS_COMMENT option
performance : cache size - c command-line option
performance : monitoring Monitoring database performance
Monitoring database statistics from the Windows NT Performance Monitor
performance : monitoring in Sybase Central Monitoring database statistics from Sybase Central
performance : prefetch PREFETCH option
performance : setting priorities BACKGROUND_PRIORITY option
performance monitor : starting Monitoring database statistics from the Windows NT Performance Monitor
performance monitor : Windows NT Monitoring database statistics from the Windows NT Performance Monitor
permissions : CONNECT authority GRANT statement
permissions : DBA authority GRANT statement
permissions : EXECUTE GRANT statement
permissions : GRANT statement GRANT statement
permissions : GROUP authority GRANT statement
permissions : in the system tables SYSCOLPERM system table
SYSTABLEPERM system table
permissions : MEMBERSHIP GRANT statement
permissions : RESOURCE authority GRANT statement
permissions : revoking REVOKE statement
permissions : SYSCOLAUTH system view SYSCOLAUTH system view
permissions : system views SYSTABAUTH system view
PI function PI function [Numeric]
PLAN function PLAN function [Miscellaneous]
Platform property Properties available for the server
plug-ins : registry entries Registry settings on installation
PORT communication parameter SERVERPORT parameter [ PORT]
port number : for the database server SERVERPORT parameter [ PORT]
Port property Connection properties
positioned DELETE statement : syntax DELETE (positioned) statement [ESQL] [SP]
POWER function POWER function [Numeric]
precedence of operators Operator precedence
PRECISION option General database options
PRECISION option : about PRECISION option
predicates : about Search conditions
PREFETCH option PREFETCH option
PREPARE statement : syntax PREPARE statement [ESQL]
PREPARE TO COMMIT statement : syntax PREPARE TO COMMIT statement
prepared statement PREPARE statement [ESQL]
prepared statements : connection limits MAX_STATEMENT_COUNT option
prepared statements : dropping DROP STATEMENT statement [ESQL]
prepared statements : EXECUTE statement EXECUTE statement [ESQL]
PrepStmt property Connection properties
primary keys : and integrity Adaptive Server Anywhere SQL features
primary keys : in the system tables SYSCOLUMN system table
SYSTABLE system table
primary keys : integrity constraints CREATE TABLE statement
primary table : in the system tables SYSFOREIGNKEY system table
PRINT statement PRINT statement [T-SQL]
priority : process -gb command-line option
ProcedurePages property Properties available for the server
procedures PREPARE statement [ESQL]
procedures : altering ALTER PROCEDURE statement
procedures : calling EXECUTE statement [T-SQL]
procedures : catalog, list System and catalog stored procedures
procedures : creating CREATE PROCEDURE statement
procedures : dropping DROP statement
procedures : dynamic SQL statements EXECUTE IMMEDIATE statement [ESQL] [SP]
procedures : error handing in Transact-SQL RAISERROR statement [T-SQL]
procedures : executing EXECUTE statement [T-SQL]
procedures : extended, list System extended stored procedures
procedures : RAISERROR statement RAISERROR statement [T-SQL]
procedures : replicating ALTER PROCEDURE statement
procedures : returning values from RETURN statement
procedures : system CHAPTER 14. System Procedures and Functions
procedures : Transact-SQL CREATE PROCEDURE statement CREATE PROCEDURE statement [T-SQL]
procedures : Transact-SQL, list Adaptive Server Enterprise system and catalog procedures
procedures : variable result sets CREATE PROCEDURE statement
DESCRIBE statement [ESQL]
processors : multiple -gt command-line option
ProcessTime property Connection properties
proc_role Adaptive Server Enterprise function Connection properties
product name : retrieving xp_msver system function
ProductName property Properties available for the server
ProductVersion property Properties available for the server
projections : SELECT statement SELECT statement
properties : connection System and catalog stored procedures
Connection properties
properties : database System and catalog stored procedures
Properties available for each database
properties : engine System and catalog stored procedures
properties : server Properties available for the server
PROPERTY function PROPERTY function [System]
property function : about Obtaining database statistics from a client application
PROPERTY_DESCRIPTION function PROPERTY_DESCRIPTION function [System]
PROPERTY_NAME function PROPERTY_NAME function [System]
PROPERTY_NUMBER function PROPERTY_NUMBER function [System]
protocols : disabling shared memory -sc command-line option
PUBLIC group : in the system tables SYSUSERPERM system table
publications : designing UPDATE statement
publications : updates UPDATE statement
publisher Constants in expressions
Constants in expressions
PURGE clause : FETCH statement FETCH statement [ESQL] [SP]
PUT statement : syntax PUT statement [ESQL] [SP]
PWD connection parameter Password connection parameter [PWD]