Java DB

-Rules for SQL92 identifiers
-SQL92Identifier
-column-Name
-correlation-Name
-new-table-Name
-schemaName
-Simple-column-Name
-synonym-Name
-table-Name
-view-Name
-index-Name
-constraint-Name
-cursor-Name
-TriggerName
-
-RoleName
-Interaction with the dependency system
-ALTER TABLE
-CALL (PROCEDURE)
-CREATE statements
-DECLARE GLOBAL TEMPORARY TABLE
-DELETE
-DROP statements
-GRANT
-INSERT
-LOCK TABLE
-RENAME statements
-REVOKE
-SET statements
-SELECT
-UPDATE

-CONSTRAINT clause
-FOR UPDATE clause
-FROM clause
-GROUP BY clause
-HAVING clause
-ORDER BY clause
-The result offset and fetch first clauses
-USING clause
-WHERE clause
-WHERE CURRENT OF clause

-SelectExpression
-TableExpression
-NEXT VALUE FOR expression
-VALUES expression
-Expression precedence
-Boolean expressions
-Dynamic parameters

-INNER JOIN operation
-LEFT OUTER JOIN operation
-RIGHT OUTER JOIN operation
-CROSS JOIN operation
-NATURAL JOIN operation

-Query
-ScalarSubquery
-TableSubquery

-Standard built-in functions
-Aggregates (set functions)
-ABS or ABSVAL function
-ACOS function
-ASIN function
-ATAN function
-ATAN2 function
-AVG function
-BIGINT function
-CASE expressions
-CAST function
-CEIL or CEILING function
-CHAR function
-COALESCE function
-Concatenation operator
-COS function
-COSH function
-COT function
-COUNT function
-COUNT(*) function
-CURRENT DATE function
-CURRENT_DATE function
-CURRENT ISOLATION function
-CURRENT_ROLE function
-CURRENT SCHEMA function
-CURRENT TIME function
-CURRENT_TIME function
-CURRENT TIMESTAMP function
-CURRENT_TIMESTAMP function
-CURRENT_USER function
-DATE function
-DAY function
-DEGREES function
-DOUBLE function
-EXP function
-FLOOR function
-HOUR function
-IDENTITY_VAL_LOCAL function
-INTEGER function
-LCASE or LOWER function
-LENGTH function
-LN or LOG function
-LOG10 function
-LOCATE function
-LTRIM function
-MAX function
-MIN function
-MINUTE function
-MOD function
-MONTH function
-NULLIF expressions
-PI function
-RADIANS function
-RANDOM function
-RAND function
-ROW_NUMBER function
-RTRIM function
-SECOND function
-SESSION_USER function
-SIGN function
-SIN function
-SINH function
-SMALLINT function
-SQRT function
-SUBSTR function
-SUM function
-TAN function
-TANH function
-TIME function
-TIMESTAMP function
-TRIM function
-UCASE or UPPER function
-USER function
-VARCHAR function
-XMLEXISTS operator
-XMLPARSE operator
-XMLQUERY operator
-XMLSERIALIZE operator
-YEAR function

-SYSCS_CHECK_TABLE
-SYSCS_GET _DATABASE _PROPERTY
-SYSCS_GET _RUNTIMES TATISTICS
-SYSCS_G ET_USER _ACCESS
-SYSCS_G ET_XPLA IN_MODE
-SYSCS_G ET_XPLA N_SCHEMA

