SQL Query Results


JDBC Driver and Connection Statistics:

Current date and time: Thu Jan 15 21:13:14 EST 1998
Connection URL: jdbc:odbc:sampledbase
Driver: JDBC-ODBC Bridge (IBDBF08.DLL)
Version: 1.2001 (02.11.0000)
Current User Name:
Driver Major Version: 1
Driver Minor Version: 2001
Database Product Name: dBASE V
Database Product Version: 05.00.0000 dBASE V

Capabilities of the Database:


allProceduresAreCallable: false
allTablesAreSelectable: true
isReadOnly: false
nullsAreSortedHigh: false
nullsAreSortedLow: true
nullsAreSortedAtStart: false
nullsAreSortedAtEnd: false
usesLocalFiles: false
usesLocalFilePerTable: true
supportsMixedCaseIdentifiers: true
storesUpperCaseIdentifiers: true
storesLowerCaseIdentifiers: false
storesMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: false
storesUpperCaseQuotedIdentifiers: false
storesLowerCaseQuotedIdentifiers: false
storesMixedCaseQuotedIdentifiers: false
getIdentifierQuoteString: `
getSQLKeywords:
getNumericFunctions: FLOOR,MOD,POWER,ROUND
getStringFunctions: CHAR,CONCAT,LCASE,LEFT,LENGTH,LTRIM,RIGHT,RTRIM,SPACE,SUBSTRING,UCASE
getSystemFunctions: IFNULL,USERNAME
getTimeDateFunctions: CURDATE,DAYOFMONTH,DAYOFWEEK,MONTH,YEAR
getSearchStringEscape: ~
getExtraNameCharacters: ~@#$%^&*_-+=\}{;:?/><,.![]
supportsAlterTableWithAddColumn: false
supportsAlterTableWithDropColumn: false
supportsColumnAliasing: false
nullPlusNonNullIsNull: false
supportsConvert: false
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:
getCatalogTerm: Directory
isCatalogAtStart: true
getCatalogSeparator: \
supportsSchemasInDataManipulation: false
supportsSchemasInProcedureCalls: false
supportsSchemasInTableDefinitions: false
supportsSchemasInIndexDefinitions: false
supportsSchemasInPrivilegeDefinitions: false
supportsCatalogsInDataManipulation: true
supportsCatalogsInProcedureCalls: false
supportsCatalogsInTableDefinitions: true
supportsCatalogsInIndexDefinitions: true
supportsCatalogsInPrivilegeDefinitions: false
supportsPositionedDelete: true
supportsPositionedUpdate: true
supportsSelectForUpdate: true
supportsStoredProcedures: false
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsCorrelatedSubqueries: true
supportsUnion: true
supportsUnionAll: true
supportsOpenCursorsAcrossCommit: true
supportsOpenCursorsAcrossRollback: true
supportsOpenStatementsAcrossCommit: true
supportsOpenStatementsAcrossRollback: true
getMaxBinaryLiteralLength: 0
getMaxCharLiteralLength: 0
getMaxColumnNameLength: 10
getMaxColumnsInGroupBy: 0
getMaxColumnsInIndex: 0
getMaxColumnsInOrderBy: 0
getMaxColumnsInSelect: 0
getMaxColumnsInTable: 1024
getMaxConnections: 0
getMaxCursorNameLength: 18
getMaxIndexLength: 100
getMaxSchemaNameLength: 0
getMaxProcedureNameLength: 0
getMaxCatalogNameLength: 249
getMaxRowSize: 32767
doesMaxRowSizeIncludeBlobs: false
getMaxStatementLength: 0
getMaxStatements: 0
getMaxTableNameLength: 128
getMaxTablesInSelect: 0
getMaxUserNameLength: 0
getDefaultTransactionIsolation: 2
supportsTransactions: true
supportsDataDefinitionAndDataManipulationTransactions: false
supportsDataManipulationTransactionsOnly: true
dataDefinitionCausesTransactionCommit: true
dataDefinitionIgnoredInTransactions: false


SQL PROCESSED:
select * from employee where salary > 25000.00

EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
000010 CHRISTINE I HAAS A00 3978 1965-01-01 PRES 18 F 1933-08-24 52750.00 1000.00 4220.00
000020 MICHAEL L THOMPSON B01 3476 1973-10-10 MANAGER 18 M 1948-02-02 41250.00 800.00 3300.00
000030 SALLY A KWAN C01 4738 1975-04-05 MANAGER 20 F 1941-05-11 38250.00 800.00 3060.00
000050 JOHN B GEYER E01 6789 1949-08-17 MANAGER 16 M 1925-09-15 40175.00 800.00 3214.00
000060 IRVING F STERN D11 6423 1973-09-14 MANAGER 16 M 1945-07-07 32250.00 500.00 2580.00
000070 EVA D PULASKI D21 7831 1980-09-30 MANAGER 16 F 1953-05-26 36170.00 700.00 2893.00
000090 EILEEN W HENDERSON E11 5498 1970-08-15 MANAGER 16 F 1941-05-15 29750.00 600.00 2380.00
000100 THEODORE Q SPENSER E21 0972 1980-06-19 MANAGER 14 M 1956-12-18 26150.00 500.00 2092.00
000110 VINCENZO G LUCCHESSI A00 3490 1958-05-16 SALESREP 19 M 1929-11-05 46500.00 900.00 3720.00
000120 SEAN null O'CONNELL A00 2167 1963-12-05 CLERK 14 M 1942-10-18 29250.00 600.00 2340.00
000140 HEATHER A NICHOLLS C01 1793 1976-12-15 ANALYST 18 F 1946-01-19 28420.00 600.00 2274.00
000150 BRUCE null ADAMSON D11 4510 1972-02-12 DESIGNER 16 M 1947-05-17 25280.00 500.00 2022.00
000200 DAVID null BROWN D11 4501 1966-03-03 DESIGNER 16 M 1941-05-29 27740.00 600.00 2217.00
000220 JENNIFER K LUTZ D11 0672 1968-08-29 DESIGNER 18 F 1948-03-19 29840.00 600.00 2387.00
000240 SALVATORE M MARINO D21 3780 1979-12-05 CLERK 17 M 1954-03-31 28760.00 600.00 2301.00
000270 MARIA L PEREZ D21 9001 1980-09-30 CLERK 15 F 1953-05-26 27380.00 500.00 2190.00
000280 ETHEL R SCHNEIDER E11 8997 1967-03-24 OPERATOR 17 F 1936-03-28 26250.00 500.00 2100.00
000330 WING null LEE E21 2103 1976-02-23 FIELDREP 14 M 1941-07-18 25370.00 500.00 2030.00

SQL Gateway Servlet Logon Form

Enter additional SQL here: