# Constant Field Values

## Contents

- com.informix.*

## com.informix.*

com.informix.jdbc.IfxBblob
`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
`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
`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
`public static final int` `IFX_LOCATOR_SIZE` `72`

com.informix.jdbc.IfxSmartBlob
`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
`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
`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
`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
`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
`protected static final int` `MonthsPerYear` `12`