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
|