Table Of Content

Derby Reference Manual Version10 DerbyDocumentbuild: December11,2006,7:09:24AM(PST) Copyright Contents Copyright...............................................................................................................................8 Aboutthisguide...................................................................................................................9 Purposeofthisdocument........................................................................................9 Audience....................................................................................................................9 Howthisguideisorganized.....................................................................................9 SQLlanguagereference....................................................................................................10 Capitalizationandspecialcharacters...................................................................10 SQLidentifiers........................................................................................................10 RulesforSQL92identifiers.................................................................................11 SQL92Identifier...................................................................................................11 column-Name......................................................................................................12 correlation-Name................................................................................................12 new-table-Name..................................................................................................12 schemaName......................................................................................................13 Simple-column-Name.........................................................................................13 synonym-Name...................................................................................................13 table-Name.........................................................................................................14 view-Name..........................................................................................................14 index-Name.........................................................................................................14 constraint-Name..................................................................................................14 cursor-Name.......................................................................................................15 TriggerName.......................................................................................................15 AuthorizationIdentifier.........................................................................................15 Statements...............................................................................................................15 Interactionwiththedependencysystem.............................................................16 ALTERTABLEstatement...................................................................................17 CREATEstatements...........................................................................................20 DROPStatements..............................................................................................33 GRANTstatement..............................................................................................36 RENAMEstatements..........................................................................................37 REVOKEstatement...........................................................................................38 SETstatements..................................................................................................41 CALL(PROCEDURE).........................................................................................42 CONSTRAINTclause.........................................................................................43 DECLAREGLOBALTEMPORARYTABLEstatement.......................................49 DELETEstatement.............................................................................................51 FORUPDATEclause.........................................................................................52 FROMclause......................................................................................................52 GROUPBYclause..............................................................................................53 HAVINGclause...................................................................................................53 INNERJOIN.......................................................................................................54 INSERTstatement..............................................................................................55 JOINoperation....................................................................................................56 LEFTOUTERJOIN............................................................................................56 LOCKTABLEstatement.....................................................................................57 ORDERBYclause..............................................................................................58 Query..................................................................................................................59 RIGHTOUTERJOIN..........................................................................................60 ScalarSubquery..................................................................................................61 SelectExpression................................................................................................62 SELECTstatement.............................................................................................64 TableExpression.................................................................................................65 TableSubquery....................................................................................................66 UPDATEstatement.............................................................................................67 VALUESexpression...........................................................................................68 WHEREclause...................................................................................................69 i Copyright WHERECURRENTOFclause...........................................................................70 Built-infunctions.....................................................................................................70 Standardbuilt-infunctions..................................................................................70 Aggregates(setfunctions)..................................................................................71 ABSorABSVAL..................................................................................................72 ACOSfunction....................................................................................................72 ASINfunction......................................................................................................73 ATANfunction.....................................................................................................73 AVG....................................................................................................................73 BIGINT................................................................................................................74 CAST..................................................................................................................74 CEILorCEILINGfunction...................................................................................77 CHAR..................................................................................................................78 Concatenation.....................................................................................................79 COSfunction.......................................................................................................80 COUNT...............................................................................................................80 COUNT(*)...........................................................................................................81 CURRENTDATE................................................................................................81 CURRENT_DATE...............................................................................................81 CURRENTISOLATION......................................................................................81 CURRENTSCHEMA..........................................................................................81 CURRENTTIME.................................................................................................82 CURRENT_TIME................................................................................................82 CURRENTTIMESTAMP....................................................................................82 CURRENT_TIMESTAMP...................................................................................82 CURRENT_USER..............................................................................................83 DATE..................................................................................................................83 DAY.....................................................................................................................83 DEGREESfunction.............................................................................................84 DOUBLE.............................................................................................................84 EXPfunction.......................................................................................................85 FLOORfunction..................................................................................................85 HOUR.................................................................................................................85 IDENTITY_VAL_LOCAL.....................................................................................86 INTEGER............................................................................................................87 LCASEorLOWER..............................................................................................88 LENGTH.............................................................................................................88 LNorLOGfunction.............................................................................................88 LOG10function...................................................................................................89 LOCATE..............................................................................................................89 LTRIM.................................................................................................................89 MAX....................................................................................................................90 MIN.....................................................................................................................90 MINUTE..............................................................................................................91 MOD....................................................................................................................91 MONTH...............................................................................................................92 NULLIFandCASEexpressions..........................................................................92 PIfunction...........................................................................................................93 RADIANSfunction..............................................................................................93 RTRIM.................................................................................................................93 SECOND.............................................................................................................94 SESSION_USER................................................................................................94 SINfunction........................................................................................................94 SMALLINT..........................................................................................................95 SQRT..................................................................................................................95 SUBSTR.............................................................................................................96 TANfunction.......................................................................................................96 SUM....................................................................................................................97 TIME...................................................................................................................97 ii Copyright TIMESTAMP.......................................................................................................98 UCASEorUPPER..............................................................................................98 USER..................................................................................................................99 VARCHAR..........................................................................................................99 XMLEXISTSoperator.........................................................................................99 XMLPARSEoperator........................................................................................101 XMLQUERYoperator.......................................................................................102 XMLSERIALIZEoperator..................................................................................103 YEAR................................................................................................................105 Built-insystemfunctions......................................................................................105 SYSCS_UTIL.SYSCS_CHECK_TABLE...........................................................105 SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS......................................105 SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY..................................106 Built-insystemprocedures..................................................................................106 SYSCS_UTIL.SYSCS_COMPRESS_TABLE...................................................106 SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE.................................107 SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS.......................................109 SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING........................................109 SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY...................................110 SYSCS_UTIL.SYSCS_FREEZE_DATABASE.................................................110 SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE............................................111 SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE........................................111 SYSCS_UTIL.SYSCS_BACKUP_DATABASE.................................................111 SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT................................112 SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE113 SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT113 SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE.............................114 SYSCS_UTIL.SYSCS_EXPORT_TABLE.........................................................115 SYSCS_UTIL.SYSCS_EXPORT_QUERY.......................................................116 SYSCS_UTIL.SYSCS_IMPORT_TABLE.........................................................117 SYSCS_UTIL.SYSCS_IMPORT_DATA...........................................................118 Datatypes..............................................................................................................119 Built-Intypeoverview........................................................................................119 Numerictypes...................................................................................................119 Datatypeassignmentsandcomparison,sorting,andordering........................122 BIGINT..............................................................................................................125 BLOB................................................................................................................126 CHAR................................................................................................................126 CHARFORBITDATA......................................................................................127 CLOB................................................................................................................128 DATE................................................................................................................129 DECIMAL..........................................................................................................129 DOUBLE..........................................................................................................130 DOUBLEPRECISION......................................................................................130 FLOAT..............................................................................................................131 INTEGER..........................................................................................................132 LONGVARCHAR.............................................................................................132 LONGVARCHARFORBITDATA...................................................................133 NUMERIC.........................................................................................................133 REAL.................................................................................................................133 SMALLINT........................................................................................................134 TIME.................................................................................................................135 TIMESTAMP.....................................................................................................135 VARCHAR........................................................................................................136 VARCHARFORBITDATA...............................................................................136 XMLdatatype...................................................................................................137 SQLexpressions...................................................................................................138 iii Copyright Expressionprecedence....................................................................................140 Booleanexpression..........................................................................................140 Dynamicparameters.........................................................................................142 SQLreservedwords.........................................................................................................146 DerbysupportforSQL-92features................................................................................150 DerbySystemTables.......................................................................................................157 SYSALIASES..........................................................................................................157 SYSCHECKS..........................................................................................................157 SYSCOLPERMS.....................................................................................................158 SYSCOLUMNS.......................................................................................................158 SYSCONGLOMERATES........................................................................................159 SYSCONSTRAINTS...............................................................................................160 SYSDEPENDS........................................................................................................160 SYSFILES...............................................................................................................161 SYSFOREIGNKEYS...............................................................................................161 SYSKEYS...............................................................................................................162 SYSROUTINEPERMS............................................................................................162 SYSSCHEMAS.......................................................................................................163 SYSSTATISTICS....................................................................................................163 SYSSTATEMENTS.................................................................................................163 SYSTABLEPERMS................................................................................................164 SYSTABLES...........................................................................................................165 SYSTRIGGERS......................................................................................................165 SYSVIEWS..............................................................................................................166 DerbyexceptionmessagesandSQLstates..................................................................167 SQLerrormessagesandexceptions..................................................................167 JDBCReference................................................................................................................199 CoreJDBCjava.sqlClasses,Interfaces,andMethods......................................199 java.sql.Driver........................................................................................................199 java.sql.DriverManager.getConnection...............................................................200 DerbydatabaseconnectionURLsyntax...........................................................200 SyntaxofdatabaseconnectionURLsforapplicationswithembeddeddatabases ..........................................................................................................................201 AdditionalSQLsyntax.......................................................................................201 AttributesoftheDerbydatabaseconnectionURL...........................................201 java.sql.Driver.getPropertyInfo...........................................................................202 java.sql.Connection.............................................................................................203 java.sql.Connection.setTransactionIsolation....................................................203 java.sql.Connection.setReadOnly....................................................................203 java.sql.Connection.isReadOnly......................................................................203 Connectionfunctionalitynotsupported.............................................................203 java.sql.DatabaseMetaData.................................................................................204 DatabaseMetaDataresultsets..........................................................................204 getProcedureColumnsgetProcedureColumns..................................................204 ParameterstogetProcedureColumns...............................................................204 ColumnsintheResultSetreturnedbygetProcedureColumns.........................204 DatabaseMetaDatafunctionalitynotsupported................................................205 java.sql.Statement................................................................................................206 ResultSetobjects.............................................................................................206 java.sql.CallableStatement..................................................................................206 CallableStatementsandOUTParameters.......................................................207 CallableStatementsandINOUTParameters...................................................207 java.sql.SQLException.........................................................................................208 java.sql.PreparedStatement................................................................................208 Preparedstatementsandstreamingcolumns.................................................208 java.sql.ResultSet.................................................................................................210 ResultSetsandstreamingcolumns.................................................................210 java.sql.ResultSetMetaData.................................................................................211 java.sql.SQLWarning...........................................................................................211 iv Copyright java.sql.SQLXML...................................................................................................211 Mappingofjava.sql.TypestoSQLtypes.............................................................211 java.sql.Blobandjava.sql.Clob............................................................................212 Notes.................................................................................................................214 java.sql.Connection.............................................................................................214 java.sql.ResultSet..................................................................................................215 java.sql.Statement................................................................................................216 java.sql.PreparedStatement................................................................................216 java.sql.CallableStatement..................................................................................217 java.sql.DatabaseMetaData..................................................................................217 java.sql.ResultSetMetaData..................................................................................217 java.sql.BatchUpdateException...........................................................................217 JDBCPackageforConnectedDeviceConfiguration/FoundationProfile (JSR169).................................................................................................................217 JDBC3.0-onlyfeatures........................................................................................218 java.sql.Connection..........................................................................................218 java.sql.DatabaseMetaData.............................................................................218 java.sql.ParameterMetaData...........................................................................219 java.sql.PreparedStatement..............................................................................219 java.sql.Savepoint............................................................................................219 java.sql.Statement............................................................................................221 JDBC4.0-onlyfeatures........................................................................................221 RefinedsubclassesofSQLException...............................................................222 java.sql.Connection...........................................................................................222 java.sql.DatabaseMetaData..............................................................................222 java.sql.Statement............................................................................................223 javax.sql.DataSource........................................................................................223 JDBCescapesyntax............................................................................................223 JDBCescapekeywordforcallstatements.......................................................224 JDBCescapesyntax.........................................................................................224 JDBCescapesyntaxforLIKEclauses.............................................................224 JDBCescapesyntaxforfnkeyword.................................................................225 JDBCescapesyntaxforouterjoins..................................................................229 JDBCescapesyntaxfortimeformats...............................................................229 JDBCescapesyntaxfordateformats..............................................................229 JDBCescapesyntaxfortimestampformats.....................................................230 SettingattributesforthedatabaseconnectionURL....................................................231 bootPassword=key................................................................................................231 create=true.............................................................................................................231 createFrom=Path...................................................................................................232 databaseName=nameofDatabase........................................................................232 dataEncryption=true.............................................................................................233 encryptionKey=<key>...........................................................................................233 encryptionProvider=providerName.....................................................................233 encryptionAlgorithm=algorithm...........................................................................234 logDevice=logDirectoryPath................................................................................234 newEncryptionKey=<key>...................................................................................235 newBootPassword=<newpassword>...............................................................235 password=userPassword.....................................................................................235 restoreFrom=Path.................................................................................................236 rollForwardRecoveryFrom=Path..........................................................................236 shutdown=true.......................................................................................................236 territory=ll_CC.......................................................................................................237 user=userName.....................................................................................................238 (noattributes)........................................................................................................238 J2EECompliance:JavaTransactionAPIandjavax.sqlExtensions...........................239 JVMandlibrariesforJ2EEfeatures....................................................................239 TheJTAAPI..........................................................................................................240 NotesonProductBehavior...............................................................................240 v Copyright javax.sql:JDBCExtensions................................................................................240 DerbyAPI...........................................................................................................................242 Stand-alonetoolsandutilities.............................................................................242 JDBCimplementationclasses.............................................................................242 JDBCdriver.......................................................................................................242 DataSourceClasses........................................................................................242 Miscellaneousutilitiesandinterfaces.................................................................243 Supportedterritories.......................................................................................................244 Derbylimitations...............................................................................................................245 Limitationsfordatabasemanagervalues...........................................................245 DATE,TIME,andTIMESTAMPlimitations...........................................................245 Limitationsonidentifierlength...........................................................................246 Numericlimitations...............................................................................................246 Stringlimitations...................................................................................................247 XMLlimitations......................................................................................................247 Trademarks.......................................................................................................................248 vi Copyright ApacheSoftwareFoundationDerbyReferenceManualApacheDerby 7 Copyright Copyright Copyright2004,2006TheApacheSoftwareFoundationoritslicensors,asapplicable. LicensedtotheApacheSoftwareFoundation(ASF)underoneormorecontributor licenseagreements.SeetheNOTICEfiledistributedwiththisworkforadditional informationregardingcopyrightownership.TheASFlicensesthisfiletoyouunderthe ApacheLicense,Version2.0(the"License");youmaynotusethisfileexceptin compliancewiththeLicense.YoumayobtainacopyoftheLicenseat http://www.apache.org/licenses/LICENSE-2.0 Unlessrequiredbyapplicablelaworagreedtoinwriting,softwaredistributedunderthe Licenseisdistributedonan"ASIS"BASIS,WITHOUTWARRANTIESORCONDITIONS OFANYKIND,eitherexpressorimplied.SeetheLicenseforthespecificlanguage governingpermissionsandlimitationsundertheLicense. 8

