Constant Field Values (JTDB Documentation)

FairCom.CtreeDb.Types.ALTER_TABLE
Modifier and Type	Constant Field	Value
`public static final int`	`FTI`	`4`
`public static final int`	`FULL`	`3`
`public static final int`	`HOT`	`8`
`public static final int`	`INDEX`	`1`
`public static final int`	`KEEPTRAN`	`32768`
`public static final int`	`NORMAL`	`0`
`public static final int`	`PURGEDUP`	`4096`
`public static final int`	`TRUNCATE`	`8192`
`public static final int`	`V8DELFLD`	`256`

FairCom.CtreeDb.Types.ATTACH_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`CTREEID`	`2`
`public static final int`	`CURRENT`	`3`
`public static final int`	`NONE`	`0`
`public static final int`	`SESSION`	`1`

FairCom.CtreeDb.Types.BATCH_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`DEL`	`4`
`public static final int`	`GET`	`1`
`public static final int`	`GKEY`	`512`
`public static final int`	`INS`	`5`
`public static final int`	`LKEY`	`1024`
`public static final int`	`LOCK_BLOCK`	`32768`
`public static final int`	`LOCK_COMPLETE`	`131072`
`public static final int`	`LOCK_KEEP`	`4096`
`public static final int`	`LOCK_ONE`	`65536`
`public static final int`	`LOCK_READ`	`8192`
`public static final int`	`LOCK_WRITE`	`16384`
`public static final int`	`MANDATORY`	`255`
`public static final int`	`NONE`	`0`
`public static final int`	`PHYS`	`3`
`public static final int`	`RANGE`	`2`
`public static final int`	`UPD`	`6`
`public static final int`	`VERIFY`	`2048`

FairCom.CtreeDb.Types.BEGIN_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`AUTOSAVE`	`8`
`public static final int`	`DEFER`	`4`
`public static final int`	`NONE`	`0`
`public static final int`	`PREIMG`	`1`
`public static final int`	`TRNLOG`	`3`
`public static final int`	`TWOPHASE`	`16`

FairCom.CtreeDb.Types.BINARY_FLAG
Modifier and Type	Constant Field	Value
`public static final int`	`BINARY_BLOB`	`6`
`public static final int`	`BINARY_CLOB`	`5`
`public static final int`	`BINARY_FIXED`	`1`
`public static final int`	`BINARY_MAX`	`7`
`public static final int`	`BINARY_UNKNOWN`	`0`
`public static final int`	`BINARY_VARCHAR`	`4`
`public static final int`	`BINARY_WITH_LENGTH`	`2`
`public static final int`	`BINARY_WITHOUT_LENGTH`	`3`

FairCom.CtreeDb.Types.CLIENT_OPTIONS
Modifier and Type	Constant Field	Value
`public static final int`	`BROADCAST_DEBUG`	`2`
`public static final int`	`BROADCAST_PORT`	`3`
`public static final int`	`BROADCAST_READ`	`1`

FairCom.CtreeDb.Types.COMM_PROTOCOL_OPTIONS
Modifier and Type	Constant Field	Value
`public static final int`	`FCTHREADS`	`6`
`public static final int`	`FSSLTCP_DEBUG_LOG`	`2`
`public static final int`	`FSSLTCP_SERVER_CERTIFICATE`	`1`
`public static final int`	`SOCKET_TIMEOUT`	`4`
`public static final int`	`SOCKET_WAIT_INTERVAL`	`5`
`public static final int`	`WRITES_ALLOWED`	`3`

FairCom.CtreeDb.Types.CREATE_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`AUTOMKDIR`	`524288`
`public static final int`	`BLOCKCOMPRESSDAT`	`131072`
`public static final int`	`BLOCKCOMPRESSIDX`	`262144`
`public static final int`	`CHECKLOCK`	`8`
`public static final int`	`CHECKREAD`	`128`
`public static final int`	`COMPRESS`	`8192`
`public static final int`	`DYNPARTHOST`	`32768`
`public static final int`	`FLEXREC`	`65536`
`public static final int`	`HUGEFILE`	`256`
`public static final int`	`NOCLSADD`	`1048576`
`public static final int`	`NODELFLD`	`512`
`public static final int`	`NOFLUSH`	`16384`
`public static final int`	`NONULFLD`	`1024`
`public static final int`	`NORECBYT`	`32`
`public static final int`	`NORMAL`	`0`
`public static final int`	`NOROWID`	`64`
`public static final int`	`PARTAUTO`	`2048`
`public static final int`	`PREIMG`	`1`
`public static final int`	`TRNLOG`	`2`
`public static final int`	`V8DELFLD`	`4096`
`public static final int`	`VRLEN`	`16`
`public static final int`	`WRITETHRU`	`4`

FairCom.CtreeDb.Types.CTPART_MODE_E
Modifier and Type	Constant Field	Value
`public static final int`	`ACTIVATE`	`1024`
`public static final int`	`ADD`	`32`
`public static final int`	`ARCHIVE`	`64`
`public static final int`	`BASE`	`128`
`public static final int`	`MULTI`	`4096`
`public static final int`	`NUMBER`	`256`
`public static final int`	`PURGE`	`16`
`public static final int`	`REUSE`	`512`
`public static final int`	`STATUS`	`2048`

FairCom.CtreeDb.Types.DATE_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`CYMD_DATE`	`5`
`public static final int`	`DMCY_DATE`	`3`
`public static final int`	`DMY_DATE`	`4`
`public static final int`	`MDCY_DATE`	`1`
`public static final int`	`MDY_DATE`	`2`
`public static final int`	`YMD_DATE`	`6`

FairCom.CtreeDb.Types.FIELD_STATUS
Modifier and Type	Constant Field	Value
`public static final int`	`DEL`	`2`
`public static final int`	`LEN`	`64`
`public static final int`	`MOVED`	`4`
`public static final int`	`NAME`	`16`
`public static final int`	`NEW`	`1`
`public static final int`	`OLD`	`0`
`public static final int`	`RES`	`128`
`public static final int`	`TYPE`	`32`

FairCom.CtreeDb.Types.FIELD_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`ARRAY`	`128`
`public static final int`	`BIGINT`	`231`
`public static final int`	`BINARY`	`128`
`public static final int`	`BIT`	`8`
`public static final int`	`BOOL`	`8`
`public static final int`	`CHAR`	`16`
`public static final int`	`CHARS`	`144`
`public static final int`	`CHARU`	`24`
`public static final int`	`CURRENCY`	`143`
`public static final int`	`DATE`	`75`
`public static final int`	`DECIMAL`	`105`
`public static final int`	`DFLOAT`	`103`
`public static final int`	`DOUBL`	`103`
`public static final int`	`EFLOAT`	`119`
`public static final int`	`F2STRING`	`160`
`public static final int`	`F2UNICODE`	`193`
`public static final int`	`F4STRING`	`168`
`public static final int`	`FLOAT`	`91`
`public static final int`	`FPSTRING`	`152`
`public static final int`	`FSTRING`	`144`
`public static final int`	`FUNICODE`	`177`
`public static final int`	`INT2`	`33`
`public static final int`	`INT2U`	`41`
`public static final int`	`INT4`	`51`
`public static final int`	`INT4U`	`59`
`public static final int`	`INT8`	`231`
`public static final int`	`INT8U`	`239`
`public static final int`	`INTEGER`	`51`
`public static final int`	`JSON`	`259`
`public static final int`	`LVB`	`170`
`public static final int`	`LVC`	`146`
`public static final int`	`MONEY`	`67`
`public static final int`	`NUMBER`	`105`
`public static final int`	`NUMERIC`	`105`
`public static final int`	`SFLOAT`	`91`
`public static final int`	`SMALLINT`	`33`
`public static final int`	`TIME`	`83`
`public static final int`	`TIME_MS`	`258`
`public static final int`	`TIMES`	`124`
`public static final int`	`TIMES_MS`	`257`
`public static final int`	`TIMESTAMP`	`124`
`public static final int`	`TINYINT`	`16`
`public static final int`	`V2STRING`	`162`
`public static final int`	`V2UNICODE`	`201`
`public static final int`	`V4STRING`	`170`
`public static final int`	`VARBINARY`	`162`
`public static final int`	`VARCHAR`	`146`
`public static final int`	`VPSTRING`	`154`
`public static final int`	`VSTRING`	`146`
`public static final int`	`VUNICODE`	`185`

