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