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	_OA_DOTNET_ Constant to indicate Client is DOTNET
static int	_OA_JDBC_ Constant to indicate Client is JDBC
static int	_OA_ODBC_ Constant to indicate Client is ODBC
static int	_OA_OLEDB_ Constant to indicate Client is OLEDB
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_JOINORDER_USING_FKEY Constant that indicates option to skip fkey based ordering
static int	DAM_CONN_OPTION_JOINORDER_USING_SEARCHCONDITION Constant that indicates option to skip search condition based ordering
static int	DAM_CONN_OPTION_JOINORDER_VERIFY_INDEX_ON_JOIN_CONDITION Constant that indicates option to join ordering should verify that inner tables have index on join column
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_ERR_00000
static int	DAM_ERR_01000
static int	DAM_ERR_01002
static int	DAM_ERR_01004
static int	DAM_ERR_01006
static int	DAM_ERR_01S00
static int	DAM_ERR_01S01
static int	DAM_ERR_01S02
static int	DAM_ERR_01S03
static int	DAM_ERR_01S04
static int	DAM_ERR_07001
static int	DAM_ERR_07006
static int	DAM_ERR_08001
static int	DAM_ERR_08002
static int	DAM_ERR_08003
static int	DAM_ERR_08004
static int	DAM_ERR_08007
static int	DAM_ERR_08S01
static int	DAM_ERR_21S01
static int	DAM_ERR_21S02
static int	DAM_ERR_22001
static int	DAM_ERR_22003
static int	DAM_ERR_22005
static int	DAM_ERR_22008
static int	DAM_ERR_22012
static int	DAM_ERR_22026
static int	DAM_ERR_23000
static int	DAM_ERR_24000
static int	DAM_ERR_25000
static int	DAM_ERR_28000
static int	DAM_ERR_34000
static int	DAM_ERR_37000
static int	DAM_ERR_3C000
static int	DAM_ERR_40001
static int	DAM_ERR_42000
static int	DAM_ERR_70100
static int	DAM_ERR_IM001
static int	DAM_ERR_IM002
static int	DAM_ERR_IM003
static int	DAM_ERR_IM004
static int	DAM_ERR_IM005
static int	DAM_ERR_IM006
static int	DAM_ERR_IM007
static int	DAM_ERR_IM008
static int	DAM_ERR_IM009
static int	DAM_ERR_IM010
static int	DAM_ERR_IM011
static int	DAM_ERR_IM012
static int	DAM_ERR_IM013
static int	DAM_ERR_LAST
static int	DAM_ERR_S0001
static int	DAM_ERR_S0002
static int	DAM_ERR_S0011
static int	DAM_ERR_S0012
static int	DAM_ERR_S0021
static int	DAM_ERR_S0022
static int	DAM_ERR_S0023
static int	DAM_ERR_S1000
static int	DAM_ERR_S1001
static int	DAM_ERR_S1002
static int	DAM_ERR_S1003
static int	DAM_ERR_S1004
static int	DAM_ERR_S1008
static int	DAM_ERR_S1009
static int	DAM_ERR_S1010
static int	DAM_ERR_S1011
static int	DAM_ERR_S1012
static int	DAM_ERR_S1015
static int	DAM_ERR_S1090
static int	DAM_ERR_S1091
static int	DAM_ERR_S1092
static int	DAM_ERR_S1093
static int	DAM_ERR_S1094
static int	DAM_ERR_S1095
static int	DAM_ERR_S1096
static int	DAM_ERR_S1097
static int	DAM_ERR_S1098
static int	DAM_ERR_S1099
static int	DAM_ERR_S1100
static int	DAM_ERR_S1101
static int	DAM_ERR_S1103
static int	DAM_ERR_S1104
static int	DAM_ERR_S1105
static int	DAM_ERR_S1106
static int	DAM_ERR_S1107
static int	DAM_ERR_S1108
static int	DAM_ERR_S1109
static int	DAM_ERR_S1110
static int	DAM_ERR_S1111
static int	DAM_ERR_S1C00
static int	DAM_ERR_S1T00
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_IERR_001
static int	DAM_IERR_002
static int	DAM_IERR_003
static int	DAM_IERR_004
static int	DAM_IERR_005
static int	DAM_IERR_006
static int	DAM_IERR_007
static int	DAM_IERR_008
static int	DAM_IERR_009
static int	DAM_IERR_010
static int	DAM_IERR_011
static int	DAM_IERR_012
static int	DAM_IERR_013
static int	DAM_IERR_014
static int	DAM_IERR_015
static int	DAM_IERR_016
static int	DAM_IERR_017
static int	DAM_IERR_018
static int	DAM_IERR_019
static int	DAM_IERR_020
static int	DAM_IERR_021
static int	DAM_IERR_022
static int	DAM_IERR_023
static int	DAM_IERR_024
static int	DAM_IERR_025
static int	DAM_IERR_026
static int	DAM_IERR_027
static int	DAM_IERR_028
static int	DAM_IERR_029
static int	DAM_IERR_030
static int	DAM_IERR_031
static int	DAM_IERR_032
static int	DAM_IERR_033
static int	DAM_IERR_034
static int	DAM_IERR_035
static int	DAM_IERR_036
static int	DAM_IERR_037
static int	DAM_IERR_038
static int	DAM_IERR_039
static int	DAM_IERR_040
static int	DAM_IERR_041
static int	DAM_IERR_042
static int	DAM_IERR_043
static int	DAM_IERR_044
static int	DAM_IERR_045
static int	DAM_IERR_046
static int	DAM_IERR_047
static int	DAM_IERR_048
static int	DAM_IERR_049
static int	DAM_IERR_050
static int	DAM_IERR_051
static int	DAM_IERR_052
static int	DAM_IERR_053
static int	DAM_IERR_054
static int	DAM_IERR_055
static int	DAM_IERR_056
static int	DAM_IERR_057
static int	DAM_IERR_058
static int	DAM_IERR_059
static int	DAM_IERR_060
static int	DAM_IERR_061
static int	DAM_IERR_062
static int	DAM_IERR_063
static int	DAM_IERR_064
static int	DAM_IERR_065
static int	DAM_IERR_066
static int	DAM_IERR_067
static int	DAM_IERR_068
static int	DAM_IERR_069
static int	DAM_IERR_070
static int	DAM_IERR_071
static int	DAM_IERR_072
static int	DAM_IERR_073
static int	DAM_IERR_074
static int	DAM_IERR_075
static int	DAM_IERR_076
static int	DAM_IERR_077
static int	DAM_IERR_078
static int	DAM_IERR_079
static int	DAM_IERR_080
static int	DAM_IERR_081
static int	DAM_IERR_082
static int	DAM_IERR_083
static int	DAM_IERR_084
static int	DAM_IERR_085
static int	DAM_IERR_086
static int	DAM_IERR_087
static int	DAM_IERR_088
static int	DAM_IERR_089
static int	DAM_IERR_090
static int	DAM_IERR_091
static int	DAM_IERR_092
static int	DAM_IERR_093
static int	DAM_IERR_094
static int	DAM_IERR_095
static int	DAM_IERR_096
static int	DAM_IERR_097
static int	DAM_IERR_098
static int	DAM_IERR_099
static int	DAM_IERR_100
static int	DAM_IERR_101
static int	DAM_IERR_102
static int	DAM_IERR_103
static int	DAM_IERR_104
static int	DAM_IERR_105
static int	DAM_IERR_106
static int	DAM_IERR_107
static int	DAM_IERR_108
static int	DAM_IERR_109
static int	DAM_IERR_110
static int	DAM_IERR_111
static int	DAM_IERR_112
static int	DAM_IERR_113
static int	DAM_IERR_114
static int	DAM_IERR_115
static int	DAM_IERR_116
static int	DAM_IERR_117
static int	DAM_IERR_118
static int	DAM_IERR_119
static int	DAM_IERR_120
static int	DAM_IERR_121
static int	DAM_IERR_122
static int	DAM_IERR_123
static int	DAM_IERR_124
static int	DAM_IERR_125
static int	DAM_IERR_126
static int	DAM_IERR_127
static int	DAM_IERR_128
static int	DAM_IERR_129
static int	DAM_IERR_130
static int	DAM_IERR_131
static int	DAM_IERR_132
static int	DAM_IERR_133
static int	DAM_IERR_134
static int	DAM_IERR_135
static int	DAM_IERR_136
static int	DAM_IERR_137
static int	DAM_IERR_138
static int	DAM_IERR_139
static int	DAM_IERR_140
static int	DAM_IERR_141
static int	DAM_IERR_142
static int	DAM_IERR_143
static int	DAM_IERR_144
static int	DAM_IERR_145
static int	DAM_IERR_146
static int	DAM_IERR_147
static int	DAM_IERR_148
static int	DAM_IERR_149
static int	DAM_IERR_150
static int	DAM_IERR_151
static int	DAM_IERR_152
static int	DAM_IERR_153
static int	DAM_IERR_154
static int	DAM_IERR_155
static int	DAM_IERR_156
static int	DAM_IERR_157
static int	DAM_IERR_158
static int	DAM_IERR_159
static int	DAM_IERR_160
static int	DAM_IERR_161
static int	DAM_IERR_162
static int	DAM_IERR_163
static int	DAM_IERR_164
static int	DAM_IERR_165
static int	DAM_IERR_166
static int	DAM_IERR_167
static int	DAM_IERR_168
static int	DAM_IERR_169
static int	DAM_IERR_170
static int	DAM_IERR_171
static int	DAM_IERR_172
static int	DAM_IERR_173
static int	DAM_IERR_174
static int	DAM_IERR_175
static int	DAM_IERR_176
static int	DAM_IERR_177
static int	DAM_IERR_178
static int	DAM_IERR_179
static int	DAM_IERR_180
static int	DAM_IERR_181
static int	DAM_IERR_182
static int	DAM_IERR_183
static int	DAM_IERR_184
static int	DAM_IERR_185
static int	DAM_IERR_186
static int	DAM_IERR_187
static int	DAM_IERR_188
static int	DAM_IERR_189
static int	DAM_IERR_190
static int	DAM_IERR_191
static int	DAM_IERR_192
static int	DAM_IERR_193
static int	DAM_IERR_194
static int	DAM_IERR_195
static int	DAM_IERR_196
static int	DAM_IERR_197
static int	DAM_IERR_198
static int	DAM_IERR_199
static int	DAM_IERR_200
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_BLOCKJOIN_IS_ENABLED
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_DAM_HDBC
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