1271 - Supported API Interfaces for HiT JDBC/400

Methods

Return Types

Supported

getBinaryStream()

InputStream

Yes

getBytes(long pos, int length)

byte[]

Yes

length()

long

Yes

position(Blob pattern, long start)

long

Yes

position(byte[] pattern, long start)

long

Yes

Methods

Return Types

Supported

getArray(int i)

Array

No

getBigDecimal(int parameterIndex)

BigDecimal

Yes

getBigDecimal(int parameterIndex, int scale)

BigDecimal

Yes

getBlob(int i)

Blob

No

getBoolean(int parameterIndex)

boolean

Yes

getByte(int parameterIndex)

byte

Yes

getBytes(int parameterIndex)

byte[]

Yes

getClob(int i)

Clob

No

getDate(int parameterIndex)

Date

Yes

getDate(int parameterIndex, Calendar cal)

Date

No

getDouble(int parameterIndex)

double

Yes

getFloat(int parameterIndex)

float

Yes

getInt(int parameterIndex)

int

Yes

getLong(int parameterIndex)

long

Yes

getObject(int parameterIndex)

Object

Yes

getObject(int i, Map map)

Object

No

getRef(int i)

Ref

No

getShort(int parameterIndex)

short

Yes

getString(int parameterIndex)

String

Yes

getTime(int parameterIndex)

Time

Yes

getTime(int parameterIndex, Calendar cal)

Time

Yes

getTimestamp(int parameterIndex)

Timestamp

Yes

getTimestamp(int parameterIndex, Calendar cal)

Timestamp

No

registerOutParameter(int parameterIndex, int sqlType)

void

Yes

registerOutParameter(int parameterIndex, int sqlType, int scale)

void

No

registerOutParameter(int paramIndex, int sqlType, String typeName)

void

No

wasNull()

boolean

Yes

Methods

Return Types

Supported

getAsciiStream()

InputStream

Yes

getCharacterStream()

Reader

Yes

getSubString(long pos, int length)

String

Yes

length()

long

Yes

position(Clob searchstr, long start)

long

Yes

position(String searchstr, long start)

long

Yes

Methods

Return Types

Supported

clearWarnings()

void

Yes

close()

void

Yes

commit()

void

Yes

createStatement()

Statement

Yes

createStatement(int resultSetType, int resultSetConcurrency)

Statement

Yes

getAutoCommit()

boolean

Yes

getCatalog()

String

Yes

getMetaData()

DatabaseMetaData

Yes

getTransactionIsolation()

int

Yes

getTypeMap()

Map

No

getWarnings()

SQLWarning

Yes

isClosed()

boolean

Yes

isReadOnly()

boolean

Yes

nativeSQL(String sql)

String

Yes

prepareCall(String sql)

CallableStatement

Yes

prepareCall(String sql, int resultSetType, int resultSetConcurrency)

CallableStatement

Yes

prepareStatement(String sql)

PreparedStatement

Yes

prepareStatement(String sql, int resultSetType, int resultSetConcurrency)

PreparedStatement

Yes

rollback()

void

Yes

setAutoCommit(boolean autoCommit)

void

Yes

setCatalog(String catalog)

void

Yes

setReadOnly(boolean readOnly)

void

Yes

setTransactionIsolation(int level)

void

Yes

setTypeMap(Map map)

void

No

Methods

Return Types

Supported

allProceduresAreCallable()

boolean

Yes

allTablesAreSelectable()

boolean

Yes

dataDefinitionCausesTransactionCommit()

boolean

Yes

dataDefinitionIgnoredInTransactions()

boolean

Yes

deletesAreDetected(int type)

boolean

Yes

doesMaxRowSizeIncludeBlobs()

boolean

Yes

getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)

ResultSet

Yes

getCatalogs()

ResultSet

Yes

getCatalogSeparator()

String

Yes

getCatalogTerm()

String

Yes

getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

ResultSet

Yes

getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

ResultSet

Yes

getConnection()

Connection

Yes

getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)

ResultSet

Yes

getDatabaseProductName()

String

Yes

getDatabaseProductVersion()

String

Yes

getDefaultTransactionIsolation()

int

Yes

getDriverMajorVersion()

int

Yes

getDriverMinorVersion()

int

Yes

getDriverName()

String

Yes

getDriverVersion()

String

Yes

getExportedKeys(String catalog, String schema, String table)

ResultSet

Yes

getExtraNameCharacters()

String

Yes

getIdentifierQuoteString()

String

Yes

getImportedKeys(String catalog, String schema, String table)

ResultSet

Yes

getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)

ResultSet

Yes

getMaxBinaryLiteralLength()

int

Yes

getMaxCatalogNameLength()

int

Yes

getMaxCharLiteralLength()

int

Yes

getMaxColumnNameLength()

int

Yes

getMaxColumnsInGroupBy()

int

Yes

getMaxColumnsInIndex()

int

Yes

getMaxColumnsInOrderBy()

int

Yes

getMaxColumnsInSelect()

int

Yes

getMaxColumnsInTable()

int

Yes

getMaxConnections()

int

Yes

getMaxCursorNameLength()

int

Yes

getMaxIndexLength()

int

Yes

getMaxProcedureNameLength()

int

Yes

getMaxRowSize()

int

Yes

getMaxSchemaNameLength()

int

Yes

getMaxStatementLength()

int

Yes

getMaxStatements()

int

Yes

getMaxTableNameLength()

int

Yes

getMaxTablesInSelect()

int

Yes

getMaxUserNameLength()

int

Yes

getNumericFunctions()

String

Yes

getPrimaryKeys(String catalog, String schema, String table)

ResultSet

Yes

getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

ResultSet

Yes

getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

ResultSet

Yes

getProcedureTerm()

String

Yes

getSchemas()

ResultSet

Yes

getSchemaTerm()

String

Yes

getSearchStringEscape()

String

Yes

getSQLKeywords()

String

Yes

getStringFunctions()

String

Yes

getSystemFunctions()

String

Yes

getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)

ResultSet

Yes

getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)

ResultSet

Yes

getTableTypes()

ResultSet

Yes

getTimeDateFunctions()

String

Yes

getTypeInfo()

ResultSet

Yes

getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)

ResultSet

Yes

getURL()

String

Yes

getUserName()

String

Yes

getVersionColumns(String catalog, String schema, String table)

ResultSet

Yes

insertsAreDetected(int type)

boolean

Yes

isCatalogAtStart()

boolean

Yes

isReadOnly()

boolean

Yes

nullPlusNonNullIsNull()

boolean

Yes

nullsAreSortedAtEnd()

boolean

Yes

nullsAreSortedAtStart()

boolean

Yes

nullsAreSortedHigh()

boolean

Yes

nullsAreSortedLow()

boolean

Yes

othersDeletesAreVisible(int type)

boolean

Yes

othersInsertsAreVisible(int type)

boolean

Yes

othersUpdatesAreVisible(int type)

boolean

Yes

ownDeletesAreVisible(int type)

boolean

Yes

ownInsertsAreVisible(int type)

boolean

Yes

ownUpdatesAreVisible(int type)

boolean

Yes

storesLowerCaseIdentifiers()

boolean

Yes

storesLowerCaseQuotedIdentifiers()

boolean

Yes

storesMixedCaseIdentifiers()

boolean

Yes

storesMixedCaseQuotedIdentifiers()

boolean

Yes

storesUpperCaseIdentifiers()

boolean

Yes

storesUpperCaseQuotedIdentifiers()

boolean

Yes

supportsAlterTableWithAddColumn()

boolean

Yes

supportsAlterTableWithDropColumn()

boolean

Yes

supportsANSI92EntryLevelSQL()

boolean

Yes

supportsANSI92FullSQL()

boolean

Yes

supportsANSI92IntermediateSQL()

boolean

Yes

supportsBatchUpdates()

boolean

Yes

supportsCatalogsInDataManipulation()

boolean

Yes

supportsCatalogsInIndexDefinitions()

boolean

Yes

supportsCatalogsInPrivilegeDefinitions()

boolean

Yes

supportsCatalogsInProcedureCalls()

boolean

Yes

supportsCatalogsInTableDefinitions()

boolean

Yes

supportsColumnAliasing()

boolean

Yes

supportsConvert()

boolean

No

supportsConvert(int fromType, int toType)

boolean

No

supportsCoreSQLGrammar()

boolean

Yes

supportsCorrelatedSubqueries()

boolean

Yes

supportsDataDefinitionAndDataManipulationTransactions()

boolean

Yes

supportsDataManipulationTransactionsOnly()

boolean

Yes

supportsDifferentTableCorrelationNames()

boolean

Yes

supportsExpressionsInOrderBy()

boolean

Yes

supportsExtendedSQLGrammar()

boolean

Yes

supportsFullOuterJoins()

boolean

Yes

supportsGroupBy()

boolean

Yes

supportsGroupByBeyondSelect()

boolean

Yes

supportsGroupByUnrelated()

boolean

Yes

supportsIntegrityEnhancementFacility()

boolean

Yes

supportsLikeEscapeClause()

boolean

Yes

supportsLimitedOuterJoins()

boolean

Yes

supportsMinimumSQLGrammar()

boolean

Yes

supportsMixedCaseIdentifiers()

boolean

Yes

supportsMixedCaseQuotedIdentifiers()

boolean

Yes

supportsMultipleResultSets()

boolean

Yes

supportsMultipleTransactions()

boolean

Yes

supportsNonNullableColumns()

boolean

Yes

supportsOpenCursorsAcrossCommit()

boolean

Yes

supportsOpenCursorsAcrossRollback()

boolean

Yes

supportsOpenStatementsAcrossCommit()

boolean

Yes

supportsOpenStatementsAcrossRollback()

boolean

Yes

supportsOrderByUnrelated()

boolean

Yes

supportsOuterJoins()

boolean

Yes

supportsPositionedDelete()

boolean

Yes

supportsPositionedUpdate()

boolean

Yes

supportsResultSetConcurrency(int type, int concurrency)

boolean

Yes

supportsResultSetType(int type)

boolean

Yes

supportsSchemasInDataManipulation()

boolean

Yes

supportsSchemasInIndexDefinitions()

boolean

Yes

supportsSchemasInPrivilegeDefinitions()

boolean

Yes

supportsSchemasInProcedureCalls()

boolean

Yes

supportsSchemasInTableDefinitions()

boolean

Yes

supportsSelectForUpdate()

boolean

Yes

supportsStoredProcedures()

boolean

Yes

supportsSubqueriesInComparisons()

boolean

Yes

supportsSubqueriesInExists()

boolean

Yes

supportsSubqueriesInIns()

boolean

Yes

supportsSubqueriesInQuantifieds()

boolean

Yes

supportsTableCorrelationNames()

boolean

Yes

supportsTransactionIsolationLevel(int level)

boolean

Yes

supportsTransactions()

boolean

Yes

supportsUnion()

boolean

Yes

supportsUnionAll()

boolean

Yes

updatesAreDetected(int type)

boolean

Yes

usesLocalFilePerTable()

boolean

Yes

usesLocalFiles()

boolean

Yes

Methods

Return Types

Supported

addBatch()

void

Yes

clearParameters()

void

Yes

execute()

boolean

Yes

executeQuery()

ResultSet

Yes

executeUpdate()

int

Yes

getMetaData()

ResultSetMetaData

Yes

setArray(int i, Array x)

void

No

setAsciiStream(int parameterIndex, InputStream x, int length)

void

Yes

setBigDecimal(int parameterIndex, BigDecimal x)

void

Yes

setBinaryStream(int parameterIndex, InputStream x, int length)

void

Yes

setBlob(int i, Blob x)

void

Yes

setBoolean(int parameterIndex, boolean x)

void

Yes

setByte(int parameterIndex, byte x)

void

Yes

setBytes(int parameterIndex, byte[] x)

void

Yes

setCharacterStream(int parameterIndex, Reader reader, int length)

void

Yes

setClob(int i, Clob x)

void

Yes

setDate(int parameterIndex, Date x)

void

Yes

setDate(int parameterIndex, Date x, Calendar cal)

void

Yes

setDouble(int parameterIndex, double x)

void

Yes

setFloat(int parameterIndex, float x)

void

Yes

setInt(int parameterIndex, int x)

void

Yes

setLong(int parameterIndex, long x)

void

Yes

setNull(int parameterIndex, int sqlType)

void

yes

setNull(int paramIndex, int sqlType, String typeName)

void

no

setObject(int parameterIndex, Object x)

void

Yes

setObject(int parameterIndex, Object x, int targetSqlType)

void

Yes

setObject(int parameterIndex, Object x, int targetSqlType, int scale)

void

Yes

setRef(int i, Ref x)

void

No

setShort(int parameterIndex, short x)

void

Yes

setString(int parameterIndex, String x)

void

Yes

setTime(int parameterIndex, Time x)

void

Yes

setTime(int parameterIndex, Time x, Calendar cal)

void

Yes