Description:
Reference information about Derby's SQL language, including manual pages for statements, functions, and other syntax elements. • SQL reserved words
ebook img

Derby Reference Manual - Apache DB Project - Welcome! PDF

250 Pages·2011·0.99 MB·English
by  
Save to my drive
Quick download
Download
Upgrade Premium
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview Derby Reference Manual - Apache DB Project - Welcome!

Derby Reference Manual Version10 DerbyDocumentbuild: December11,2006,7:09:24AM(PST) Copyright Contents Copyright...............................................................................................................................8 Aboutthisguide...................................................................................................................9 Purposeofthisdocument........................................................................................9 Audience....................................................................................................................9 Howthisguideisorganized.....................................................................................9 SQLlanguagereference....................................................................................................10 Capitalizationandspecialcharacters...................................................................10 SQLidentifiers........................................................................................................10 RulesforSQL92identifiers.................................................................................11 SQL92Identifier...................................................................................................11 column-Name......................................................................................................12 correlation-Name................................................................................................12 new-table-Name..................................................................................................12 schemaName......................................................................................................13 Simple-column-Name.........................................................................................13 synonym-Name...................................................................................................13 table-Name.........................................................................................................14 view-Name..........................................................................................................14 index-Name.........................................................................................................14 constraint-Name..................................................................................................14 cursor-Name.......................................................................................................15 TriggerName.......................................................................................................15 AuthorizationIdentifier.........................................................................................15 Statements...............................................................................................................15 Interactionwiththedependencysystem.............................................................16 ALTERTABLEstatement...................................................................................17 CREATEstatements...........................................................................................20 DROPStatements..............................................................................................33 GRANTstatement..............................................................................................36 RENAMEstatements..........................................................................................37 REVOKEstatement...........................................................................................38 SETstatements..................................................................................................41 CALL(PROCEDURE).........................................................................................42 CONSTRAINTclause.........................................................................................43 DECLAREGLOBALTEMPORARYTABLEstatement.......................................49 DELETEstatement.............................................................................................51 FORUPDATEclause.........................................................................................52 FROMclause......................................................................................................52 GROUPBYclause..............................................................................................53 HAVINGclause...................................................................................................53 INNERJOIN.......................................................................................................54 INSERTstatement..............................................................................................55 JOINoperation....................................................................................................56 LEFTOUTERJOIN............................................................................................56 LOCKTABLEstatement.....................................................................................57 ORDERBYclause..............................................................................................58 Query..................................................................................................................59 RIGHTOUTERJOIN..........................................................................................60 ScalarSubquery..................................................................................................61 SelectExpression................................................................................................62 SELECTstatement.............................................................................................64 TableExpression.................................................................................................65 TableSubquery....................................................................................................66 UPDATEstatement.............................................................................................67 VALUESexpression...........................................................................................68 WHEREclause...................................................................................................69 i Copyright WHERECURRENTOFclause...........................................................................70 Built-infunctions.....................................................................................................70 Standardbuilt-infunctions..................................................................................70 Aggregates(setfunctions)..................................................................................71 ABSorABSVAL..................................................................................................72 ACOSfunction....................................................................................................72 ASINfunction......................................................................................................73 ATANfunction.....................................................................................................73 AVG....................................................................................................................73 BIGINT................................................................................................................74 CAST..................................................................................................................74 CEILorCEILINGfunction...................................................................................77 CHAR..................................................................................................................78 Concatenation.....................................................................................................79 COSfunction.......................................................................................................80 COUNT...............................................................................................................80 COUNT(*)...........................................................................................................81 CURRENTDATE................................................................................................81 CURRENT_DATE...............................................................................................81 CURRENTISOLATION......................................................................................81 CURRENTSCHEMA..........................................................................................81 CURRENTTIME.................................................................................................82 CURRENT_TIME................................................................................................82 CURRENTTIMESTAMP....................................................................................82 CURRENT_TIMESTAMP...................................................................................82 CURRENT_USER..............................................................................................83 DATE..................................................................................................................83 DAY.....................................................................................................................83 DEGREESfunction.............................................................................................84 DOUBLE.............................................................................................................84 EXPfunction.......................................................................................................85 FLOORfunction..................................................................................................85 HOUR.................................................................................................................85 IDENTITY_VAL_LOCAL.....................................................................................86 INTEGER............................................................................................................87 LCASEorLOWER..............................................................................................88 LENGTH.............................................................................................................88 LNorLOGfunction.............................................................................................88 LOG10function...................................................................................................89 LOCATE..............................................................................................................89 LTRIM.................................................................................................................89 MAX....................................................................................................................90 MIN.....................................................................................................................90 MINUTE..............................................................................................................91 MOD....................................................................................................................91 MONTH...............................................................................................................92 NULLIFandCASEexpressions..........................................................................92 PIfunction...........................................................................................................93 RADIANSfunction..............................................................................................93 RTRIM.................................................................................................................93 SECOND.............................................................................................................94 SESSION_USER................................................................................................94 SINfunction........................................................................................................94 SMALLINT..........................................................................................................95 SQRT..................................................................................................................95 SUBSTR.............................................................................................................96 TANfunction.......................................................................................................96 SUM....................................................................................................................97 TIME...................................................................................................................97 ii Copyright TIMESTAMP.......................................................................................................98 UCASEorUPPER..............................................................................................98 USER..................................................................................................................99 VARCHAR..........................................................................................................99 XMLEXISTSoperator.........................................................................................99 XMLPARSEoperator........................................................................................101 XMLQUERYoperator.......................................................................................102 XMLSERIALIZEoperator..................................................................................103 YEAR................................................................................................................105 Built-insystemfunctions......................................................................................105 SYSCS_UTIL.SYSCS_CHECK_TABLE...........................................................105 SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS......................................105 SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY..................................106 Built-insystemprocedures..................................................................................106 SYSCS_UTIL.SYSCS_COMPRESS_TABLE...................................................106 SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE.................................107 SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS.......................................109 SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING........................................109 SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY...................................110 SYSCS_UTIL.SYSCS_FREEZE_DATABASE.................................................110 SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE............................................111 SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE........................................111 SYSCS_UTIL.SYSCS_BACKUP_DATABASE.................................................111 SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT................................112 SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE113 SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT113 SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE.............................114 SYSCS_UTIL.SYSCS_EXPORT_TABLE.........................................................115 SYSCS_UTIL.SYSCS_EXPORT_QUERY.......................................................116 SYSCS_UTIL.SYSCS_IMPORT_TABLE.........................................................117 SYSCS_UTIL.SYSCS_IMPORT_DATA...........................................................118 Datatypes..............................................................................................................119 Built-Intypeoverview........................................................................................119 Numerictypes...................................................................................................119 Datatypeassignmentsandcomparison,sorting,andordering........................122 BIGINT..............................................................................................................125 BLOB................................................................................................................126 CHAR................................................................................................................126 CHARFORBITDATA......................................................................................127 CLOB................................................................................................................128 DATE................................................................................................................129 DECIMAL..........................................................................................................129 DOUBLE..........................................................................................................130 DOUBLEPRECISION......................................................................................130 FLOAT..............................................................................................................131 INTEGER..........................................................................................................132 LONGVARCHAR.............................................................................................132 LONGVARCHARFORBITDATA...................................................................133 NUMERIC.........................................................................................................133 REAL.................................................................................................................133 SMALLINT........................................................................................................134 TIME.................................................................................................................135 TIMESTAMP.....................................................................................................135 VARCHAR........................................................................................................136 VARCHARFORBITDATA...............................................................................136 XMLdatatype...................................................................................................137 SQLexpressions...................................................................................................138 iii Copyright Expressionprecedence....................................................................................140 Booleanexpression..........................................................................................140 Dynamicparameters.........................................................................................142 SQLreservedwords.........................................................................................................146 DerbysupportforSQL-92features................................................................................150 DerbySystemTables.......................................................................................................157 SYSALIASES..........................................................................................................157 SYSCHECKS..........................................................................................................157 SYSCOLPERMS.....................................................................................................158 SYSCOLUMNS.......................................................................................................158 SYSCONGLOMERATES........................................................................................159 SYSCONSTRAINTS...............................................................................................160 SYSDEPENDS........................................................................................................160 SYSFILES...............................................................................................................161 SYSFOREIGNKEYS...............................................................................................161 SYSKEYS...............................................................................................................162 SYSROUTINEPERMS............................................................................................162 SYSSCHEMAS.......................................................................................................163 SYSSTATISTICS....................................................................................................163 SYSSTATEMENTS.................................................................................................163 SYSTABLEPERMS................................................................................................164 SYSTABLES...........................................................................................................165 SYSTRIGGERS......................................................................................................165 SYSVIEWS..............................................................................................................166 DerbyexceptionmessagesandSQLstates..................................................................167 SQLerrormessagesandexceptions..................................................................167 JDBCReference................................................................................................................199 CoreJDBCjava.sqlClasses,Interfaces,andMethods......................................199 java.sql.Driver........................................................................................................199 java.sql.DriverManager.getConnection...............................................................200 DerbydatabaseconnectionURLsyntax...........................................................200 SyntaxofdatabaseconnectionURLsforapplicationswithembeddeddatabases ..........................................................................................................................201 AdditionalSQLsyntax.......................................................................................201 AttributesoftheDerbydatabaseconnectionURL...........................................201 java.sql.Driver.getPropertyInfo...........................................................................202 java.sql.Connection.............................................................................................203 java.sql.Connection.setTransactionIsolation....................................................203 java.sql.Connection.setReadOnly....................................................................203 java.sql.Connection.isReadOnly......................................................................203 Connectionfunctionalitynotsupported.............................................................203 java.sql.DatabaseMetaData.................................................................................204 DatabaseMetaDataresultsets..........................................................................204 getProcedureColumnsgetProcedureColumns..................................................204 ParameterstogetProcedureColumns...............................................................204 ColumnsintheResultSetreturnedbygetProcedureColumns.........................204 DatabaseMetaDatafunctionalitynotsupported................................................205 java.sql.Statement................................................................................................206 ResultSetobjects.............................................................................................206 java.sql.CallableStatement..................................................................................206 CallableStatementsandOUTParameters.......................................................207 CallableStatementsandINOUTParameters...................................................207 java.sql.SQLException.........................................................................................208 java.sql.PreparedStatement................................................................................208 Preparedstatementsandstreamingcolumns.................................................208 java.sql.ResultSet.................................................................................................210 ResultSetsandstreamingcolumns.................................................................210 java.sql.ResultSetMetaData.................................................................................211 java.sql.SQLWarning...........................................................................................211 iv Copyright java.sql.SQLXML...................................................................................................211 Mappingofjava.sql.TypestoSQLtypes.............................................................211 java.sql.Blobandjava.sql.Clob............................................................................212 Notes.................................................................................................................214 java.sql.Connection.............................................................................................214 java.sql.ResultSet..................................................................................................215 java.sql.Statement................................................................................................216 java.sql.PreparedStatement................................................................................216 java.sql.CallableStatement..................................................................................217 java.sql.DatabaseMetaData..................................................................................217 java.sql.ResultSetMetaData..................................................................................217 java.sql.BatchUpdateException...........................................................................217 JDBCPackageforConnectedDeviceConfiguration/FoundationProfile (JSR169).................................................................................................................217 JDBC3.0-onlyfeatures........................................................................................218 java.sql.Connection..........................................................................................218 java.sql.DatabaseMetaData.............................................................................218 java.sql.ParameterMetaData...........................................................................219 java.sql.PreparedStatement..............................................................................219 java.sql.Savepoint............................................................................................219 java.sql.Statement............................................................................................221 JDBC4.0-onlyfeatures........................................................................................221 RefinedsubclassesofSQLException...............................................................222 java.sql.Connection...........................................................................................222 java.sql.DatabaseMetaData..............................................................................222 java.sql.Statement............................................................................................223 javax.sql.DataSource........................................................................................223 JDBCescapesyntax............................................................................................223 JDBCescapekeywordforcallstatements.......................................................224 JDBCescapesyntax.........................................................................................224 JDBCescapesyntaxforLIKEclauses.............................................................224 JDBCescapesyntaxforfnkeyword.................................................................225 JDBCescapesyntaxforouterjoins..................................................................229 JDBCescapesyntaxfortimeformats...............................................................229 JDBCescapesyntaxfordateformats..............................................................229 JDBCescapesyntaxfortimestampformats.....................................................230 SettingattributesforthedatabaseconnectionURL....................................................231 bootPassword=key................................................................................................231 create=true.............................................................................................................231 createFrom=Path...................................................................................................232 databaseName=nameofDatabase........................................................................232 dataEncryption=true.............................................................................................233 encryptionKey=<key>...........................................................................................233 encryptionProvider=providerName.....................................................................233 encryptionAlgorithm=algorithm...........................................................................234 logDevice=logDirectoryPath................................................................................234 newEncryptionKey=<key>...................................................................................235 newBootPassword=<newpassword>...............................................................235 password=userPassword.....................................................................................235 restoreFrom=Path.................................................................................................236 rollForwardRecoveryFrom=Path..........................................................................236 shutdown=true.......................................................................................................236 territory=ll_CC.......................................................................................................237 user=userName.....................................................................................................238 (noattributes)........................................................................................................238 J2EECompliance:JavaTransactionAPIandjavax.sqlExtensions...........................239 JVMandlibrariesforJ2EEfeatures....................................................................239 TheJTAAPI..........................................................................................................240 NotesonProductBehavior...............................................................................240 v Copyright javax.sql:JDBCExtensions................................................................................240 DerbyAPI...........................................................................................................................242 Stand-alonetoolsandutilities.............................................................................242 JDBCimplementationclasses.............................................................................242 JDBCdriver.......................................................................................................242 DataSourceClasses........................................................................................242 Miscellaneousutilitiesandinterfaces.................................................................243 Supportedterritories.......................................................................................................244 Derbylimitations...............................................................................................................245 Limitationsfordatabasemanagervalues...........................................................245 DATE,TIME,andTIMESTAMPlimitations...........................................................245 Limitationsonidentifierlength...........................................................................246 Numericlimitations...............................................................................................246 Stringlimitations...................................................................................................247 XMLlimitations......................................................................................................247 Trademarks.......................................................................................................................248 vi Copyright ApacheSoftwareFoundationDerbyReferenceManualApacheDerby 7 Copyright Copyright Copyright2004,2006TheApacheSoftwareFoundationoritslicensors,asapplicable. LicensedtotheApacheSoftwareFoundation(ASF)underoneormorecontributor licenseagreements.SeetheNOTICEfiledistributedwiththisworkforadditional informationregardingcopyrightownership.TheASFlicensesthisfiletoyouunderthe ApacheLicense,Version2.0(the"License");youmaynotusethisfileexceptin compliancewiththeLicense.YoumayobtainacopyoftheLicenseat http://www.apache.org/licenses/LICENSE-2.0 Unlessrequiredbyapplicablelaworagreedtoinwriting,softwaredistributedunderthe Licenseisdistributedonan"ASIS"BASIS,WITHOUTWARRANTIESORCONDITIONS OFANYKIND,eitherexpressorimplied.SeetheLicenseforthespecificlanguage governingpermissionsandlimitationsundertheLicense. 8

Description:
Reference information about Derby's SQL language, including manual pages for statements, functions, and other syntax elements. • SQL reserved words
See more

The list of books you might like

Upgrade Premium
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.
DMCA & Copyright: Dear all, most of the website is community built, users are uploading hundred of books everyday, which makes really hard for us to identify copyrighted material, please contact us if you want any material removed.
Copyright @ PDFdrive.to, 2022 | We love our users