: Index

Package

Class

Tree

Deprecated

Index

Help

PREV NEXT

FRAMES NO FRAMES

D G N O S U X

D

DB_CONNECT_STRING_TOKEN_SEPARATOR - Static variable in interface oajava.sql.sqlip: Constant to indicate the character separating tokens in the connect string

G

getBaseColumnName() - Method in class oajava.sql.xo_col_attribute: Get the base column name.
getBaseTableName() - Method in class oajava.sql.xo_col_attribute: Get the base table name.
getCatalogName() - Method in class oajava.sql.xo_col_attribute: Get the catalog name.
getCustom() - Method in class oajava.sql.xo_col_attribute: Get the custom attribute.
getDouble() - Method in class oajava.sql.xo_val: Get the double value.
getFloat() - Method in class oajava.sql.xo_val: Get the float value.
getInt() - Method in class oajava.sql.xo_val: Get the integer value.
getSchemaName() - Method in class oajava.sql.xo_col_attribute: Get the schema name.
getShort() - Method in class oajava.sql.xo_val: Get the short value.
getVal() - Method in class oajava.sql.xo_int: Get the integer value.

N

NOT_NULL_INDICATOR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the NOT NUll INDICATOR
NULL_INDICATOR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the NUll INDICATOR

O

oajava.sql - package oajava.sql: This will help you to write SQL IP in Java using OpenAccess SDK for Java.

S

