Datatype information for columns

The system table descriptions in Reference Manual Volume 4: Tables include erroneous information for the datatypes of some columns. The following describes the correct datatypes for these columns:

System table

Column

Datatype

syscolumns

colid length

smallint int

syscurconfigs

message_num apf_percent

varchar(20) varchar(10)

sysengines

osprocname status

char(32) char(12)

sysindexes

status2

smallint

sysjars

jstatus jname

smallint varchar(30)

syskeys

key1 – key8 depkey1 – depkey8

smallint smallint

syslocks

class

varchar(30)

syslogins

password

varbinary(30)

syslogshold

xactid masterxactid xloid

binary(6) binary(6) int

sysmessages

error descriptions

int varchar(1024)

sysprocedures

version

smallint

sysprocesses

origsuid

int

sysprotects

action

smallint

sysroles

status

int

syssrvroles

srid

int

systabstats

spare3

smallint

systhresholds

suid

int

sysusages

crdate

datetime