FairCom.CtreeDb.Types.FIND_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`EQUAL`	`0`
`public static final int`	`GREATER`	`3`
`public static final int`	`GREATERorEQUAL`	`4`
`public static final int`	`LESS`	`1`
`public static final int`	`LESSorEQUAL`	`2`

FairCom.CtreeDb.Types.FTI_FIELD_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`REGULAR`	`1`
`public static final int`	`UTF16`	`4`
`public static final int`	`UTF8`	`2`

FairCom.CtreeDb.Types.FTI_OPTION
Modifier and Type	Constant Field	Value
`public static final int`	`CUSTOMLIB`	`6`
`public static final int`	`CUSTOMPARAM`	`7`
`public static final int`	`ICULANG`	`4`
`public static final int`	`ICUOPTION`	`5`
`public static final int`	`STOP_LIST`	`10`
`public static final int`	`SUPERFILE`	`9`
`public static final int`	`TOKENIZER`	`3`
`public static final int`	`TOKENSIZE`	`2`
`public static final int`	`UPDATE`	`1`

FairCom.CtreeDb.Types.FTI_OPTION_TOKENIZER
Modifier and Type	Constant Field	Value
`public static final int`	`CUSTOM`	`0`
`public static final int`	`ICU`	`3`
`public static final int`	`PORTER`	`2`
`public static final int`	`SIMPLE`	`1`

FairCom.CtreeDb.Types.FTI_OPTION_UPDATE
Modifier and Type	Constant Field	Value
`public static final int`	`ASYNC`	`0`
`public static final int`	`ATCOMMIT`	`2`
`public static final int`	`IGNORE_EXISTING`	`256`
`public static final int`	`IMMEDIATE`	`1`
`public static final int`	`MASK`	`255`

FairCom.CtreeDb.Types.FTI_STATUS
Modifier and Type	Constant Field	Value
`public static final int`	`DELELED`	`2`
`public static final int`	`NEW`	`1`
`public static final int`	`OLD`	`0`
`public static final int`	`OPTIONSUPDATED`	`4`

FairCom.CtreeDb.Types.IDXNO
Modifier and Type	Constant Field	Value
`public static final int`	`DATA`	`10002`
`public static final int`	`RECBYT`	`10000`
`public static final int`	`ROWID`	`10001`

FairCom.CtreeDb.Types.INDEX_STATUS
Modifier and Type	Constant Field	Value
`public static final int`	`AIDXNAM`	`256`
`public static final int`	`DEL`	`2`
`public static final int`	`DUPFLAG`	`64`
`public static final int`	`EMPCHAR`	`32`
`public static final int`	`KEYTYPE`	`16`
`public static final int`	`NEW`	`1`
`public static final int`	`NULLFLAG`	`128`
`public static final int`	`OLD`	`0`
`public static final int`	`RIDXNAM`	`512`

FairCom.CtreeDb.Types.KEEPLOCK_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`FREE`	`0`
`public static final int`	`LOCK`	`1`
`public static final int`	`OUT`	`2`
`public static final int`	`OUTALL`	`3`

FairCom.CtreeDb.Types.KEY_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`ERROR_INDEX`	`65535`
`public static final int`	`FIXED_INDEX`	`0`
`public static final int`	`LEADING_INDEX`	`4`
`public static final int`	`LEADPAD_INDEX`	`12`
`public static final int`	`PADDING_INDEX`	`8`

FairCom.CtreeDb.Types.LIB_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`CLIENT`	`4`
`public static final int`	`HUGE`	`128`
`public static final int`	`LOCLIB`	`8`
`public static final int`	`MUSER`	`2`
`public static final int`	`SERVER`	`16`
`public static final int`	`SINGLE`	`1`
`public static final int`	`THREA`	`32`
`public static final int`	`TRAN`	`64`

FairCom.CtreeDb.Types.LOCATE_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`CASEIN`	`1`
`public static final int`	`CASEIN_PARTIAL`	`3`
`public static final int`	`NONE`	`0`
`public static final int`	`PARTIAL`	`2`