-SYSCS_B ACKUP_D ATABASE
-SYSCS_BAC KUP_DATAB ASE_NOWAIT
-SYSCS_BACKUP_DAT ABASE_AND_ENABLE _LOG_ARCHIVE_MODE
-SYSCS_BACKUP_DATAB ASE_AND_ENABLE_LOG ARCHIVE_MODE_NOWAIT
-SYSCS_EMP TY_STATEM ENT_CACHE
-SYSCS_CH ECKPOINT _DATABASE
-SYSCS_COMPRESS_TABLE
-SYSCS_INP LACE_COMP RESS_TABLE
-SYSCS_DISA BLE_LOG_AR CHIVE_MODE
-SYSCS_EXPORT_TABLE
-SYSCS_EXPOR T_TABLE_LOB S_TO_EXTFILE
-SYSCS_EXPORT_QUERY
-SYSCS_EXPOR T_QUERY_LOB S_TO_EXTFILE
-SYSCS_IMPORT_DATA
-SYSCS_IMPOR T_DATA_LOBS FROM_EXTFILE
-SYSCS_IMPORT_TABLE
-SYSCS_IMPORT _TABLE_LOBS_ FROM_EXTFILE
-SYSCS_F REEZE_D ATABASE
-SYSCS_U NFREEZE DATABASE
-SYSCS_REL OAD_SECUR ITY_POLICY
-SYSCS_SET _DATABASE _PROPERTY
-SYSCS_SET _RUNTIMES TATISTICS
-SYSCS_SET _STATISTI CS_TIMING
-SYSCS_S ET_XPLA N_SCHEMA
-SYSCS_S ET_XPLA IN_MODE
-SYSCS_S ET_USER _ACCESS
-SYSCS_U PDATE_S ATISTICS

-Built-In type overview
-Numeric types
-Data type assignments and comparison, sorting, and ordering Part 2
-BIGINT data type
-BLOB data type
-CHAR data type
-CHAR FOR BIT DATA data type
-CLOB data type
-DATE data type
-DECIMAL data type
-DOUBLE data type
-DOUBLE PRECISION data type
-FLOAT data type
-INTEGER data type
-LONG VARCHAR data type
-LONG VARCHAR FOR BIT DATA data type
-NUMERIC data type
-REAL data type
-SMALLINT data type
-TIME data type
-TIMESTAMP data type
-User-defined types
-VARCHAR data type
-VARCHAR FOR BIT DATA data type
-XML data type

-java. sql. Driver. getPropertyInfo method

-Derby database connection URL syntax
-Syntax of database connection URLs for applications with embedded databases
-Additional SQL syntax
-Attributes of the Derby database connection URL

-java. sql. Connection. setTransactionIsolation method
-java. sql. Connection. setReadOnly method
-java. sql. Connection. isReadOnly method
-Connection functionality not supported

-DatabaseMetaData result sets
-java. sql. DatabaseMetaData. getProcedureColumns method
-Parameters to getProcedureColumns
-Columns in the ResultSet returned by getProcedureColumns
-java. sql. DatabaseMetaData. getBestRowIdentifier method

-ResultSet objects
-Autogenerated keys

-CallableStatements and OUT Parameters
-CallableStatements and INOUT Parameters

-Prepared statements and streaming columns

-ResultSets and streaming columns

-Mapping of java. sql. Blob and java. sql. Clob interfaces

-Refined subclasses of SQLException
-java. sql. Connection interface: JDBC 4. 0 features
-java. sql. DatabaseMetaData interface: JDBC 4. 0 features
-java. sql. Statement interface: JDBC 4. 0 features
-javax. sql. DataSource interface: JDBC 4. 0 features
-java.sql.SQLXML interface
-JDBC escape keyword for call statements
-JDBC escape syntax
-JDBC escape syntax for LIKE clauses
-JDBC escape syntax for fn keyword
-JDBC escape syntax for outer joins
-JDBC escape syntax for time formats
-JDBC escape syntax for date formats
-JDBC escape syntax for timestamp formats

-derby. authentication. builtin. algorithm
-derby. authentication. ldap. searchAuthDN
-derby. authentication. ldap. searchAuthPW
-derby. authentication. ldap. searchBase
-derby. authentication. ldap. searchFilter
-
-
-derby. connection. requireAuthentication
-derby. database. defaultConnectionMode
-derby. database. forceDatabaseLock
-
-
-
-derby. database. readOnlyAccessUsers
-derby. database. sqlAuthorization
-derby.infolog.append
-derby. jdbc. xaTransactionTimeout
-
-derby. language. logStatementText
-
-
-derby. locks. escalationThreshold
-derby.locks.monitor
-
-derby. replication. logBufferSize
-derby. replication. maxLogShippingInterval
-derby. replication. minLogShippingInterval
-
-
-derby. storage. minimumRecordSize
-
-derby. storage. pageReservedSpace
-
-
-
-
-
-
-derby. stream. error. logSeverityLevel
-derby.system.bootAll
-
-derby.system.home
-derby.user.UserName

-Notes on Product Behavior

-JDBC driver
-Data Source Classes