SQL Query Results
JDBC Driver and Connection Statistics:
Current date and time: Thu Jan 15 21:28:23 EST 1998
Connection URL: jdbc:db2:sample
Driver: DB2CLI.DLL
Version: 05.00.0000
Current User Name: SHELDON
Driver Major Version: 5
Driver Minor Version: 0
Database Product Name: DB2/NT
Database Product Version: 05.00.0000
Capabilities of the Database:
allProceduresAreCallable: false
allTablesAreSelectable: false
isReadOnly: false
nullsAreSortedHigh: true
nullsAreSortedLow: false
nullsAreSortedAtStart: false
nullsAreSortedAtEnd: false
usesLocalFiles: false
usesLocalFilePerTable: false
supportsMixedCaseIdentifiers: false
storesUpperCaseIdentifiers: true
storesLowerCaseIdentifiers: false
storesMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: true
storesUpperCaseQuotedIdentifiers: false
storesLowerCaseQuotedIdentifiers: false
storesMixedCaseQuotedIdentifiers: false
getIdentifierQuoteString: "
getSQLKeywords: CALL,COMMENT,CONCAT,DAYS,FREE,HOURS,LOCK,MAXFILES,MAXFILESIZE,MICROSECOND,MICROSECONDS,MINUTES,MONTHS,OLD,OPTIMIZE,SECONDS,YEARS
getNumericFunctions: ABS,ACOS,ASIN,ATAN,ATAN2,CEILING,COS,COT,EXP,FLOOR,LOG,MOD,SIGN,SIN,SQRT,TAN,PI,RAND,DEGREES,LOG10,POWER,RADIANS,ROUND,TRUNCATE
getStringFunctions: CONCAT,INSERT,LEFT,LTRIM,LENGTH,LOCATE,LCASE,REPEAT,REPLACE,RIGHT,RTRIM,SUBSTRING,UCASE,ASCII,CHAR,DIFFERENCE,LOCATE_2,SOUNDEX,SPACE
getSystemFunctions: USERNAME,DBNAME,IFNULL
getTimeDateFunctions: NOW,CURDATE,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,MONTH,QUARTER,WEEK,YEAR,CURTIME,HOUR,MINUTE,SECOND,TIMESTAMPADD,TIMESTAMPDIFF,DAYNAME,MONTHNAME
getSearchStringEscape: \
getExtraNameCharacters: @#
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: false
supportsColumnAliasing: true
nullPlusNonNullIsNull: true
supportsConvert: true
supportsTableCorrelationNames: true
supportsDifferentTableCorrelationNames: false
supportsExpressionsInOrderBy: true
supportsOrderByUnrelated: false
supportsGroupBy: true
supportsGroupByUnrelated: false
supportsGroupByBeyondSelect: true
supportsLikeEscapeClause: true
supportsMultipleResultSets: true
supportsMultipleTransactions: true
supportsNonNullableColumns: true
supportsMinimumSQLGrammar: false
supportsCoreSQLGrammar: false
supportsExtendedSQLGrammar: true
supportsANSI92EntryLevelSQL: true
supportsANSI92IntermediateSQL: false
supportsANSI92FullSQL: false
supportsIntegrityEnhancementFacility: true
supportsOuterJoins: true
supportsFullOuterJoins: false
supportsLimitedOuterJoins: true
getSchemaTerm: schema
getProcedureTerm: stored procedure
getCatalogTerm:
isCatalogAtStart: false
getCatalogSeparator:
supportsSchemasInDataManipulation: true
supportsSchemasInProcedureCalls: false
supportsSchemasInTableDefinitions: true
supportsSchemasInIndexDefinitions: true
supportsSchemasInPrivilegeDefinitions: true
supportsCatalogsInDataManipulation: false
supportsCatalogsInProcedureCalls: false
supportsCatalogsInTableDefinitions: false
supportsCatalogsInIndexDefinitions: false
supportsCatalogsInPrivilegeDefinitions: false
supportsPositionedDelete: true
supportsPositionedUpdate: true
supportsSelectForUpdate: true
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsCorrelatedSubqueries: true
supportsUnion: true
supportsUnionAll: true
supportsOpenCursorsAcrossCommit: true
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: true
supportsOpenStatementsAcrossRollback: true
getMaxBinaryLiteralLength: 4000
getMaxCharLiteralLength: 4000
getMaxColumnNameLength: 18
getMaxColumnsInGroupBy: 255
getMaxColumnsInIndex: 16
getMaxColumnsInOrderBy: 255
getMaxColumnsInSelect: 255
getMaxColumnsInTable: 255
getMaxConnections: 0
getMaxCursorNameLength: 18
getMaxIndexLength: 255
getMaxSchemaNameLength: 8
getMaxProcedureNameLength: 256
getMaxCatalogNameLength: 0
getMaxRowSize: 4005
doesMaxRowSizeIncludeBlobs: false
getMaxStatementLength: 4005
getMaxStatements: 0
getMaxTableNameLength: 18
getMaxTablesInSelect: 0
getMaxUserNameLength: 8
getDefaultTransactionIsolation: 2
supportsTransactions: true
supportsDataDefinitionAndDataManipulationTransactions: true
supportsDataManipulationTransactionsOnly: false
dataDefinitionCausesTransactionCommit: false
dataDefinitionIgnoredInTransactions: false
SQL PROCESSED: select empno,lastname,workdept,job,salary from employee where salary > 25000.00 order by salary
EMPNO
| LASTNAME
| WORKDEPT
| JOB
| SALARY
|
000150
| ADAMSON
| D11
| DESIGNER
| 25280.00
|
000330
| LEE
| E21
| FIELDREP
| 25370.00
|
000280
| SCHNEIDER
| E11
| OPERATOR
| 26250.00
|
000270
| PEREZ
| D21
| CLERK
| 27380.00
|
000200
| BROWN
| D11
| DESIGNER
| 27740.00
|
000140
| NICHOLLS
| C01
| ANALYST
| 28420.00
|
000240
| MARINO
| D21
| CLERK
| 28760.00
|
000120
| O'CONNELL
| A00
| CLERK
| 29250.00
|
000220
| LUTZ
| D11
| DESIGNER
| 29840.00
|
000110
| LUCCHESSI
| A00
| SALESREP
| 46500.00
|
000010
| HATHAWAY
| 846
| PRES
| 70000.00
|