FairCom.CtreeDb.Types.LOCK_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`FREE`	`0`
`public static final int`	`READ`	`1`
`public static final int`	`READ_BLOCK`	`2`
`public static final int`	`RESET`	`5`
`public static final int`	`RESTORE_READ`	`7`
`public static final int`	`RESTORE_READ_BLOCK`	`8`
`public static final int`	`RESTORE_WRITE`	`9`
`public static final int`	`RESTORE_WRITE_BLOCK`	`10`
`public static final int`	`SUSPEND`	`6`
`public static final int`	`WRITE`	`3`
`public static final int`	`WRITE_BLOCK`	`4`

FairCom.CtreeDb.Types.OPEN_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`CHECKLOCK`	`8`
`public static final int`	`CHECKREAD`	`16`
`public static final int`	`CORRUPT`	`4`
`public static final int`	`DATAONLY`	`64`
`public static final int`	`EXCLUSIVE`	`1`
`public static final int`	`NORMAL`	`0`
`public static final int`	`PERMANENT`	`2`
`public static final int`	`RAW`	`288`
`public static final int`	`READONLY`	`32`
`public static final int`	`UNLOCKONCLOSE`	`128`

FairCom.CtreeDb.Types.OPERATOR_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`BET`	`199`
`public static final int`	`BET_EE`	`10`
`public static final int`	`BET_EI`	`137`
`public static final int`	`BET_IE`	`72`
`public static final int`	`EQ`	`193`
`public static final int`	`GE`	`195`
`public static final int`	`GT`	`130`
`public static final int`	`LE`	`196`
`public static final int`	`LT`	`69`
`public static final int`	`NE`	`38`
`public static final int`	`NOTBET`	`43`

FairCom.CtreeDb.Types.OPS_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`AUTOISAM_TRN`	`262144`
`public static final int`	`COMMIT_SWP`	`2097152`
`public static final int`	`CONV_STRING`	`1073741824`
`public static final int`	`DEFER_CLOSE`	`33554432`
`public static final int`	`DISK_IO`	`67108864`
`public static final int`	`FUNCTION_MON`	`32768`
`public static final int`	`KEEPLOK_TRN`	`268435456`
`public static final int`	`LOCK_MON`	`65536`
`public static final int`	`LOCKON_BLK`	`32`
`public static final int`	`LOCKON_GET`	`4`
`public static final int`	`MEMORY_SWP`	`1048576`
`public static final int`	`MIRROR_NOSWITCH`	`4096`
`public static final int`	`MIRROR_TRM`	`16384`
`public static final int`	`READLOCK`	`536870912`
`public static final int`	`SERIAL_UPD`	`524288`
`public static final int`	`TRACK_MON`	`131072`
`public static final int`	`UNLOCK_ADD`	`1`
`public static final int`	`UNLOCK_RWT`	`2`
`public static final int`	`UNLOCK_UPD`	`3`

FairCom.CtreeDb.Types.OPS_STATE
Modifier and Type	Constant Field	Value
`public static final int`	`OFF`	`0`
`public static final int`	`ON`	`2`
`public static final int`	`RETURN`	`3`
`public static final int`	`SET`	`1`

FairCom.CtreeDb.Types.REBUILD_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`COMPACT`	`8`
`public static final int`	`DATAONLY`	`4`
`public static final int`	`NONE`	`0`
`public static final int`	`PURGEDUP`	`1`
`public static final int`	`UPDATEIFIL`	`2`

FairCom.CtreeDb.Types.SEG_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`ALTSEG`	`32`
`public static final int`	`BCDSEG`	`11`
`public static final int`	`DECSEG`	`10`
`public static final int`	`DESCENDING`	`16`
`public static final int`	`ENDSEG`	`64`
`public static final int`	`FLTSEG`	`9`
`public static final int`	`GNXSEG`	`1024`
`public static final int`	`INTSEG`	`1`
`public static final int`	`INVALID`	`65535`
`public static final int`	`RECBYT`	`256`
`public static final int`	`REGSEG`	`0`
`public static final int`	`SCHSEG`	`12`
`public static final int`	`SCHSRL`	`257`
`public static final int`	`SGNSEG`	`8`
`public static final int`	`SRLSEG`	`3`
`public static final int`	`UNCSEG`	`128`
`public static final int`	`UREGSEG`	`2`
`public static final int`	`USCHSEG`	`13`
`public static final int`	`UVARSEG`	`5`
`public static final int`	`UVSCHSEG`	`15`
`public static final int`	`VARSEG`	`4`
`public static final int`	`VSCHSEG`	`14`

FairCom.CtreeDb.Types.SEGMENT_STATUS
Modifier and Type	Constant Field	Value
`public static final int`	`DEL`	`2`
`public static final int`	`FIELD`	`32`
`public static final int`	`MODE`	`16`
`public static final int`	`MOVED`	`4`
`public static final int`	`NEW`	`1`
`public static final int`	`OLD`	`0`

FairCom.CtreeDb.Types.SESSION_PARAM
Modifier and Type	Constant Field	Value
`public static final int`	`CT_BUFS`	`1`
`public static final int`	`CT_DBUFS`	`4`
`public static final int`	`CT_FILS`	`2`
`public static final int`	`CT_SECT`	`3`
`public static final int`	`CT_USERPROF`	`5`
`public static final int`	`USERPRF_CLRCHK`	`512`
`public static final int`	`USERPRF_LOCLIB`	`64`
`public static final int`	`USERPRF_NDATA`	`32`
`public static final int`	`USERPRF_NTKEY`	`1`
`public static final int`	`USERPRF_PTHTMP`	`128`
`public static final int`	`USERPRF_SAVENV`	`2`

FairCom.CtreeDb.Types.SESSION_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`CTDB`	`0`
`public static final int`	`CTREE`	`1`
`public static final int`	`SQL`	`2`

FairCom.CtreeDb.Types.SQL_CALLBACK_MODE
Modifier and Type	Constant Field	Value
`public static final int`	`CONFIRM_CHANGEPAD`	`7`
`public static final int`	`CONFIRM_NONCONVIDS`	`23`
`public static final int`	`CONFIRM_NOPUTIFIL`	`5`
`public static final int`	`CONFIRM_NOPUTPAD`	`11`
`public static final int`	`CONFIRM_NULLTERM`	`9`
`public static final int`	`CONFIRM_PRIIDX`	`25`
`public static final int`	`CONFIRM_PUTIFIL`	`4`
`public static final int`	`CONFIRM_PUTPAD`	`10`
`public static final int`	`CONFIRM_REPLACELNK`	`6`
`public static final int`	`CONFIRM_SKIPIDX`	`3`
`public static final int`	`CONFIRM_SKPHFLDIDX`	`13`
`public static final int`	`CONFIRM_SKPHIDFLD`	`12`
`public static final int`	`CONFIRM_SPACEPAD`	`8`
`public static final int`	`ELAB_IDX`	`15`
`public static final int`	`ERROR`	`1`
`public static final int`	`FORCE_PADDING`	`20`
`public static final int`	`GRANT_PUBLIC`	`24`
`public static final int`	`PROMOTE_UINT`	`16`
`public static final int`	`RETURN_IDXMETHOD`	`22`
`public static final int`	`RETURN_MAXFLDLEN`	`21`
`public static final int`	`RETURN_PRIIDXNAME`	`17`
`public static final int`	`RETURN_SYMTBLNAME`	`14`
`public static final int`	`RETURN_TBLPREFIX`	`26`
`public static final int`	`RETURN_TBLUID`	`18`
`public static final int`	`STRING_PARTSEG`	`19`
`public static final int`	`WARNING`	`2`

FairCom.CtreeDb.Types.TABLE_STATUS
Modifier and Type	Constant Field	Value
`public static final int`	`REBUILD_ALL`	`8`
`public static final int`	`REBUILD_DODA`	`1`
`public static final int`	`REBUILD_FULL`	`16`
`public static final int`	`REBUILD_INDEX`	`4`
`public static final int`	`REBUILD_NONE`	`0`
`public static final int`	`REBUILD_RESOURCE`	`2`

FairCom.CtreeDb.Types.TIME_TYPE
Modifier and Type	Constant Field	Value
`public static final int`	`HM_TIME`	`4`
`public static final int`	`HMP_TIME`	`2`
`public static final int`	`HMS_TIME`	`3`
`public static final int`	`HMSP_TIME`	`1`
`public static final int`	`MIL_TIME`	`5`

Constant Field Values

Contents

FairCom.CtreeDb.*