sample1
SELECT DISTINCTの処理方式
SELECT STATEMENT
SET OPERATION
SET OPERATION TYPE
setApName(String name)
setAsciiStream
setAutoCommit(boolean autoCommit)
setBigDecimal(int parameterIndex, BigDecimal x)
setBinaryStream(int parameterIndex, InputStream x, int length)
setBoolean(int parameterIndex, boolean x)
setByte(int parameterIndex, byte x)
setBytes(int parameterIndex, byte[] x)
setCatalog(String catalog)
setCharacterStream
setCursorName(String name)
setDate(int parameterIndex, Date x, Calendar cal)
setDate(int parameterIndex, Date x)
setDouble(int parameterIndex, double x)
setEncodeLang(String lang)
setEscapeProcessing(boolean enable)
setFetchDirection(int direction)
setFetchSize(int rows)
setFloat(int parameterIndex, float x)
setHADBAuditInfo(int pos,String userinfo)
setHADBOrderMode(int mode)
setHADBSQLHashFltSize(int areaSize)
setHADBSQLHashTblSize(int areaSize)
setHADBSQLMaxRthdNum(int rthdNum)
setHoldability(int holdability)
setHostName(String name)
setInt(int parameterIndex, int x)
setInterfaceMethodTrace(boolean flag)
setLargeMaxRows(long max)
setLoginTimeout(int seconds)
setLogWriter
setLogWriter(PrintWriter out)
setLong(int parameterIndex, long x)
setMaxFieldSize(int max)
setMaxRows(int max)
setNotErrorOccurred(boolean mode)
setNull(int parameterIndex,int sqlType)
setObject(int parameterIndex, Object x, int targetSqlType, int scale)
setObject(int parameterIndex, Object x, int targetSqlType)
setObject(int parameterIndex, Object x)
setPassword(String password)
setPort(int port)
setQueryTimeout(int seconds)
setReadOnly(boolean readOnly)
setSchema(String schema)
setShort(int parameterIndex, short x)
setSQLWarningKeep(boolean mode)
setString(int parameterIndex, String x)
setTime(int parameterIndex, Time x, Calendar cal)
setTime(int parameterIndex, Time x)
setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
setTimestamp(int parameterIndex, Timestamp x)
setTraceNumber(int num)
setTransactionIsolation(int level)
setUser(String user)
SKIP COND
SORT GROUPING
SORTING
SPECIFIC, [2], [3], [4], [5], [6]
SPECIFIC DISABLED, [2]
SQL Serial Number
SQLAllocHandle
SQLBindCol
SQLBindParameter
SQLBrowseConnect,SQLBrowseConnectW
SQLBulkOperations
SQLCancel
SQLCloseCursor
SQLColAttribute,SQLColAttributeW
SQLColumnPrivileges,SQLColumnPrivilegesW
SQLColumns,SQLColumnsW
SQLConnect,SQLConnectW
SQLCopyDesc
SQLDataSources,SQLDataSourcesW
SQLDescribeCol,SQLDescribeColW
SQLDescribeParam
SQLDisconnect
SQLDriverConnect,SQLDriverConnectW
SQLDrivers,SQLDriversW
SQLEndTran
SQLExceptionインタフェース
SQLExecDirect,SQLExecDirectW
SQLExecute
SQLFetch
SQLFetchScroll
SQLForeignKeys,SQLForeignKeysW
SQLFreeHandle
SQLFreeStmt
SQLGetConnectAttr,SQLGetConnectAttrW
SQLGetCursorName,SQLGetCursorNameW
SQLGetData
SQLGetDescField,SQLGetDescFieldW
SQLGetDescRec,SQLGetDescRecW
SQLGetDiagField,SQLGetDiagFieldW
SQLGetDiagRec,SQLGetDiagRecW
SQLGetEnvAttr
SQLGetFunctions
SQLGetInfo,SQLGetInfoW
SQLGetStmtAttr,SQLGetStmtAttrW
SQLGetTypeInfo,SQLGetTypeInfoW
SQLMoreResults
SQLNativeSql,SQLNativeSqlW
SQLNumParams
SQLNumResultCols
SQLParamData
SQLPrepare,SQLPrepareW
SQLPrimaryKeys,SQLPrimaryKeysW
SQLProcedureColumns,SQLProcedureColumnsW
SQLProcedures,SQLProceduresW
SQLPutData
SQLRowCount
SQLSetConnectAttr,SQLSetConnectAttrW
SQLSetCursorName,SQLSetCursorNameW
SQLSetDescField,SQLSetDescFieldW
SQLSetDescRec
SQLSetEnvAttr
SQLSetPos
SQLSetStmtAttr,SQLSetStmtAttrW
SQLSpecialColumns,SQLSpecialColumnsW
SQLStatistics,SQLStatisticsW
SQLTablePrivileges,SQLTablePrivilegesW
SQLTables,SQLTablesW
sqlwarningkeep
SQLWarningインタフェース
SQL実行の終了
SQLデータ型の対応
SQLのキャンセル〔CLI関数〕
SQLの実行
SQLの処理の取り消し
SQLパラレル実行機能が適用される条件
SQLパラレル実行機能の適用
SQL文のエラー判定方法
SQL文の実行
SQL文の実行計画
SQL文の実行時に使用されるB-treeインデクス
SQL文の実行時に使用されるテキストインデクス
SQL文の実行時に使用されるレンジインデクス
SQL文の特定情報
SQL文の前処理
SQL文の前処理および実行
SQL要求の作成
SQL例外拡張
SQL例外拡張機能〔JDBC 4.0 API〕
SQLを実行した場合に作成される作業表について
Statementインタフェース
storesLowerCaseIdentifiers()
storesLowerCaseQuotedIdentifiers()
storesMixedCaseIdentifiers()
storesMixedCaseQuotedIdentifiers()
storesUpperCaseIdentifiers()
storesUpperCaseQuotedIdentifiers()
SUBQUERY
SUBQUERY HASH
SUBQUERY LOOP
supportsAlterTableWithAddColumn()
supportsAlterTableWithDropColumn()
supportsANSI92EntryLevelSQL()
supportsANSI92FullSQL()
supportsANSI92IntermediateSQL()
supportsBatchUpdates()
supportsCatalogsInDataManipulation()
supportsCatalogsInIndexDefinitions()
supportsCatalogsInPrivilegeDefinitions()
supportsCatalogsInProcedureCalls()
supportsCatalogsInTableDefinitions()
supportsColumnAliasing()
supportsConvert()
supportsConvert(int fromType, int toType)
supportsCoreSQLGrammar()
supportsCorrelatedSubqueries()
supportsDataDefinitionAndDataManipulationTransactions()
supportsDataManipulationTransactionsOnly()
supportsDifferentTableCorrelationNames()
supportsExpressionsInOrderBy()
supportsExtendedSQLGrammar()
supportsFullOuterJoins()
supportsGetGeneratedKeys()
supportsGroupBy()
supportsGroupByBeyondSelect()
supportsGroupByUnrelated()
supportsIntegrityEnhancementFacility()
supportsLikeEscapeClause()
supportsLimitedOuterJoins()
supportsMinimumSQLGrammar()
supportsMixedCaseIdentifiers()
supportsMixedCaseQuotedIdentifiers()
supportsMultipleOpenResults()
supportsMultipleResultSets()
supportsMultipleTransactions()
supportsNamedParameters()
supportsNonNullableColumns()
supportsOpenCursorsAcrossCommit()
supportsOpenCursorsAcrossRollback()
supportsOpenStatementsAcrossCommit()
supportsOpenStatementsAcrossRollback()
supportsOrderByUnrelated()
supportsOuterJoins()
supportsPositionedDelete()
supportsPositionedUpdate()
supportsRefCursors()
supportsResultSetConcurrency(int type, int concurrency)
supportsResultSetHoldability(int holdability)
supportsResultSetType(int type)
supportsSavepoints()
supportsSchemasInDataManipulation()
supportsSchemasInIndexDefinitions()
supportsSchemasInPrivilegeDefinitions()
supportsSchemasInProcedureCalls()
supportsSchemasInTableDefinitions()
supportsSelectForUpdate()
supportsStatementPooling()
supportsStoredFunctionsUsingCallSyntax()
supportsStoredProcedures()
supportsSubqueriesInComparisons()
supportsSubqueriesInExists()
supportsSubqueriesInIns()
supportsSubqueriesInQuantifieds()
supportsTableCorrelationNames()
supportsTransactionIsolationLevel(int level)
supportsTransactions()
supportsUnion()
supportsUnionAll()