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

SQL Gateway Servlet Logon Form

Enter additional SQL here: