Constant Field Values

Contents

• com.informix.*

com.informix.*

com.informix.jdbc.IfxBblob

Modifier and Type	Constant Field	Value
protected static final short	MODE_CLIENT_ONLY	2
protected static final short	MODE_READ_WRITE	0
protected static final short	MODE_RW_BUFF	1
protected static final short	TYPE_IS_BLOB	2
protected static final short	TYPE_IS_CLOB	3

com.informix.jdbc.IfxCblob

Modifier and Type	Constant Field	Value
protected static final short	MODE_CLIENT_ONLY	2
protected static final short	MODE_READ_WRITE	0
protected static final short	MODE_RW_BUFF	1
protected static final short	TYPE_IS_BLOB	2
protected static final short	TYPE_IS_CLOB	3

com.informix.jdbc.IfxLobDescriptor

Modifier and Type	Constant Field	Value
public static final short	LO_DELAY_LOG	4
public static final short	LO_HIGH_INTEG	32
public static final short	LO_KEEP_LASTACCESS_TIME	8
public static final short	LO_LOG	1
public static final short	LO_MODERATE_INTEG	64
public static final short	LO_NOKEEP_LASTACCESS_TIME	16
public static final short	LO_NOLOG	2
public static final short	LO_TEMP	128

com.informix.jdbc.IfxLocator

Modifier and Type	Constant Field	Value
public static final int	IFX_LOCATOR_SIZE	72

com.informix.jdbc.IfxSmartBlob

Modifier and Type	Constant Field	Value
public static final int	LO_APPEND	1
public static final int	LO_BUFFER	512
public static final int	LO_CLIENT_FILE	536870912
public static final int	LO_CURRENT_END	-2
public static final int	LO_DIRTY_READ	16
public static final int	LO_EXCLUSIVE_MODE	2
public static final int	LO_FORWARD	128
public static final int	LO_LOCKALL	4096
public static final int	LO_LOCKRANGE	8192
public static final int	LO_MAX_END	-1
public static final int	LO_NOBUFFER	1024
public static final int	LO_NODIRTY_READ	2048
public static final int	LO_RANDOM	32
public static final int	LO_RDONLY	4
public static final int	LO_RDWR	8
public static final int	LO_REVERSE	256
public static final int	LO_SEEK_CUR	1
public static final int	LO_SEEK_END	2
public static final int	LO_SEEK_SET	0
public static final int	LO_SEQUENTIAL	64
public static final int	LO_SERVER_FILE	268435456
public static final int	LO_SHARED_MODE	1
public static final int	LO_WRONLY	2

com.informix.jdbc.IfxStatementTypes

