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

SQL Gateway Servlet Logon Form

Enter additional SQL here: