Font size:

Index

Index

Index

Special characters

? (731)
+ -, *, /, unary + and - expressions (1025)
? (dynamic parameter)
- in prepared statements (1053)
- used in conditional expression (1054)
% as wildcard in SQL (727)
* as wildcard in SQL SELECT (726), (884)
_ as wildcard within SQL (728)
{call (JDBC escape syntax) (1156)
{d (JDBC escape syntax) (1158)
{oj (JDBC escape syntax) (1170)
{t (JDBC escape syntax) (1173)
{ts (JDBC escape syntax) (1176)

abs (JDBC scalar function) (1165)
ABS or ABSVAL (function) (900)
Adding Columns (764)
Adding Constraints (765)
Aggregates (897)
- and data types (898)
- definition (896)
- requirements for (899)
ALTER TABLE statement (753)
AND boolean operator (1038)
ASC
- implied in ORDER BY clause (874)
Attributes to database connection URL (1178), (1205)
AuthorizationIdentifierName identifier (750)
autogenerated keys (1152)
AVG aggregate function (901)

Backing indexes
- created automatically to enforce primary key, unique, and foreign key constraints (780), (843)
- specifying storage properties for (846)
Batch processing (JDBC) (1140), (1141), (1142)
BETWEEN boolean operator (1046)
BIGINT data type (994)
BIGINT function (903)
BLOB data type (995), (1135)
Boolean expression (1036)
Boolean operators
- part of WHERE clause (1037)
bootPassword=key (database connection URL attribute) (1179)
Byte strings
- variable-length (1014)

call (JDBC escape keyword) (1155)
CALL (PROCEDURE) (822)
CASE expression (911)
Case sensitivity of keywords and identifiers (723)
CAST expression (1020)
CAST function (904)
CHAR data type (996)
CHAR FOR BIT DATA type (997)
CHAR function (907)
Character expressions (1027)
Check constraints (849)
Class path
- accessing read-only databases from (1087)
CLOB data type (998), (1136)
Column defaults (788)
Column-level constraints (826)
- used in CREATE TABLE statement (830)
column-Name identifier (744)
Column reference expression (1016)
Column widths
- increasing (771)
Columns
- adding (757)
- modifying (767)
org.apache.derby.authentication.UserAuthenticator (1237)
org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource (1235)
org.apache.derby.jdbc.EmbeddedDataSource (1234)
org.apache.derby.jdbc.EmbeddedDriver (1233)
org.apache.derby.jdbc.EmbeddedXADataSource (1236)
org.apache.derby.tools.sysinfo (1232)
Comment delimiters within SQL (730)
Comparison boolean operators (1041)
Compressing tables (754)
Compressing Tables (957)
concat (JDBC scalar function) (1163)
Concatenation function (909)
- as expression (1029)
Conditional expression (1023)
Connecting to a database (using databaseName attribute) (1184)
Connection pooling (1210), (1227)
Connections
- garbage collection of (1092)
- session-severity exceptions closing (1093)
- system-severity exceptions closing (1094)
Constant expression (1017)
Constraint clause
- referential actions in (851)
CONSTRAINT clause (824)
constraint-Name identifier (747)
Constraints (825)
- adding (758)
- column-level (827), (831)
- compressing (760)
- differences between column-level and table-level (838)
- dropping (759)
- table-level (829), (835)
Conversions
- of SQL-92 data types using CAST (905)
- using CAST function (explicit) (906)
correlation-Name identifier (743)
COUNT(*) aggregate function (914)
COUNT aggregate function (912)
CREATE FUNCTION statement (774)
CREATE INDEX statement (776)
CREATE PROCEDURE statement (782)
CREATE SCHEMA statement (784)
CREATE TABLE statement (786)
CREATE TRIGGER statement (791)
create=true (database connection URL attribute) (1182)
CREATE VIEW statement (801)
createFrom=Path (database connection URL attribute) (1201)
CURRENT DATE function (915)
CURRENT_DATE function (916)
- as expression (1031)
CURRENT ISOLATION function (917)
CURRENT TIME function (920)
CURRENT_TIME function (921)
- as expression (1032)
CURRENT TIMESTAMP function (922)
CURRENT_TIMESTAMP function (923)
- expression (1033)
CURRENT_USER function (924)
cursor-Name identifier (748)
Cursors (857), (858)
- pre-fetching affecting (1116)
- scrolling insensitive (1139)

d (JDBC escape keyword) (1157)
Data encryption
- algorithms (1192)
- providers (1189)
Data sources (1224)
- creating a database for (1230)
- shutting down a database for (1231)
Data types
- modifying (763), (770)
Database connection URL (1084)
- attributes (1088)
- settable through Properties in connection call (1089)
- syntax in embedded mode (1085)
Database Manager limitations (1251)
DatabaseMetaData.getProcedureColumns (1100)
databaseName=nameOfDatabase (database connection URL attribute) (1183)
Databases
- encrypting (1181), (1187)
- territory (1195)
dataEncryption=true (database connection URL attribute) (1185)
DATE data type (999)
Date formats
- JDBC escape syntax for (1159)
DATE function (925)
DATE limitations (1247)
Date/time expressions (1030)
DAY function (926)
DECIMAL data type (1000)
DECLARE GLOBAL TEMPORARY TABLE statement (852)
Defaults (787)
- adding (761), (768)
- dropping (762), (769)
- setting (772)
DELETE statement (854)
delimited identifiers
- definition (738)
Dependencies
- internal tracking of (751)
DESC
- optional element of ORDER BY clause (875)
Descending indexes (777)
Dictionary objects
- definition (734)
DISTINCT
- qualifier in AVG function (902)
- qualifier in COUNT aggregate function (913)
DISTINCT clause
- part of SelectExpression (883)
Distributed transaction management (1214)
DOUBLE data type (1001)
DOUBLE function (927)
DOUBLE PRECISION data type (1002)
DROP FUNCTION statement (803)
DROP INDEX statement (805)
DROP PROCEDURE statement (806)
DROP SCHEMA statement (808)
DROP TABLE statement (810)
DROP TRIGGER statement (812)
DROP VIEW statement (814)
Dropping Constraints (766)
Dynamic parameter expression (1019)
Dynamic parameters (1050)

Encrypting databases (1180), (1186)
Encryption
- algorithms (1193)
- providers (1190)
encryptionAlgorithm=algorithm (database connection URL attribute) (1191)
encryptionProvider=providerName (database connection URL attribute) (1188)
escape (JDBC escape keyword) (1160)
Escape character
- for single-quotation mark (722)
Escape character for LIKE clauses (1161)
Escape syntax (JDBC) (1154)
EXISTS boolean operator (1048)
Export
- SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure (978)
- SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure (975)
Expression subquery (881)
Expressions
- hierarchy of (1034)
- in SQL language (1015)
- precedence of (1035)

FLOAT data type
- as alias for REAL or DOUBLE PRECISION (1003)
- java.sql type converted to DOUBLE PRECISION when retrieved (1129)
fn (JDBC escape keyword) (1162)
FOR UPDATE clause (856)
Foreign keys (841)
FROM clause (860)
FUNCTION
- Create (775)
Functions, built-in (894)

getAsciiStream (1119)
getBinaryStream (1121)
getUnicodeStream (1120)
getXXXStream requests (1117)
GROUP BY clause (861)

HAVING clause (862)
HOUR function (928)

Identifier length limitations (1241)
Identifiers
- definition (733)
Identity Column Attributes (789)
Identity columns
- and triggers (790)
Import
- SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure (984)
- SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure (981)
IN (? or dynamic) parameters (1051)
IN boolean operator (1047)
In-place updates (859)
index-Name identifier (746)
Indexes
- automatic creation of for primary key, unique, and foreign key constraints (781), (844)
- created in descending order (778)
- specifying page size for (779)
INNER JOIN expression (863)
INSERT statement (865)
INTEGER data type (1004)
INTEGER function (929)
Internationalization features
- territory (1197)
IS NOT NULL boolean operator (1043)
IS NULL boolean operator (1042)
ISOLATION (821)
Isolation levels
- setting via JDBC (1096)

J2EE (1206)
Java identifiers
- case sensitivity of within SQL (725)
java.sql.Blob (1133)
java.sql.CallableStatement (1112)
- and INOUT parameters (1114)
- and OUT parameters (1113)
java.sql.Clob (1134)
java.sql.Connection (1091)
java.sql.Connection.isReadOnly (1098)
java.sql.Connection.setReadOnly (1097)
java.sql.Connection.setTransactionIsolation (1095)
java.sql.DatabaseMetaData (1099)
java.sql.Driver (1078)
java.sql.Driver.getPropertyInfo (1090)
java.sql.DriverManager.getConnection (1082)
java.sql.ParameterMetaData (1145)
java.sql.PreparedStatement (1103)
java.sql.ResultSet (1115)
java.sql.ResultSetMetaData (1122)
java.sql.Savepoint (1146)
java.sql.SQLException (1123)
java.sql.SQLWarning (1125)
java.sql.Statement (1101)
java.sql.Types
- mapped to SQL types (1126)
java.transaction.xa package (1216)
JavaIdentifiers
- definition (736)
javax.sql.ConnectionPoolDataSource (1211), (1225)
javax.sql.DataSource (1209), (1223)
javax.sql package (1221)
javax.sql.PooledConnection (1212), (1226)
javax.sql.XAConnection (1228)
javax.sql.XADataSource (1229)
javax.sql.XAxxx interfaces (1215)
javax.transaction.xa.XAException (1220)
javax.transaction.xa.XAResource (1218)
javax.transaction.xa.Xid (1219)
JDBC 2.0
- standard extensions (1222)
JDBC 3.0
- Derby's support for (1143)
JDBC API
- Derby implementation of (1076)
JDBC driver
- loading (1079), (1080)
jdbc.drivers system property
- using to load driver (1081)
JDBC escape syntax (1153)
JDBC types
- mapped to SQL types (1127)
JNDI (1208)
JOIN operation (867)
JTA API (1217)

Keywords (1056)
- case insensitivity of (724)

LCASE or LOWER (function) (931)
LEFT OUTER JOIN expression (869)
LENGTH function (908), (1026)
LIKE
- escape character for (1045)
LIKE boolean operator (1044)
Limitations (1239)
- Database Manager (1250)
- DATE, TIME, and TIMESTAMP (1246)
- Identifier length (1240)
- Numeric (1242)
- String (1244)
locate (JDBC scalar function) (1166)
LOCATE function (930)
Lock escalation
- by user (872)
LOCK TABLE statement (870)
logDevice=logDirectoryPath (database connection URL attribute) (1198)
LONG VARCHAR data type (1005)
LONG VARCHAR FOR BIT DATA type (1006)
LONGVARBINARY (1130)
LONGVARCHAR (1131)
LTRIM (function) (932)

Mapping
- of SQL types to java.sql.Types (1132)
MAX aggregate function (933)
MIN aggregate function (934)
MINUTE function (935)
mod (JDBC scalar function) (1168)
MOD function (936)
MONTH function (937)

new-table-Name identifier (741)
NOT boolean operator (1040)
NULL
- not a data type (986)
NULL expression (1018)
NULLIF expression (910)
NUMERIC data type (1007)
Numeric data types (988)
- implicit conversion (990)
- promotion of in expressions (989)
Numeric expressions (1024)
Numeric limitations (1243)

oj (JDBC escape keyword) (1169)
ON clause
- part of INNER JOIN expression (864)
OR boolean operator (1039)
ORDER BY clause (873)
- affecting cursors (876)
- needed to guarantee order of results (886)
Outer joins (868)
- JDBC escape syntax for (1171)

password=userPassword (database connection URL attribute) (1199)
Precision
- of decimal arithmetic expressions (992)
Prepared statements
- tracking of dependencies (752)
- use of dynamic parameters in (1052)
Primary key constraints (839)
Primary keys
- adding (833), (837)
- creating (832), (836)
Procedure
- Create (783)

Quantified comparison boolean operator (1049)

Read-write VTIs
- and DELETES (855)
- and INSERTs (866)
REAL data type (1008)
Referential actions (850)
Referential integrity
- via foreign keys (842)
RENAME INDEX statement (816)
RENAME TABLE statement (817)
Reserved words (1055)
Resource manager
- Derby as in J2EE system (1207)
restoreFrom=Path (database connection URL attribute) (1202)
ResultSets
- errors in statement affecting creation of (1102)
RIGHT OUTER JOIN expression (879)
rollforwardRecovery=Path (database connection URL attribute) (1200)
RTRIM (function) (938)

Savepoints
- methods (1151)
- releasing (1150)
- setting and rollong back (1148)
- setting and rollong back to (1149)
Savepoints (JDBC) (1144), (1147)
Scalar subquery expression (1021)
ScalarSubquery (880)
Scale
- for decimal arithmetic (991)
- of decimal arithmetic expressions (993)
schema-Name identifier (739)
Schemas
- APP as default (1083)
- changing default for session (819), (919)
- creating (785)
- dropping (809)
Scroll insensitive cursors (JDBC) (1137)
Scrolling insensitive cursors (1138)
SECOND function (939)
Select expression (882)
SELECT statement (885)
SESSION_USER (function) (940)
Set functions (895)
SET ISOLATION statement (820)
SET SCHEMA statement (818), (918)
setAsciiStream (1108)
setBinaryStream (1106), (1107)
setUnicodeStream (1109)
setXXXStream requests (1104)
shutdown=true (database connection URL attribute) (1203)
Simple-column-Name identifier (745)
SMALL INTEGER data type (1009)
SMALLINT function (941)
Special characters
- escaping in SQL statements (721)
SQL-92
- features not supported by Derby (1058)
- features supported by Derby (1057)
SQL-92 data types
- supported by Derby (987)
SQL identifiers
- definition (732)
SQL92Identifiers
- definition (735)
- rules for (737)
SQLExceptions
- chaining (1075), (1124)
SQLState values (1074)
SQLState XJZZZ
- meaning of (1077)
SQRT (function) (942)
sqrt (JDBC scalar function) (1164)
Statements
- CALL (PROCEDURE) (823)
- DROP FUNCTION (804)
- DROP PROCEDURE (807)
Storage properties
- for indexes backing constraints (845)
Stream (1111)
Streaming columns
- as IN parameters to prepared statement (1105)
- retrieving from ResultSets using getXXXStream methods (1118)
String expressions
- with wildcards (1028)
String limitations (1245)
Strings
- delimited by single quotation marks within SQL statements (720)
SUBSTR (function) (943)
substring (JDBC scalar function) (1167)
Subsubprotocol
- part of database connection URL syntax (1086)
SUM aggregate function (944)
SYSALIASES system table (1059)
SYSCHECKS system table (1060)
SYSCOLUMNS system table (1061)
SYSCONGLOMERATES system table (1062)
SYSCONSTRAINTS system table (1063)
SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure (973)
SYSCS_UTIL.SYSCS_CHECK_TABLE function (951)
SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure (971)
SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure (959)
SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure (979)
SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure (976)
SYSCS_UTIL.SYSCS_FREEZE_DATABASE system procedure (967)
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function (955)
SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS function (953)
SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure (985)
SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure (982)
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure (965)
SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure (961)
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure (963)
SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure (969)
SYSDEPENDS system table (1064)
SYSFILES system table (1065)
SYSFOREIGNKEYS system table (1066)
SYSKEYS system table (1067)
SYSSCHEMAS system table (1068)
SYSSTATEMENTS system table (1070)
SYSSTATISTICS system table (1069)
SYSTABLES system table (1071)
system functions
- SYSCS_UTIL.SYSCS_CHECK_TABLE (952)
- SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY (956)
- SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS (954)
System procedures
- SYSCS_UTIL.SYSCS_BACKUP_DATABASE (972)
- SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE (970)
- SYSCS_UTIL.SYSCS_COMPRESS_TABLE (958)
- SYSCS_UTIL.SYSCS_EXPORT_QUERY (977)
- SYSCS_UTIL.SYSCS_EXPORT_TABLE (974)
- SYSCS_UTIL.SYSCS_FREEZE_DATABASE (966)
- SYSCS_UTIL.SYSCS_IMPORT_DATA (983)
- SYSCS_UTIL.SYSCS_IMPORT_TABLE (980)
- SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY (964)
- SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS (960)
- SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING (962)
- SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE (968)
SYSTRIGGERS system table (1072)
SYSVIEWS system table (1073)

t (JDBC escape keyword) (1172)
Table constraints
- used in CREATE TABLE statement (834)
Table-level constraints (828)
table-Name identifier (740)
Table subquery expression (1022)
TableExpression (887)
Tables
- altering (755)
- changing lock granularity for (773)
- compressing (756)
- dropping (811)
- locking (871)
- specifying page size for (847)
- specifying properties for (848)
- Temporary (853)
TableSubquery (888)
Territories
- supported (1238)
territory
- database (1196)
territory=ll_CC (database connection URL attribute) (1194)
TIME data type (1010)
Time formats
- JDBC escape syntax for (1174)
TIME function (945)
TIME limitations (1248)
TIMESTAMP data type (1011)
Timestamp formats
- JDBC escape syntax for (1177)
TIMESTAMP function (946)
TIMESTAMP limitations (1249)
TriggerName identifier (749)
Triggers
- and database events (794)
- and recursion (800)
- and the referencing clause (795)
- creating (792)
- defining when they fire (793)
- dropping (813)
- order of execution (799)
- referencing old and new values (796)
- statement versus row triggers (797)
- the triggered-SQL-statement (798)
ts (JDBC escape keyword) (1175)
Type correspondence
- for JDBC and SQL types (1128)

Unicode
- setUnicodeStream (1110)
Unicode escapes
- support for in SQL statements (719)
UNION (877)
UNION ALL (878)
Unique constraints (840)
UPDATE statement (889)
UPPER function (947)
USER function (948)
user=userName (database connection URL attribute) (1204)

VALUES expression (890)
VARCHAR data type (1012)
VARCHAR FOR BIT DATA type (1013)
VARCHAR function (949)
view-Name identifier (742)
Views
- creating (802)
- dropping (815)

WHERE clause (891)
- SQL extensions to (892)
WHERE CURRENT OF clause (893)
Wildcards in SQL (729)

XA (1213)

YEAR function (950)

Previous Page
Table of Contents
Index