setTimestamp(int parameterIndex, Timestamp x)

void

Yes

setTimestamp(int parameterIndex, Timestamp x, Calendar cal)

void

Yes

setUnicodeStream(int parameterIndex, InputStream x, int length)

void

Yes

Methods

Return Types

Supported

absolute(int row)

boolean

Yes

afterLast()

void

Yes

beforeFirst()

void

Yes

cancelRowUpdates()

void

Yes

clearWarnings()

void

Yes

close()

void

Yes

deleteRow()

void

Yes

findColumn(String columnName)

int

Yes

first()

boolean

Yes

getArray(int i)

Array

No

getArray(String colName)

Array

Yes

getAsciiStream(int columnIndex)

InputStream

Yes

getAsciiStream(String columnName)

InputStream

Yes

getBigDecimal(int columnIndex)

BigDecimal

Yes

getBigDecimal(int columnIndex, int scale)

BigDecimal

Yes

getBigDecimal(String columnName)

BigDecimal

Yes

getBigDecimal(String columnName, int scale)

BigDecimal

Yes

getBinaryStream(int columnIndex)

InputStream

Yes

getBinaryStream(String columnName)

InputStream

Yes

getBlob(int i)

Blob

Yes

getBlob(String colName)

Blob

Yes

getBoolean(int columnIndex)

boolean

Yes

getBoolean(String columnName)

boolean

Yes

getByte(int columnIndex)

byte

Yes

getByte(String columnName)

byte

Yes

getBytes(int columnIndex)

byte[]

Yes

getBytes(String columnName)

byte[]

Yes

getCharacterStream(int columnIndex)

Reader

Yes

getCharacterStream(String columnName)

Reader

Yes

getClob(int i)

Clob

Yes

getClob(String colName)

Clob

Yes

getConcurrency()

int

Yes

getCursorName()

String

Yes

getDate(int columnIndex)

Date

Yes

getDate(int columnIndex, Calendar cal)

Date

Yes

getDate(String columnName)

Date

Yes

getDate(String columnName, Calendar cal)

Date

Yes

getDouble(int columnIndex)

double

Yes

getDouble(String columnName)

double

Yes

getFetchDirection()

int

Yes

getFetchSize()

int

Yes

getFloat(int columnIndex)

float

Yes

getFloat(String columnName)

float

Yes

getInt(int columnIndex)

int

Yes

getInt(String columnName)

int

Yes

getLong(int columnIndex)

long

Yes

getLong(String columnName)

long

Yes

getMetaData()

ResultSetMetaData

Yes

getObject(int columnIndex)

Object

Yes

getObject(int i, Map map)

Object

No

getObject(String columnName)

Object

Yes

getObject(String colName, Map map)

Object

No

getRef(int i)

Ref

No

getRef(String colName)

Ref

No

getRow()

int

Yes

getShort(int columnIndex)

short

Yes

getShort(String columnName)

short

Yes

getStatement()

Statement

Yes

getString(int columnIndex)

String

Yes

getString(String columnName)

String

Yes

getTime(int columnIndex)

Time

Yes

getTime(int columnIndex, Calendar cal)

Time

Yes

getTime(String columnName)

Time

Yes

getTime(String columnName, Calendar cal)

Time

Yes

getTimestamp(int columnIndex)

Timestamp

Yes

getTimestamp(int columnIndex, Calendar cal)

Timestamp

Yes

getTimestamp(String columnName)

Timestamp

Yes

getTimestamp(String columnName, Calendar cal)

Timestamp

Yes

getType()

int

Yes

getUnicodeStream(int columnIndex)

InputStream

Yes

getUnicodeStream(String columnName)

InputStream

Yes

getWarnings()

SQLWarning

Yes

insertRow()

void

Yes

isAfterLast()

boolean

Yes

isBeforeFirst()

boolean

Yes

isFirst()

boolean

Yes

isLast()

boolean

Yes

last()

boolean

Yes

moveToCurrentRow()

void

Yes

moveToInsertRow()

void

Yes

next()

boolean

Yes

previous()

boolean

Yes

refreshRow()

void

Yes

relative(int rows)

boolean

Yes

rowDeleted()

boolean

Yes

rowInserted()

boolean

Yes

rowUpdated()

boolean

Yes

setFetchDirection(int direction)

void

Yes

setFetchSize(int rows)

void

Yes

updateAsciiStream(int columnIndex, InputStream x, int length)

void

Yes