Modifier and Type	Constant Field	Value
public static final short	SQ_ALTER	29
public static final short	SQ_ALTERAM	100
public static final short	SQ_ALTERROUTINE	97
public static final short	SQ_ALTFRAG	75
public static final short	SQ_ALTIDX	47
public static final short	SQ_ALTOPCL	59
public static final short	SQ_BEGWORK	34
public static final short	SQ_CHKIDX	108
public static final short	SQ_CHKTAB	27
public static final short	SQ_CLSDB	31
public static final short	SQ_COMMIT	35
public static final short	SQ_CONSTRMODE	55
public static final short	SQ_CREABT	95
public static final short	SQ_CREACST	103
public static final short	SQ_CREACT	93
public static final short	SQ_CREADB	12
public static final short	SQ_CREADOM	88
public static final short	SQ_CREADT	92
public static final short	SQ_CREAGG	105
public static final short	SQ_CREANRT	90
public static final short	SQ_CREASYN	43
public static final short	SQ_CREATEAM	98
public static final short	SQ_CREATEOPC	101
public static final short	SQ_CREATEROLE	83
public static final short	SQ_CREAUD	22
public static final short	SQ_CREIDX	16
public static final short	SQ_CREOPCL	58
public static final short	SQ_CREPROC	53
public static final short	SQ_CRETAB	14
public static final short	SQ_CRETRIG	70
public static final short	SQ_CREVIEW	40
public static final short	SQ_CTEMP	45
public static final short	SQ_DATABASE	1
public static final short	SQ_DBGFILE	57
public static final short	SQ_DEBUG	42
public static final short	SQ_DELALL	32
public static final short	SQ_DELCURR	8
public static final short	SQ_DELETE	5
public static final short	SQ_DROPAM	99
public static final short	SQ_DROPCT	94
public static final short	SQ_DROPDB	13
public static final short	SQ_DROPDOM	89
public static final short	SQ_DROPNRT	91
public static final short	SQ_DROPOPC	102
public static final short	SQ_DROPROLE	84
public static final short	SQ_DROPSYN	44
public static final short	SQ_DROPTYPE	96
public static final short	SQ_DROPVIEW	41
public static final short	SQ_DRPAGG	106
public static final short	SQ_DRPAUD	25
public static final short	SQ_DRPIDX	17
public static final short	SQ_DRPOPCL	60
public static final short	SQ_DRPPROC	54
public static final short	SQ_DRPTAB	15
public static final short	SQ_DRPTRIG	71
public static final short	SQ_EXECPROC	56
public static final short	SQ_EXPLAIN	50
public static final short	SQ_GRANT	18
public static final short	SQ_INSERT	6
public static final short	SQ_ISOLATE	48
public static final short	SQ_LDINSERT	9
public static final short	SQ_LOCK	10
public static final short	SQ_OPRELEASE	62
public static final short	SQ_OPRESERVE	61
public static final short	SQ_OPTIM	52
public static final short	SQ_OPTIMEOUT	63
public static final short	SQ_PASSWD	86
public static final short	SQ_PDQPRIORITY	74
public static final short	SQ_PLOADFILE	107
public static final short	SQ_PROCSTATS	64
public static final short	SQ_RECTAB	26
public static final short	SQ_RENCOL	21
public static final short	SQ_RENDB	87
public static final short	SQ_RENTAB	20
public static final short	SQ_REPTAB	28
public static final short	SQ_REVOKE	19
public static final short	SQ_RFORWARD	39
public static final short	SQ_ROLLBACK	36
public static final short	SQ_SAVEPOINT	37
public static final short	SQ_SCHEDULE	109
public static final short	SQ_SCHEMA	51
public static final short	SQ_SELECT	2
public static final short	SQ_SELINTO	3
public static final short	SQ_SETDAC	80
public static final short	SQ_SETDATASKIP	73
public static final short	SQ_SETENV	110
public static final short	SQ_SETLOG	49
public static final short	SQ_SETLVEXT	82
public static final short	SQ_SETMAC	79
public static final short	SQ_SETOBJMODE	76
public static final short	SQ_SETRES	104
public static final short	SQ_SETROLE	85
public static final short	SQ_SETTBLHI	81
public static final short	SQ_SKINHIBIT	67
public static final short	SQ_SKSHOW	68
public static final short	SQ_SKSMALL	69
public static final short	SQ_START	77
public static final short	SQ_STARTDB	38
public static final short	SQ_STATS	30
public static final short	SQ_STMT_CACHE	115
public static final short	SQ_STOP	78
public static final short	SQ_STPAUD	24
public static final short	SQ_STRAUD	23
public static final short	SQ_UNKNOWN	72
public static final short	SQ_UNLOCK	11
public static final short	SQ_UPDALL	33
public static final short	SQ_UPDATE	4
public static final short	SQ_UPDCURR	7
public static final short	SQ_WAITFOR	46
public static final short	SQ_XPS_RES2	111
public static final short	SQ_XPS_RES3	112
public static final short	SQ_XPS_RES4	113
public static final short	SQ_XPS_RES5	114
public static final short	SQRENIDX	116

com.informix.lang.IfxTypes

Modifier and Type	Constant Field	Value
public static final short	IFX_BIT_COLLCLIENT	-32768
public static final short	IFX_BIT_DBOOLEAN	16384
public static final short	IFX_BIT_DISTINCT	2048
public static final short	IFX_BIT_NAMEDROW	4096
public static final short	IFX_BIT_NOTNULLABLE	256
public static final short	IFX_TYPE_BIGINT	52
public static final short	IFX_TYPE_BIGSERIAL	53
public static final short	IFX_TYPE_BLOB	102
public static final short	IFX_TYPE_BOOL	45
public static final short	IFX_TYPE_BYTE	11
public static final short	IFX_TYPE_CHAR	0
public static final short	IFX_TYPE_CLOB	101
public static final short	IFX_TYPE_COLLECTION	23
public static final short	IFX_TYPE_DATE	7
public static final short	IFX_TYPE_DATETIME	10
public static final short	IFX_TYPE_DECIMAL	5
public static final short	IFX_TYPE_FLOAT	3
public static final short	IFX_TYPE_IMPEXP	46
public static final short	IFX_TYPE_IMPEXPBIN	47
public static final short	IFX_TYPE_INT	2
public static final short	IFX_TYPE_INT8	17
public static final short	IFX_TYPE_INTERVAL	14
public static final short	IFX_TYPE_LIST	21
public static final short	IFX_TYPE_LVARCHAR	43
public static final short	IFX_TYPE_MAX	54
public static final short	IFX_TYPE_MONEY	8
public static final short	IFX_TYPE_MULTISET	20
public static final short	IFX_TYPE_NCHAR	15
public static final short	IFX_TYPE_NULL	9
public static final short	IFX_TYPE_NVCHAR	16
public static final short	IFX_TYPE_REFSER8	42
public static final short	IFX_TYPE_ROW	22
public static final short	IFX_TYPE_ROWREF	24
public static final short	IFX_TYPE_SENDRECV	44
public static final short	IFX_TYPE_SERIAL	6
public static final short	IFX_TYPE_SERIAL8	18
public static final short	IFX_TYPE_SET	19
public static final short	IFX_TYPE_SMALLINT	1
public static final short	IFX_TYPE_SMFLOAT	4
public static final short	IFX_TYPE_SQLUDRDEFAULT	48
public static final short	IFX_TYPE_TEXT	12
public static final short	IFX_TYPE_UDTFIXED	41
public static final short	IFX_TYPE_UDTVAR	40
public static final short	IFX_TYPE_UNKNOWN	49
public static final short	IFX_TYPE_VARCHAR	13
public static final short	IFX_XID_BLOB	10
public static final short	IFX_XID_BOOLEAN	5
public static final short	IFX_XID_BSON	26
public static final short	IFX_XID_CLIENTBINVAL	16
public static final short	IFX_XID_CLOB	11
public static final short	IFX_XID_IDSCOVERINGINFO	20
public static final short	IFX_XID_IDSELEMENTENC	19
public static final short	IFX_XID_IDSSECURITYLABEL	18
public static final short	IFX_XID_IFX_LO_SPEC	13
public static final short	IFX_XID_IFX_LO_STAT	14
public static final short	IFX_XID_IMPEXP	3
public static final short	IFX_XID_IMPEXPBIN	4
public static final short	IFX_XID_INDEXKEYARRAY	7
public static final short	IFX_XID_JSON	25
public static final short	IFX_XID_LLVC	24
public static final short	IFX_XID_LOLIST	12
public static final short	IFX_XID_LVARCHAR	1
public static final short	IFX_XID_POINTER	6
public static final short	IFX_XID_RTNPARAMTYPES	8
public static final short	IFX_XID_SELFUNCARGS	9
public static final short	IFX_XID_SENDRECV	2
public static final short	IFX_XID_STAT	15
public static final short	IFX_XID_STREAM	17
public static final java.lang.String	IFX_XNAME_BLOB	"blob"
public static final java.lang.String	IFX_XNAME_BOOL	"boolean"
public static final java.lang.String	IFX_XNAME_BSON	"bson"
public static final java.lang.String	IFX_XNAME_CLOB	"clob"
public static final java.lang.String	IFX_XNAME_JSON	"json"
public static final java.lang.String	IFX_XNAME_LVARCHAR	"lvarchar"
public static final java.lang.String	IFX_XNAME_UDT	"udt"
public static final short	LAST_BUILTIN_XID_TYPE	26

com.informix.lang.Interval

Modifier and Type	Constant Field	Value
protected static final int	DAY_IDX	2
protected static final int	DECSIZE	16
protected static final int	FRAC_IDX	6
protected static final int	HOUR_IDX	3
protected static final int	MIN_IDX	4
protected static final int	MONTH_IDX	1
protected static final int	NUMBER_UNITS	7
protected static final int	SEC_IDX	5
public static final byte	TU_DAY	4
public static final byte	TU_F1	11
public static final byte	TU_F2	12
public static final byte	TU_F3	13
public static final byte	TU_F4	14
public static final byte	TU_F5	15
public static final byte	TU_FRAC	12
public static final byte	TU_HOUR	6
public static final byte	TU_MINUTE	8
public static final byte	TU_MONTH	2
public static final byte	TU_SECOND	10
public static final byte	TU_YEAR	0
protected static final int	YEAR_IDX	0

com.informix.lang.IntervalDF

Modifier and Type	Constant Field	Value
protected static final int	MilliPerSecond	1000
protected static final int	NanosPerSecond	1000000000
protected static final int	SecondsPerDay	86400
protected static final int	SecondsPerHour	3600
protected static final int	SecondsPerMinute	60

com.informix.lang.IntervalYM

Modifier and Type	Constant Field	Value
protected static final int	MonthsPerYear	12