oajava.sql
Interface ip

public interface ip

A connection (session) with a specific database. Within the context of a Connection, SQL statements are executed and results are returned. The object is also used for executing a static SQL statement and obtaining the results produced by it.

Field Summary

static int	DAM_ABORT_OPERATION DAM notifies the IP to abort the operation when any of the specified resource quota exceeds.
static int	DAM_ALTER_TABLE Constant to indicate to IP that the query type is ALTER TABLE
static int	DAM_BIS_IGNORE_NONE Constant to indicate that DAM should not ignore blanks in strings, Used with DAM_CONN_OPTION_BLANKS_IN_STRINGS.
static int	DAM_BIS_IGNORE_TRAILING Constant to indicate that DAM should ignore trailing blanks and compare in strings, Used with DAM_CONN_OPTION_BLANKS_IN_STRINGS.
static int	DAM_CASCADE Constant to indicate DROP TABLE option of CASCADE
static int	DAM_CIL_IGNORE_ALL Constant to indicate that the LIKE processing is case insensitive, used with DAM_CONN_OPTION_CASE_IN_LIKE.
static int	DAM_CIL_IGNORE_NONE Constant to indicate that LIKE processing should not be case sensitive, used with DAM_CONN_OPTION_CASE_IN_LIKE.
static int	DAM_CIS_IGNORE_ALL Constant to indicate that DAM should perform case insensitive string comparisons, Used with DAM_CONN_OPTION_CASE_IN_STRINGS.
static int	DAM_CIS_IGNORE_NONE Constant to indicate that DAM should not ignore case in string comparisons , Used with DAM_CONN_OPTION_CASE_IN_STRINGS.
static int	DAM_CLOSE Constant to indicate to IP that the current select processing should be closed.
static int	DAM_COL_IN_CONDITION Constant to indicate the column is used in the Query condition.
static int	DAM_COL_IN_OUTPUT Constant to indicate the column used as return value or output value of a stored proc.
static int	DAM_COL_IN_RESULT Constant to indicate the column is part of the result set.
static int	DAM_COL_IN_SCHEMA Constant to indicate the column is defined in the schema database and applies to all columns.
static int	DAM_COL_IN_USE Constant to indicate the column is used in the query (either in result or in query condition).
static int	DAM_COL_SKIPPED_IN_RESULT Constant to indicate the column was not included in the result table of stored proc.
static int	DAM_COMMIT Constant to indicate that Transaction should be COMMITED
static int	DAM_CONDLIST_OPTION Constant used to indicate the option specified for dam_setOption is a Condition List Option
static int	DAM_CONDLIST_OPTION_EVALUATION Constant that indicates option to skip evaluation of condition list during dam_isTargetRow() it IP has already evaluated it
static int	DAM_CONN_OPTION Constant used to indicate the option specified for dam_setOption is a Connection Option
static int	DAM_CONN_OPTION_BLANKS_IN_STRINGS Constant that indicates option to ignore trailing blanks in strings during compares
static int	DAM_CONN_OPTION_CASE_IN_LIKE Constant that indicates option to ignore case of characters in LIKE processing
static int	DAM_CONN_OPTION_CASE_IN_STRINGS Constant that indicates option to ignore case of characters in strings during compares
static int	DAM_CONN_OPTION_INDEX_OPTIMIZATION Constant that indicates option to ignore index information during query optimization
static int	DAM_CONN_OPTION_NEGATIVE_ZERO_RESULT Constant that indicates option to ignore negative zero results from arithmetic operations
static int	DAM_CONN_OPTION_POST_PROCESSING Constant that indicates option to skip all post-processing.
static int	DAM_CREATE_INDEX Constant to indicate to IP that the query type is CREATE INDEX
static int	DAM_CREATE_ROLE Constant to indicate to IP that the command type is CREATE ROLE
static int	DAM_CREATE_TABLE Constant to indicate to IP that the query type is CREATE TABLE
static int	DAM_CREATE_USER Constant to indicate to IP that the command type is CREATE USER
static int	DAM_CREATE_VIEW Constant to indicate to IP that the query type is CREATE VIEW
static int	DAM_DELETE Constant to indicate to IP that the query type is DELETE
static int	DAM_DROP_INDEX Constant to indicate to IP that the query type is DROP INDEX
static int	DAM_DROP_ROLE Constant to indicate to IP that the command type is DROP ROLE
static int	DAM_DROP_TABLE Constant to indicate to IP that the query type is DROP TABLE
static int	DAM_DROP_USER Constant to indicate to IP that the command type is DROP USER
static int	DAM_DROP_VIEW Constant to indicate to IP that the query type is DROP VIEW
static int	DAM_DSP_EXECUTE onstant to indicate to IP to Execute the Dynamic Stored Procedure to process the next resultset
static int	DAM_DSP_INIT Constant to indicate to IP to Initialise the Dynamic Stored procedure execution
static int	DAM_END_QUERY Constant to indicate to IP the end of a multiple sub-query execution sequence on the same table.
static int	DAM_ERROR Constant to indicate that routine returns the Error
static int	DAM_FAILURE Constant to indicate IP Routine had an Error
static int	DAM_FALSE Constant to indicate IP that the routine returns the Truth value of False
static int	DAM_FETCH Constant to indicate to IP that the next result set should be Fetched
static int	DAM_GRANT Constant to indicate to IP that the command type is GRANT
static int	DAM_INDEX_CLUSTERED Constant to indicate that the Index type is Clustered Index
static int	DAM_INDEX_HASHED Constant to indicate that the Index type is HASHED
static int	DAM_INDEX_IGNORE_ALL Constant to indicate that the default optimization to identify a search column should be disabled, used with DAM_CONN_OPTION_INDEX_OPTIMIZATION.
static int	DAM_INDEX_IGNORE_NONE Constant to indicate that the default optimization to identify a search column should be enabled, used with DAM_CONN_OPTION_INDEX_OPTIMIZATION.
static int	DAM_INDEX_OTHER Constant to indicate that the Index type is some other type
static int	DAM_INDEX_PRIMARY_KEY Constant to indicate that the Index is a PRIMARY KEY
static int	DAM_INDEX_UNIQUE_KEY Constant to indicate that the Index is a UNIQUE KEY
static int	DAM_INDEX_UNIQUE_PRIMARY_KEY Constant to indicate that the Index is a UNIQUE and PRIMARY KEY
static int	DAM_INFO_CLIENT_ADDRESS Constant to retrieve the IP address of the client as a string of the form 'ddd.ddd.ddd.ddd'.
static int	DAM_INFO_CLNT_KEY Constant to retrieve the client key information
static int	DAM_INFO_CONNECT_STRING Constant to retrieve the connect string as specified by the client application.
static int	DAM_INFO_DATABASE Constant to retrieve the database name.
static int	DAM_INFO_DATABASE_NAME Constant to retrieve the database name.
static int	DAM_INFO_DISTINCT_OPTIMIZABLE Constant to check if query has a SELECT DISTINCT clause that can be processed by the IP.
static int	DAM_INFO_DTC_GUID Constant to retrieve the unique ID to identify DTC at the time of recovery of distributed transaction.
static int	DAM_INFO_ESTIMATED_NUM_SUBQUERIES Constant to retrieve the estimated number of subqueries that the query was split into.
static int	DAM_INFO_FETCH_BLOCK_SIZE Constant to retrieve the number of rows to be fetched each time EXECUTE is called.
static int	DAM_INFO_GROUP_BY_OPTIMIZABLE Constant to check if query has GROUP BY clause can be processed by IP.
static int	DAM_INFO_IP_HDBC Constant to retrieve the IP connection pointer that was returned when CONNECT was called.
static int	DAM_INFO_ISLOWER_FUNC Constant to set the replacement function for ISLOWER().
static int	DAM_INFO_ISUPPER_FUNC Constant to set the replacement function for ISUPPER().
static int	DAM_INFO_JOIN_QUERY_SIZE Constant to retrieve the size (in number of tables) of the join query being processed
static int	DAM_INFO_MEMCMP_FUNC Constant to set the replacement function for MEMCMP().
static int	DAM_INFO_MODE Constant to retrieve the Mode (damisql, server) in which the IP is being used.
static int	DAM_INFO_OPENRDA_INI Constant to retrieve the path and the file name that is being used for the OpenRDA configuration information.
static int	DAM_INFO_ORDER_BY_OPTIMIZABLE Constant to check if query has ORDER BY clause can be processed by IP.
static int	DAM_INFO_ORIGINAL_QUERY_STRING Constant to retrieve the SQL string as specified by the application.
static int	DAM_INFO_QUERY_HAS_NOWAIT Constant to check if NOWAIT clause was specified in the SELECT FOR UPDATE query.
static int	DAM_INFO_QUERY_HAS_SEARCH_CONDITION Constant to check if a query has a where clause.
static int	DAM_INFO_QUERY_IS_NESTED Constant to check if the current query is a inner query or outer query
static int	DAM_INFO_QUERY_PROCESS_ORDER Constant to retrieves the process order of the current table in the join query.
static int	DAM_INFO_QUERY_TYPE Constant to retrieve the Type of the Query being processed.
static int	DAM_INFO_RM_GUID Constant to retrieve the resource manager ID of the current MTS transaction.
static int	DAM_INFO_SCHEMA_PATH Constant to retrieve the schema path for the connection.
static int	DAM_INFO_SECURITY_HANDLE Constant to retrieve a pointer to the security information structure of type OA_AUTH_CONTEXT.
static int	DAM_INFO_SET_FUNCTIONS_IN_QUERY Constant to check which set functions are used in the query.
static int	DAM_INFO_SRVR_KEY Constant to retrieve the server key information
static int	DAM_INFO_STMT_IP_CONTEXT Constant to retrieve a pointer to IP defined data structure that needs to persist across all queries executed to handle the requested query.
static int	DAM_INFO_STRCMP_FUNC Constant to set the replacement function for STRCMP().
static int	DAM_INFO_STRICMP_FUNC Constant to set the replacement function for STRICMP().
static int	DAM_INFO_STRLWR_FUNC Constant to set the replacement function for STRLWR().
static int	DAM_INFO_STRNCMP_FUNC Constant to set the replacement function for STRNCMP().
static int	DAM_INFO_STRNICMP_FUNC Constant to set the replacement function for STRNICMP().
static int	DAM_INFO_STRUPR_FUNC Constant to set the replacement function for STRUPR().
static int	DAM_INFO_THREADING_MODE Constant to check if threads are enabled
static int	DAM_INFO_TOLOWER_FUNC Constant to set the replacement function for TOLOWER().
static int	DAM_INFO_TOUPPER_FUNC Constant to set the replacement function for TOUPPER().
static int	DAM_INFO_TXN_ID Constant to retrieve the transaction ID of the current MTS transaction.
static int	DAM_INFO_TXN_INFO Constant to retrieve the transaction information associated with the current MTS transaction.
static int	DAM_INFO_TXN_TYPE Constant to indicate the information about the current mode of transaction processing
static int	DAM_INFO_USER Constant to retrieve the User name.
static int	DAM_INSERT Constant to indicate to IP that the query type is INSERT
static int	DAM_LEFT_DATA Constant to indicate left part of a condition
static int	DAM_MAX_ID_LEN Constant used in Internal Implementation
static int	DAM_MAX_INFO_VALUE Constant to identify the Maximum value of the INFO type constants that is supported by dam_getInfo()
static int	DAM_MAXPATH Constant to identify the size for filepath buffers
static int	DAM_NA Constant to indicate that routine returns as Truth value not knowm
static int	DAM_NATIVE_COMMAND Constant used in Internal Implementation.
static int	DAM_NC_EXECUTE Constant to indicate to IP to execute the Native Command and return the number of rows affected.
static int	DAM_NC_VALIDATE Constant to indicate to IP to validate the Native Command
static int	DAM_NO_DATA_FOUND Constant to indicate IP as End of Data list
static int	DAM_NOT_AVAILABLE Constant to indicate IP Routine had an error as Data Source was not available
static int	DAM_NOT_SET Constant to indicate the Number of the column when it is not used.
static int	DAM_NZR_CONVERT_ALL Constant to indicate that Negative zeros should be converted to zero
static int	DAM_NZR_CONVERT_NONE Constant to indicate that Negative zeros should not be converted to zero
static int	DAM_PREPARE_TO_COMMIT Constant to indicate that Transaction should be prepared to commit.
static int	DAM_PROCEDURE Constant used in Internal Implementation.
static int	DAM_PROCESSING_OFF Constant to indicate that DAM should not process the option (GROUP BY, ORDE RBY, DISTINCT etc)
static int	DAM_PROCESSING_ON Constant to indicate that DAM should process the option (GROUP BY, ORDE RBY, DISTINCT etc).
static int	DAM_RESTRICT Constant to indicate DROP TABLE option of RESTRICT
static int	DAM_REVOKE Constant to indicate to IP that the command type is REVOKE
static int	DAM_RIGHT_DATA Constant to indicate right part of a condition
static int	DAM_ROLLBACK Constant to indicate that Transaction should be ROLLED BACK
static int	DAM_SELECT Constant to indicate to IP that the query type is SELECT.
static int	DAM_SELECT_FOR_UPDATE Constant to indicate to IP that the query type is SELECT FOR UPDATE
static int	DAM_START_QUERY Constant to indicate to IP the beginning of a multiple sub-query execution sequence on the same table.
static int	DAM_STMT_OPTION Constant used to indicate the option specified for dam_setOption is a Statement Option
static int	DAM_STMT_OPTION_DISTINCT Constant that indicates option to skip DISTINCT processing if IP has already processed the result set
static int	DAM_STMT_OPTION_GROUP_BY Constant that indicates option to skip group by processing if IP has already processed the result set
static int	DAM_STMT_OPTION_ORDER_BY Constant that indicates option to skip order by processing if IP has already processed the result set
static int	DAM_SUCCESS Constant to indicate IP Routine was Succesful
static int	DAM_SUCCESS_WITH_INFO Constant to indicate IP that Routine was successful with information.
static int	DAM_SUCCESS_WITH_MORE_RESULT_SETS Constant to indicate that IP notifes DAM that it still has additional result sets
static int	DAM_SUCCESS_WITH_RESULT_CACHED Constant to DAM routines indicate that result set is cached to disk storage
static int	DAM_SUCCESS_WITH_RESULT_PENDING Constant to indicate that IP notifies DAM that it only returned partial result set
static int	DAM_SUCCESS_WITH_VIEW Constant to indicate IP Statement contain view(s)
static int	DAM_TABLE_STAT Constant to indicate that the Index information is a Table Statistic
static int	DAM_TRUE Constant to indicate IP that the routine returns the Truth value of Truth
static int	DAM_UPDATE Constant to indicate to IP that the query type is UPDATE
static int	DAMOBJ_MAX_EXT_LEN Constant used in Internal Implementation
static int	DAMOBJ_MAX_ID_LEN Constant to identify the maximum length of identifiers (table name, column name etc)
static int	DAMOBJ_NOTSET Constant used to indicate that the schema object's field value is NULL (not set)
static int	DAMOBJ_SET Constant used to indicate that the schema object's field value is set
static int	DAMOBJ_TYPE_COLUMN Constant to indicate the schema object type as COLUMN
static int	DAMOBJ_TYPE_FKEY Constant to indicate the schema object type as FOREIGN KEY
static int	DAMOBJ_TYPE_PROC Constant to indicate the schema object type as PROCEDURE
static int	DAMOBJ_TYPE_PROC_COLUMN Constant to indicate the schema object type as PROCEDURE COLUMN
static int	DAMOBJ_TYPE_STAT Constant to indicate the schema object type as STATISTICS
static int	DAMOBJ_TYPE_TABLE Constant to indicate the schema object type as TABLE
static int	FALSE Constant to indicate boolean value of FALSE
static int	IP_COL_IGNORE_CASE Constant to indicate if case should be ignored during comparison of column value
static int	IP_COL_SUPPORT_BETWEEN Constant to indicate that IP supports BETWEEN condition on the column
static int	IP_COL_SUPPORT_DEFAULT_VALUE Constant to indicate if IP supports DEFAULT VALUE for the column during INSERTS.
static int	IP_COL_SUPPORT_EQUAL Constant to indicate that IP supports EQUAL(=) condition on the column
static int	IP_COL_SUPPORT_GREATER Constant to indicate that IP supports GREATER THAN(>) condition on the column
static int	IP_COL_SUPPORT_ISNULL Constant to indicate that IP supports IS NULL condition on the column
static int	IP_COL_SUPPORT_LIKE Constant to indicate that IP supports LIKE condition on the column
static int	IP_COL_SUPPORT_NOT Constant to indicate that IP supports NOT condition on the column
static int	IP_COL_SUPPORT_SMALLER Constant to indicate that IP supports SMALLER THAN(<) condition on the column
static int	IP_FAILURE Constant to indicate IP that the Routine had an Error
static int	IP_INFO_FILTER_VIEWS_WITH_QUALIFIER_NAME Constant to retrieve the IP preference for how Catalog functions should return views
static int	IP_INFO_MULTI_COLUMN_INDEX_FILTER Constant to retrieve the IP preference for how multi column indexes should be processed
static int	IP_INFO_QUALIFIER_NAME Constant to retrieve the default qualifier value for this connection
static int	IP_INFO_SUPPORT_SCHEMA_SEARCH_PATTERN Constant to retrieve the IP preference for search patterns in schema objects
static int	IP_INFO_VERSION Constant to retrieve the Version as a string of format ##.##
static int	IP_MAX_ERROR_MSG_LEN Constant to indicate the maximum length of error message.
static int	IP_MAX_INFO_VALUE Constant to identify the Maximum value of the INFO type constants that should be supported by ipGetInfo()
static int	IP_MAX_STR_INFO_LEN Constant to indicate the buffer length for getting string values from dam_getInfo.
static int	IP_SUCCESS Constant to indicate IP that the Routine was Succesful
static int	IP_SUPPORT_ALL Constant used in Internal Implementation.
static int	IP_SUPPORT_ALTER_TABLE Constant to indicate IP support for ALTER TABLE command
static int	IP_SUPPORT_ARRAY_SIZE Constant to indicate the maximum size of the IP_SUPPORT_ARRAY array.
static int	IP_SUPPORT_CREATE_INDEX Constant to indicate IP support for CREATE INDEX command
static int	IP_SUPPORT_CREATE_ROLE Constant to indicate IP support for CREATE ROLE command
static int	IP_SUPPORT_CREATE_TABLE Constant to indicate IP support for CREATE TABLE command
static int	IP_SUPPORT_CREATE_USER Constant to indicate IP support for CREATE USER command
static int	IP_SUPPORT_CREATE_VIEW Constant to indicate IP support for CREATE VIEW command
static int	IP_SUPPORT_DELETE Constant to indicate IP support for DELETE query
static int	IP_SUPPORT_DROP_INDEX Constant to indicate IP support for DROP INDEX command
static int	IP_SUPPORT_DROP_ROLE Constant to indicate IP support for DROP ROLE command
static int	IP_SUPPORT_DROP_TABLE Constant to indicate IP support for DROP TABLE command
static int	IP_SUPPORT_DROP_USER Constant to indicate IP support for DROP USER command
static int	IP_SUPPORT_DROP_VIEW Constant to indicate IP support for DROP VIEW command
static int	IP_SUPPORT_END_QUERY Constant to indicate IP support for DAM_END_QUERY in ipExecute() method
static int	IP_SUPPORT_GRANT Constant to indicate IP support for GRANT command
static int	IP_SUPPORT_INSERT Constant to indicate IP support for INSERT query
static int	IP_SUPPORT_NATIVE_COMMAND Constant to indicate IP support for Native commands
static int	IP_SUPPORT_OP_BETWEEN Constant to indicate IP support for BETWEEN condition
static int	IP_SUPPORT_OP_EQUAL Constant to indicate IP support for EQUAL condition
static int	IP_SUPPORT_OP_GREATER Constant to indicate IP support for GREATER THAN condition
static int	IP_SUPPORT_OP_LIKE Constant to indicate IP support for LIKE condition
static int	IP_SUPPORT_OP_NOT Constant to indicate IP support for NOT condition
static int	IP_SUPPORT_OP_NULL CConstant to indicate IP support for NULL condition
static int	IP_SUPPORT_OP_SMALLER Constant to indicate IP support for SMALLER THAN condition
static int	IP_SUPPORT_PRIVILEGES Constant to indicate IP support for User Privilege validation
static int	IP_SUPPORT_PROCEDURE Constant to indicate IP support for Stored Procedure query
static int	IP_SUPPORT_PUSHDOWN_QUERY Constant to indicate IP support for Pass Through mode of query processing
static int	IP_SUPPORT_QUERY_VIEW Constant to indicate IP support for queries on VIEWS
static int	IP_SUPPORT_REVOKE Constant to indicate IP support for REVOKE command
static int	IP_SUPPORT_SCHEMA Constant to indicate IP support for Dynamic Schema
static int	IP_SUPPORT_SELECT Constant to indicate IP support for SELECT query
static int	IP_SUPPORT_SELECT_FOR_UPDATE Constant to indicate IP support for SELECT FOR UPDATE query
static int	IP_SUPPORT_START_QUERY Constant to indicate IP support for DAM_START_QUERY in ipExecute() method
static int	IP_SUPPORT_UNION_CONDLIST Constant to indicate IP wants search expression to be processed as UNION condition lists
static int	IP_SUPPORT_UPDATE Constant to indicate IP support for UPDATE query
static int	IP_TABLE_SUPPORT_ALTER_TABLE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_CREATE_INDEX Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_CREATE_ROLE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_CREATE_TABLE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_CREATE_USER Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_CREATE_VIEW Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_DELETE Constant to indicate that IP supports DELETE query on the table.
static int	IP_TABLE_SUPPORT_DROP_INDEX Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_DROP_ROLE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_DROP_TABLE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_DROP_USER Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_DROP_VIEW Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_END_QUERY Constant to indicate that IP supports DAM_END_QUERY when processing the table
static int	IP_TABLE_SUPPORT_GRANT Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_INSERT Constant to indicate that IP supports INSERT query on the table.
static int	IP_TABLE_SUPPORT_PRIVILEGES Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_PROCEDURE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_QUERY_VIEW Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_REVOKE Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_SELECT Constant to indicate that IP supports SELECT query on the table.
static int	IP_TABLE_SUPPORT_SELECT_FOR_UPDATE Constant to indicate that IP supports SELECT FOR UPDATE query on the table.
static int	IP_TABLE_SUPPORT_START_QUERY Constant to indicate that IP supports DAM_START_QUERY when processing the table
static int	IP_TABLE_SUPPORT_UNION_CONDLIST Constant used in Internal Implementation.
static int	IP_TABLE_SUPPORT_UPDATE Constant to indicate that IP supports UPDATE query on the table.
static int	IP_TEMP_BUF_SIZE Constant used in Internal Implementation.
static int	IP_VERSION Constant to retrieve the Version as a string of format ##.##
static int	MAX_CONNECT_STR_LEN Constant to indicate the maximum length of Connect String.
static int	SQL_ADD_COLUMN Constant used in ALTER table to indicate that Column should be Added.
static int	SQL_ADD_CONSTRAINT Constant to indicate that the constraint in ALTER table should be added
static int	SQL_ALTER_COLUMN Constant used in ALTER table to indicate that Column should be Altered.
static int	SQL_BEST_ROWID Constant to indicate that the column uniquely identifies the row
static int	SQL_DROP_COLUMN Constant used in ALTER table to indicate that Column should be Dropped.
static int	SQL_DROP_CONSTRAINT Constant to indicate that the constraint in ALTER table should be removed
static int	SQL_EXP_AND Constant to indicate that the Logical Expression is a AND expression
static int	SQL_EXP_COND Constant to indicate that the Logical Expression is a Condition
static int	SQL_EXP_NOT Constant to indicate that the Logical Expression is a NOT expression
static int	SQL_EXP_OR Constant to indicate that the Logical Expression is a OR expression
static int	SQL_F_AVG Constant to indicate that Aggregate function is AVG(expression)
static int	SQL_F_COUNT Constant to indicate that Aggregate function is COUNT(expression)
static int	SQL_F_COUNT_ALL Constant to indicate that Aggregate function is COUNT(*)
static int	SQL_F_DISTINCT Constant to indicate that Aggregate function expression has a DISTINCT quantifier (DISTINCT expression)
static int	SQL_F_MAX Constant to indicate that Aggregate function is MAX(expression)
static int	SQL_F_MIN Constant to indicate that Aggregate function is MIN(expression)
static int	SQL_F_NONE Constant to indicate that no Aggregate function is used
static int	SQL_F_SUM Constant to indicate that Aggregate function is SUM(expression)
static int	SQL_INDEX_CLUSTERED Constant that indicates a clustered index
static int	SQL_INDEX_HASHED Constant that indicates a hashed index
static int	SQL_INDEX_OTHER Constant that indicates another type of index
static int	SQL_JOIN_FULL_OUTER Constant to indicate that Join type is FULL OUTER JOIN
static int	SQL_JOIN_INNER Constant to indicate that Join type is INNER JOIN
static int	SQL_JOIN_LEFT_OUTER Constant to indicate that Join type is LEFT OUTER JOIN
static int	SQL_JOIN_OLD_STYLE Constant to indicate that Join type is OLD STYLE JOIN
static int	SQL_JOIN_RIGHT_OUTER Constant to indicate that Join type is RIGHT OUTER JOIN
static int	SQL_OBJ_PRIV_ALL Constant to indicate system privilege for all Operations
static int	SQL_OBJ_PRIV_ALTER Constant to indicate ALTER query privilege for the object
static int	SQL_OBJ_PRIV_DELETE Constant to indicate DELETE query privilege for the object
static int	SQL_OBJ_PRIV_EXECUTE Constant to indicate EXECUTE query privilege for the object
static int	SQL_OBJ_PRIV_INDEX Constant to indicate INDEX query privilege for the object
static int	SQL_OBJ_PRIV_INSERT Constant to indicate INSERT query privilege for the object
static int	SQL_OBJ_PRIV_SELECT Constant to indicate SELECT query privilege for the object
static int	SQL_OBJ_PRIV_UPDATE Constant to indicate UPDATE query privilege for the object
static int	SQL_OP_BETWEEN Constant to indicate the operator in the condition is BETWEEN.
static int	SQL_OP_BETWEEN_OPEN_LEFT Constant to indicate the operator in the condition is a BETWEEN where the left condition on Between is open.
static int	SQL_OP_BETWEEN_OPEN_RIGHT Constant to indicate the operator in the condition is a BETWEEN where the right condition on Between is open Its > and not >=.
static int	SQL_OP_DEFAULT_VALUE Constant to indicate that the Database will provide default value for this field during INSERTS.
static int	SQL_OP_EQUAL Constant to indicate the operator in the condition is EQUAL(=).
static int	SQL_OP_EXISTS Constant to indicate the operator in the condition is EXISTS.
static int	SQL_OP_GREATER Constant to indicate the operator in the condition is GREATER THAN(>).
static int	SQL_OP_IGNORE_BLANKS Constant to indicate the Database to ignore blanks.
static int	SQL_OP_IGNORE_CASE Constant to indicate the Database to ignore case when performing string compares.
static int	SQL_OP_IN Constant to indicate the operator in the condition is IN.
static int	SQL_OP_ISNULL Constant to indicate the operator in the condition is ISNULL.
static int	SQL_OP_LIKE Constant to indicate the operator in the condition is LIKE.
static int	SQL_OP_NOT Constant to indicate the operator in the condition is NOT.
static int	SQL_OP_QUANTIFIER_ALL Constant to indicate the quantifier in the condition is ALL ( = ALL (subquery) ).
static int	SQL_OP_QUANTIFIER_ANY Constant to indicate the quantifier in the condition is ANY ( = ANY (subquery) ).
static int	SQL_OP_QUANTIFIER_SOME Constant to indicate the quantifier in the condition is SOME ( = SOME (subquery) ).
static int	SQL_OP_SMALLER Constant to indicate the operator in the condition is SMALLER THAN(<).
static int	SQL_OP_UNIQUE Constant to indicate the operator in the condition is UNIQUE.
static int	SQL_ORDER_ASC Constant to indicate that the ORDER BY is Ascending.
static int	SQL_ORDER_DESC Constant to indicate that the ORDER BY is Descending.
static int	SQL_ORDER_NOTSET Constant to indicate that the ORDER BY ordering was not set.
static int	SQL_PARAM_INPUT Constant to indicate that the procedure column is an input parameter.
static int	SQL_PARAM_INPUT_OUTPUT Constant to indicate that the procedure column is an input/output parameter.
static int	SQL_PARAM_OUTPUT Constant to indicate that the procedure column is an output parameter.
static int	SQL_PARAM_TYPE_UNKNOWN Constant to indicate that the procedure column is a parameter whose type is unknown.
static int	SQL_PC_NOT_PSEUDO Constant to indicate the the column is a regular column and not PSEUDO_COLUMN
static int	SQL_PC_PSEUDO Constant to indicate the column as PSEUDO_COLUMN
static int	SQL_PC_UNKNOWN Constant to indicate the column's PSEUDO_COLUMN property is not known
static int	SQL_PT_FUNCTION Constant to indicate that the Procedure has a return value.
static int	SQL_PT_PROCEDURE Constant to indicate that the Procedure does not have a return value.
static int	SQL_PT_UNKNOWN Constant to indicate that the Procedure is UNKNOWN Procedure.
static int	SQL_RESULT_COL Constant to indicate that the procedure column is a result set column.
static int	SQL_RETURN_VALUE Constant to indicate that the procedure column is the return value of the procedure.
static int	SQL_ROWVER Constant to indicate that the column constains the version information for the row typically maintained by the Database
static int	SQL_SCOPE_CURROW Constant to indicate that the rowid is guaranteed to be valid only while positioned on that row.
static int	SQL_SCOPE_SESSION Constant to indicate that the rowid is guaranteed to be valid for the duration of the session (across transaction boundaries).
static int	SQL_SCOPE_TRANSACTION Constant to indicate that the rowid is guaranteed to be valid for the duration of the current transaction.
static int	SQL_SET_CONDLIST_INTERSECT Constant to indicate that condition list type is INTERSECT list ((cond1 OR cond2..) AND (cond3 OR cond4..) AND ...)
static int	SQL_SET_CONDLIST_UNION Constant to indicate that condition list type is UNION list ((cond1 AND cond2..) OR (cond3 AND cond4..) OR ...)
static int	SQL_SYS_PRIV_ALTER_ANY_INDEX Constant to indicate system privilege to ALTER any Index
static int	SQL_SYS_PRIV_ALTER_ANY_TABLE Constant to indicate system privilege to ALTER any Table
static int	SQL_SYS_PRIV_CREATE_ANY_INDEX Constant to indicate system privilege to CREATE any Index
static int	SQL_SYS_PRIV_CREATE_ANY_PROCEDURE Constant to indicate system privilege to CREATE any Procedure
static int	SQL_SYS_PRIV_CREATE_ANY_ROLE Constant to indicate system privilege to CREATE any Role
static int	SQL_SYS_PRIV_CREATE_ANY_TABLE Constant to indicate system privilege to CREATE any Table
static int	SQL_SYS_PRIV_CREATE_ANY_USER Constant to indicate system privilege to CREATE any User
static int	SQL_SYS_PRIV_CREATE_ANY_VIEW Constant to indicate system privilege to CREATE any View
static int	SQL_SYS_PRIV_CREATE_PROCEDURE Constant to indicate system privilege to CREATE Procedure
static int	SQL_SYS_PRIV_CREATE_ROLE Constant to indicate system privilege to CREATE Role
static int	SQL_SYS_PRIV_CREATE_TABLE Constant to indicate system privilege to CREATE Table
static int	SQL_SYS_PRIV_CREATE_USER Constant to indicate system privilege to CREATE User
static int	SQL_SYS_PRIV_CREATE_VIEW Constant to indicate system privilege to CREATE View
static int	SQL_SYS_PRIV_DELETE_ANY_TABLE Constant to indicate system privilege to DELETE any Table
static int	SQL_SYS_PRIV_DROP_ANY_INDEX Constant to indicate system privilege to DROP any Index
static int	SQL_SYS_PRIV_DROP_ANY_PROCEDURE Constant to indicate system privilege to DROP any Procedure
static int	SQL_SYS_PRIV_DROP_ANY_ROLE Constant to indicate system privilege to DROP any Role
static int	SQL_SYS_PRIV_DROP_ANY_TABLE Constant to indicate system privilege to DROP any Table
static int	SQL_SYS_PRIV_DROP_ANY_USER Constant to indicate system privilege to DROP any User
static int	SQL_SYS