SQL Query Results
JDBC Driver and Connection Statistics:
Current date and time: Thu Jan 15 21:15:16 EST 1998
Connection URL: jdbc:odbc:employee
Driver: JDBC-ODBC Bridge (odbcjt32.dll)
Version: 1.2001 (03.50.3907.00)
Current User Name: admin
Driver Major Version: 1
Driver Minor Version: 2001
Database Product Name: ACCESS
Database Product Version: 3.5 Jet
Capabilities of the Database:
allProceduresAreCallable: true
allTablesAreSelectable: true
isReadOnly: false
nullsAreSortedHigh: false
nullsAreSortedLow: true
nullsAreSortedAtStart: false
nullsAreSortedAtEnd: false
usesLocalFiles: true
usesLocalFilePerTable: false
supportsMixedCaseIdentifiers: false
storesUpperCaseIdentifiers: false
storesLowerCaseIdentifiers: false
storesMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: true
storesUpperCaseQuotedIdentifiers: false
storesLowerCaseQuotedIdentifiers: false
storesMixedCaseQuotedIdentifiers: true
getIdentifierQuoteString: `
getSQLKeywords: ALPHANUMERIC,AUTOINCREMENT,BINARY,BYTE,COUNTER,CURRENCY,DATABASE,DATABASENAME,DATETIME,DISALLOW,DISTINCTROW,DOUBLEFLOAT,FLOAT4,FLOAT8,GENERAL,IEEEDOUBLE,IEEESINGLE,IGNORE,INT,INTEGER1,INTEGER2,INTEGER4,LEVEL,LOGICAL,LOGICAL1,LONG,LONGBINARY,LONGCHAR,LONGTEXT,MEMO,MONEY,NOTE,NUMBER,OLEOBJECT,OPTION,OWNERACCESS,PARAMETERS,PERCENT,PIVOT,SHORT,SINGLE,SINGLEFLOAT,SMALLINT,STDEV,STDEVP,STRING,TABLEID,TEXT,TOP,TRANSFORM,UNSIGNEDBYTE,VALUES,VAR,VARBINARY,VARP,YESNO
getNumericFunctions: ABS,ATAN,CEILING,COS,EXP,FLOOR,LOG,MOD,POWER,RAND,SIGN,SIN,SQRT,TAN
getStringFunctions: ASCII,CHAR,CONCAT,LCASE,LEFT,LENGTH,LOCATE,LOCATE_2,LTRIM,RIGHT,RTRIM,SPACE,SUBSTRING,UCASE
getSystemFunctions:
getTimeDateFunctions: CURDATE,CURTIME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,HOUR,MINUTE,MONTH,NOW,SECOND,WEEK,YEAR
getSearchStringEscape: \
getExtraNameCharacters: ~@#$%^&*_-+=\}{"';:?/><,
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: true
supportsColumnAliasing: true
nullPlusNonNullIsNull: false
supportsConvert: true
supportsTableCorrelationNames: true
supportsDifferentTableCorrelationNames: false
supportsExpressionsInOrderBy: true
supportsOrderByUnrelated: false
supportsGroupBy: true
supportsGroupByUnrelated: false
supportsGroupByBeyondSelect: true
supportsLikeEscapeClause: false
supportsMultipleResultSets: false
supportsMultipleTransactions: true
supportsNonNullableColumns: false
supportsMinimumSQLGrammar: true
supportsCoreSQLGrammar: false
supportsExtendedSQLGrammar: false
supportsANSI92EntryLevelSQL: true
supportsANSI92IntermediateSQL: false
supportsANSI92FullSQL: false
supportsIntegrityEnhancementFacility: false
supportsOuterJoins: true
supportsFullOuterJoins: false
supportsLimitedOuterJoins: false
getSchemaTerm:
getProcedureTerm: QUERY
getCatalogTerm: DATABASE
isCatalogAtStart: true
getCatalogSeparator: .
supportsSchemasInDataManipulation: false
supportsSchemasInProcedureCalls: false
supportsSchemasInTableDefinitions: false
supportsSchemasInIndexDefinitions: false
supportsSchemasInPrivilegeDefinitions: false
supportsCatalogsInDataManipulation: true
supportsCatalogsInProcedureCalls: false
supportsCatalogsInTableDefinitions: true
supportsCatalogsInIndexDefinitions: true
supportsCatalogsInPrivilegeDefinitions: false
supportsPositionedDelete: false
supportsPositionedUpdate: false
supportsSelectForUpdate: false
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsCorrelatedSubqueries: true
supportsUnion: true
supportsUnionAll: true
supportsOpenCursorsAcrossCommit: false
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: true
supportsOpenStatementsAcrossRollback: true
getMaxBinaryLiteralLength: 255
getMaxCharLiteralLength: 255
getMaxColumnNameLength: 64
getMaxColumnsInGroupBy: 10
getMaxColumnsInIndex: 10
getMaxColumnsInOrderBy: 10
getMaxColumnsInSelect: 255
getMaxColumnsInTable: 255
getMaxConnections: 64
getMaxCursorNameLength: 64
getMaxIndexLength: 255
getMaxSchemaNameLength: 0
getMaxProcedureNameLength: 64
getMaxCatalogNameLength: 64
getMaxRowSize: 2096
doesMaxRowSizeIncludeBlobs: false
getMaxStatementLength: 65000
getMaxStatements: 0
getMaxTableNameLength: 64
getMaxTablesInSelect: 16
getMaxUserNameLength: 0
getDefaultTransactionIsolation: 2
supportsTransactions: true
supportsDataDefinitionAndDataManipulationTransactions: true
supportsDataManipulationTransactionsOnly: false
dataDefinitionCausesTransactionCommit: true
dataDefinitionIgnoredInTransactions: false
SQL PROCESSED: select * from employee where status = 'SICK' and department = 'FINANCE' and region = 'TORONTO'
FIRSTNAME
| LASTNAME
| LOCATION
| EXTENSION
| STATUS
| DEPARTMENT
| REGION
|
TRACY
| MEETING ROOM
| 015
| 2360
| SICK
| FINANCE
| TORONTO
|
TRACY
| MDR
| 016
| 2311
| SICK
| FINANCE
| TORONTO
|
TAI
| D'SYLVA
| 002
| 1429
| SICK
| FINANCE
| TORONTO
|
TRUDY
| ROSE
| 015
| 2752
| SICK
| FINANCE
| TORONTO
|
RITA
| LAWRENCE
| 009
| 1912
| SICK
| FINANCE
| TORONTO
|
MAHESH
| MACKAY
| 006
| 2045
| SICK
| FINANCE
| TORONTO
|
RENATO
| SINNARAJAH
| 013
| 2885
| SICK
| FINANCE
| TORONTO
|
MDR
| MAIL
| 004
| 2094
| SICK
| FINANCE
| TORONTO
|
JACQUE
| TANG
| 015
| 3109
| SICK
| FINANCE
| TORONTO
|
KAN
| AREA
| 007
| 891
| SICK
| FINANCE
| TORONTO
|
ELIZABETH
| TYL
| 007
| 3151
| SICK
| FINANCE
| TORONTO
|