setBaseColumnName(String) - Method in class oajava.sql.xo_col_attribute: Set the base column name.
setBaseTableName(String) - Method in class oajava.sql.xo_col_attribute: Set the base table name.
setCatalogName(String) - Method in class oajava.sql.xo_col_attribute: Set the catalog name.
setCustom(String) - Method in class oajava.sql.xo_col_attribute: Set the custom attribute.
setDouble(double) - Method in class oajava.sql.xo_val: Set the double value.
setFloat(float) - Method in class oajava.sql.xo_val: Set the float value.
setInt(int) - Method in class oajava.sql.xo_val: Set the integer value.
setSchemaName(String) - Method in class oajava.sql.xo_col_attribute: Set the schema name.
setShort(short) - Method in class oajava.sql.xo_val: Set the short value.
setVal(int) - Method in class oajava.sql.xo_int: Set the integer value.
SQL_ALL_TYPES - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate to define all the Data Types
SQL_SCOPE_CURROW - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that the rowid is guaranteed to be valid only while positioned on that row.
SQL_SCOPE_SESSION - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that the rowid is guaranteed to be valid for the duration of the session (across transaction boundaries).
SQL_SCOPE_TRANSACTION - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that the rowid is guaranteed to be valid for the duration of the current transaction.
SQLDRV_BUFFER_FULL - Static variable in interface oajava.sql.sqlip: Constant to indicate results in current buffer are completely returned.
SQLDRV_BUFFER_FULL - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate results in current buffer are completely returned.
SQLDRV_EOS - Static variable in interface oajava.sql.sqlip: Constant to indicate that all results are returned.
SQLDRV_EOS - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that all results are returned.
SQLDRV_ERROR - Static variable in interface oajava.sql.sqlip: Constant to indicate Failure from IP routine.
SQLDRV_ERROR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate Failure from IP routine.
SQLDRV_INFO_NEXT_RESULT_SET_AVAILABLE - Static variable in interface oajava.sql.sqlip: Constant to check and see if more result sets are available.
SQLDRV_INFO_NEXT_RESULT_SET_AVAILABLE - Static variable in interface oajava.sql.sqlip_stmt: Constant to check and see if more result sets are available for the current statement.
SQLDRV_INFO_OUTPUT_RESULT_SET_AVAILABLE - Static variable in interface oajava.sql.sqlip: Constant to indicate for the current statement report whether it had a return code and/or output parameters.
SQLDRV_INFO_OUTPUT_RESULT_SET_AVAILABLE - Static variable in interface oajava.sql.sqlip_stmt: Constant to check whether it had a return code and/or output parameters for the current statement report.
SQLDRV_NOT_AVAILABLE - Static variable in interface oajava.sql.sqlip: Constant to indicates that Driver functionality is not available
SQLDRV_NOT_AVAILABLE - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that Driver functionality is not available
SQLDRV_NTS - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the NULL Terminated String
SQLDRV_SUCCESS - Static variable in interface oajava.sql.sqlip: Constant to indicate Success from IP routine
SQLDRV_SUCCESS - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate Success from IP routine
sqlip - interface oajava.sql.sqlip.: A connection (session) with a specific database.
SQLIP_COL_ATTRIB_HIDDEN - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that the column is a hidden field.
SQLIP_COL_ATTRIB_KEY - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that column is a index field.
SQLIP_EOS - Static variable in interface oajava.sql.sqlip_stmt: Constant to Indicate IP Routine has nor more error exists.
SQLIP_ERROR - Static variable in interface oajava.sql.sqlip: Constant to Indicate IP Routine had an Error
SQLIP_ERROR - Static variable in interface oajava.sql.sqlip_stmt: Constant to Indicate IP Routine had an Error
SQLIP_FAILURE - Static variable in interface oajava.sql.sqlip: Constant to Indicate IP Routine had an Error
SQLIP_FAILURE - Static variable in interface oajava.sql.sqlip_stmt: Constant to Indicate IP Routine had an Error
sqlip_stmt - interface oajava.sql.sqlip_stmt.: The object used for executing a static SQL statement and obtaining the results produced by it.
SQLIP_SUCCESS - Static variable in interface oajava.sql.sqlip: Constant to Indicate IP Routine was succesful
SQLIP_SUCCESS - Static variable in interface oajava.sql.sqlip_stmt: Constant to Indicate IP Routine was succesful
sqlipBestRowIdentifier(String, String, String, int, boolean) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get a table's optimal set of columns that uniquely identifies a row.
sqlipCatalogs() - Method in interface oajava.sql.sqlip_stmt: Close the cursor and clear the result table.
sqlipCloseCursor() - Method in interface oajava.sql.sqlip_stmt: Close the cursor and clear the result table.
sqlipCloseStmt() - Method in interface oajava.sql.sqlip_stmt: Close the current statement and free all resources used to execute commands on it.
sqlipColumns(String, String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get column list.
sqlipCommit() - Method in interface oajava.sql.sqlip: Commit any active transactions on the specified connection.
sqlipConnect(String, String, String, String, int, String, String) - Method in interface oajava.sql.sqlip: Connect to the specified database using the specified user name and password.
sqlipDeclareCursor(String) - Method in interface oajava.sql.sqlip_stmt: Associate the cursor name with the prepared statement.
sqlipDisconnect() - Method in interface oajava.sql.sqlip: Disconnect from the database and abort any open transactions.
sqlipError(StringBuffer, xo_int, StringBuffer) - Method in interface oajava.sql.sqlip: Return the error during the last operation on this object.
sqlipError(StringBuffer, xo_int, StringBuffer) - Method in interface oajava.sql.sqlip_stmt: Return the error during the last operation on this object.
sqlipFetchRow() - Method in interface oajava.sql.sqlip_stmt: Fetch data at the current cursor position and advance the cursor to the next row of the result table.
sqlipForeignKeys(String, String, String, String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get foreign key list.
sqlipGetColspec(int, xo_int, xo_int, StringBuffer, xo_int, xo_int, xo_int, xo_col_attribute, xo_int) - Method in interface oajava.sql.sqlip_stmt: Returns the description for the specified column.
sqlipGetColval(int, xo_int, xo_int, xo_int) - Method in interface oajava.sql.sqlip_stmt: Returns the value of the specified column for the current row.
sqlipGetInfo(int, StringBuffer) - Method in interface oajava.sql.sqlip: Called by the OpenAccess layer to request information from the IP.
sqlipGetInfo(int, StringBuffer) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to request information from the IP.
sqlipGetNumcols(xo_int) - Method in interface oajava.sql.sqlip_stmt: Return the number of columns in the result set.
sqlipGetNumparams(xo_int) - Method in interface oajava.sql.sqlip_stmt: Returns the number of parameter markers in the prepared stmt.
sqlipGetParamSpec(int, xo_int, xo_int, xo_int, xo_int, xo_int, xo_int, xo_int) - Method in interface oajava.sql.sqlip_stmt: Returns the description for the specified parameter.
sqlipIndexInfo(String, String, String, boolean, boolean) - Method in interface oajava.sql.sqlip_stmt: Close the cursor and clear the result table.
sqlipInitParam(int, int, String, int) - Method in interface oajava.sql.sqlip_stmt: This function will be called for each input parameter that has been specified by the client application.
sqlipIsCursorOpen(xo_int) - Method in interface oajava.sql.sqlip_stmt: Check if the cursor is open.
sqlipMapToXoType(int) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to map database specific data type to OpenAccess data type during the fetching of rows from a schema request.
sqlipOpenCursor(xo_int) - Method in interface oajava.sql.sqlip_stmt: This function is called to execute both SELECT and non-select prepared statements.
sqlipOpenNextCursor(xo_int) - Method in interface oajava.sql.sqlip_stmt: If the statement has more results pending then move to the next result.
sqlipOpenOutputCursor(xo_int) - Method in interface oajava.sql.sqlip_stmt: If the statement is a stored procedure call and it has output parameters and/or output return value then this function should return a cursor for accessing this information.
sqlipPrepareStmt(String) - Method in interface oajava.sql.sqlip_stmt: Parse the given SQL stmt (check any syntax errors) and generate plan for executing the statement.
sqlipPrepareToCommit(String, xo_int) - Method in interface oajava.sql.sqlip: Used to support distributed transactions.
sqlipPrimaryKeys(String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get primary key list.
sqlipProcedureColumns(String, String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get store procedure column list.
sqlipProcedures(String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get store procedure list.
sqlipRollback() - Method in interface oajava.sql.sqlip: Roll back all uncommitted transactions on this connection.
sqlipSchemas() - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get catalog list.
sqlipSetInfo(String) - Method in interface oajava.sql.sqlip: Called by the OpenAccess layer to inform the IP of various connection and statement level options like the maximum number of rows to return, transaction commit mode, query timeout, etc.
sqlipSetInfo(String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to inform the IP of various connection and statement level options like the maximum number of rows to return, transaction commit mode, query timeout, etc.
sqlipStartTransaction(int, String) - Method in interface oajava.sql.sqlip: Start a new transaction on the specified connection in response to a request for an explicit start transaction by the client.
sqlipTables(String, String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get table list.
sqlipTableTypes() - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get table type list.
sqlipTypeInfo(int) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get data type list.
sqlipVersionColumns(String, String, String) - Method in interface oajava.sql.sqlip_stmt: Called by the OpenAccess layer to get a table's columns that are automatically updated when any value in a row is updated.

U

UL_TM_ERRORS - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as "General Errors" in either the protocol or application.
UL_TM_ERRORS - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as "General Errors" in either the protocol or application.
UL_TM_F_TRACE - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as function call trace.
UL_TM_F_TRACE - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as function call trace.
UL_TM_FATAL - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as "FATAL" error
UL_TM_FATAL - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as "FATAL" error
UL_TM_INFO - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as general info to give details about the events.
UL_TM_INFO - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as general info to give details about the events.
UL_TM_MAJOR_EV - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as major protocol or application events to give the big picture.
UL_TM_MAJOR_EV - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as major protocol or application events to give the big picture.
UL_TM_MINOR_EV - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as minor or secondary protocol or application events to give more detail.
UL_TM_MINOR_EV - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as minor or secondary protocol or application events to give more detail.
UL_TM_PARM - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as "Bad or missing Parameter" passed.
UL_TM_PARM - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as "Bad or missing Parameter" passed.
UL_TM_SNO - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as "Should not occur" error, usually caused by programmer or spec error
UL_TM_SNO - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as "Should not occur" error, usually caused by programmer or spec error
UL_TM_TRIVIA - Static variable in interface oajava.sql.sqlip: Constant to indicate message type as trivial info of value only to the implementor.
UL_TM_TRIVIA - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate message type as trivial info of value only to the implementor.

X

xo_col_attribute - class oajava.sql.xo_col_attribute.: This class allow IP writer to specify/get column attributes.
xo_col_attribute() - Constructor for class oajava.sql.xo_col_attribute: Intialize the object with empty value(s).
xo_col_attribute(String, String, String, String, String) - Constructor for class oajava.sql.xo_col_attribute: Intialize the object with specified value(s).
xo_int - class oajava.sql.xo_int.: This class is basically allow IP writer to hold/change integer type value.
xo_int() - Constructor for class oajava.sql.xo_int: Intialize the object with zero value.
xo_int(int) - Constructor for class oajava.sql.xo_int: Intialize the object with specified value.
XO_NO_NULLS - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the Nullable field
XO_NTS - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data as Null Terminated String
XO_NULL_DATA - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data as NULL DATA
XO_NULLABLE - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that the column can have NULL values
XO_NULLABLE_UNKNOWN - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate that the column's NULL value property is not known.
XO_TM_DAY_OF_MONTH - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for DAY OF THE MONTH
XO_TM_DAY_OF_WEEK - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for DAY OF THE WEEK
XO_TM_DAY_OF_YEAR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for DAY OF THE YEAR
XO_TM_FRACTION - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for number of billionths of a second
XO_TM_HOUR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for HOUR
XO_TM_IS_DST - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for DayLight Savings Time
XO_TM_MINUTE - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for MINUTE
XO_TM_MONTH - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for MONTH
XO_TM_SECOND - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for SECOND
XO_TM_YEAR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the index into the date object array for YEAR
XO_TYPE_BIGINT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is BIG INT
XO_TYPE_BINARY - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is BINARY
XO_TYPE_BIT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is BIT
XO_TYPE_CHAR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is CHAR
XO_TYPE_DATE - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is DATE
XO_TYPE_DECIMAL - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is DECIMAL
XO_TYPE_DEFAULT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is DEFAULT
XO_TYPE_DOUBLE - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is DOUBLE
XO_TYPE_FLOAT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is FLOAT
XO_TYPE_INTEGER - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is INTEGER
XO_TYPE_LONGVARBINARY - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is LONG VAR BINARY
XO_TYPE_LONGVARCHAR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is LONG VARCHAR
XO_TYPE_NUMERIC - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is NUMERIC
XO_TYPE_REAL - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is REAL
XO_TYPE_SMALL - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is SMALL
XO_TYPE_SMALLINT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is SMALL INT
XO_TYPE_TIME - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is TIME
XO_TYPE_TIMESTAMP - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is TIMESTAMP
XO_TYPE_TINYINT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is TINY INT
XO_TYPE_VARBINARY - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is VAR BINARY
XO_TYPE_VARCHAR - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is VARCHAR
XO_TYPE_VARIANT - Static variable in interface oajava.sql.sqlip_stmt: Constant to indicate the data type is VARIANT
xo_val - class oajava.sql.xo_val.: This class is basically allow IP writer to hold/change primitive type values.
xo_val() - Constructor for class oajava.sql.xo_val: Intialize the object with zero value.

D G N O S U X

Package

Class

Tree

Deprecated

Index

Help

PREV NEXT

FRAMES NO FRAMES