updateAsciiStream(String columnName, InputStream x, int length)

void

Yes

updateBigDecimal(int columnIndex, BigDecimal x)

void

Yes

updateBigDecimal(String columnName, BigDecimal x)

void

Yes

updateBinaryStream(int columnIndex, InputStream x, int length)

void

Yes

updateBinaryStream(String columnName, InputStream x, int length)

void

Yes

updateBoolean(int columnIndex, boolean x)

void

Yes

updateBoolean(String columnName, boolean x)

void

Yes

updateByte(int columnIndex, byte x)

void

Yes

updateByte(String columnName, byte x)

void

Yes

updateBytes(int columnIndex, byte[] x)

void

Yes

updateBytes(String columnName, byte[] x)

void

Yes

updateCharacterStream(int columnIndex, Reader x, int length)

void

Yes

updateCharacterStream(String columnName, Reader reader, int length)

void

Yes

updateDate(int columnIndex, Date x)

void

Yes

updateDate(String columnName, Date x)

void

Yes

updateDouble(int columnIndex, double x)

void

Yes

updateDouble(String columnName, double x)

void

Yes

updateFloat(int columnIndex, float x)

void

Yes

updateFloat(String columnName, float x)

void

Yes

updateInt(int columnIndex, int x)

void

Yes

updateInt(String columnName, int x)

void

Yes

updateLong(int columnIndex, long x)

void

Yes

updateLong(String columnName, long x)

void

Yes

updateNull(int columnIndex)

void

Yes

updateNull(String columnName)

void

Yes

updateObject(int columnIndex, Object x)

void

Yes

updateObject(int columnIndex, Object x, int scale)

void

Yes

updateObject(String columnName, Object x)

void

Yes

updateObject(String columnName, Object x, int scale)

void

Yes

updateRow()

void

Yes

updateShort(int columnIndex, short x)

void

Yes

updateShort(String columnName, short x)

void

Yes

updateString(int columnIndex, String x)

void

Yes

updateString(String columnName, String x)

void

Yes

updateTime(int columnIndex, Time x)

void

Yes

updateTime(String columnName, Time x)

void

Yes

updateTimestamp(int columnIndex, Timestamp x)

void

Yes

updateTimestamp(String columnName, Timestamp x)

void

Yes

wasNull()

boolean

Yes

Methods

Return Types

Supported

getCatalogName(int column)

String

Yes

getColumnClassName(int column)

String

No

getColumnCount()

int

Yes

getColumnDisplaySize(int column)

int

Yes

getColumnLabel(int column)

String

Yes

getColumnName(int column)

String

Yes

getColumnType(int column)

int

Yes

getColumnTypeName(int column)

String

Yes

getPrecision(int column)

int

Yes

getScale(int column)

int

Yes

getSchemaName(int column)

String

Yes

getTableName(int column)

String

Yes

isAutoIncrement(int column)

boolean

Yes

isCaseSensitive(int column)

boolean

Yes

isCurrency(int column)

boolean

Yes

isDefinitelyWritable(int column)

boolean

Yes

isNullable(int column)

int

Yes

isReadOnly(int column)

boolean

Yes

isSearchable(int column)

boolean

Yes

isSigned(int column)

boolean

Yes

isWritable(int column)

boolean

Yes

Methods

Return Types

Supported

addBatch(String sql)

void

Yes

cancel()

void

No

clearBatch()

void

Yes

clearWarnings()

void

Yes

close()

void

Yes

execute(String sql)

boolean

Yes

executeBatch()

int[]

Yes

executeQuery(String sql)

ResultSet

Yes

executeUpdate(String sql)

int

Yes

getConnection()

Connection

Yes

getFetchDirection()

int

Yes

getFetchSize()

int

Yes

getMaxFieldSize()

int

Yes

getMaxRows()

int

Yes

getMoreResults()

boolean

Yes

getQueryTimeout()

int

Yes

getResultSet()

ResultSet

Yes

getResultSetConcurrency()

int

Yes

getResultSetType()

int

Yes

getUpdateCount()

int

Yes

getWarnings()

SQLWarning

Yes

setCursorName(String name)

void

no

setEscapeProcessing(boolean enable)

void

Yes

setFetchDirection(int direction)

void

no

setFetchSize(int rows)

void

no

setMaxFieldSize(int max)

void

Yes

setMaxRows(int max)

void

Yes

setQueryTimeout(int seconds)

void

Yes