Changed databases and system tables

This section describes the changes made to databases and system tables to support version 12.5 features.

There are no new databases or system tables for this version of Adaptive Server.

Table 5-13 summarizes the system tables that have been changed in this release.

**Table 5-13: Changed system tables**
Table	Change
syscolumns	New status2 column. Indicates parameter mode of a SQLJ stored procedure, and the return type of a SQLJ function.
syscolumns	New accessrule column. The object ID of the access rule in sysprocedures.
sysconstraints	New spare1 column. Not for customer use.
syslogins	New procid column. Stores the login trigger registered with the login script option in sp_modifylogin.
sysprocesse	New loggedindatetime column. Shows the time and date when the client connected to Adaptive Server.
sysprocesse	New ipaddr column. IP address of the client where the login is made. See “Row-Level Access Locking“ for more information.
sysservers	New srvcost column. Provides the network cost in milliseconds for accessing a server over a network. Used only by the Adaptive Server query optimizer for evaluating the cost of a query when accessing a proxy table. The default is 1,000 ms.
systypes	New accessrule column. The object ID of the access rule in sysprocedures. See “Row-Level Access Lockin” for more information.

For more information about system tables, see the Reference Manual Volume 4: System Tables.

Table 5-14 summarizes the changes in existing system table columns in this version:

**Table 5-14: Changed status in existing columns**
Table name	Column name	Old datatype	New datatype
sysalternates	altsuid	smallint	int
sysalternates	suid	smallint	int
syscolumns	colid	tinyint	smallint
syscolumns	length	tinyint	int
syscomments	colid	tinyint	smallint
syscomments	colid2	tinyint	smallint
sysconfigures	status	tinyint	int
sysconstraints	colid	tinyint	int
syscurconfigs	status	smallint	int
sysdatabases	suid	smallint	int
sysloginroles	srid	smallint	int
sysloginroles	suid	smallint	int
syslogins	suid	smallint	int
sysobjects	uid	smallint	int
sysprocedures	sequence	smallint	int
sysprocesses	gid	smallint	int
	origsuid	smallint	int
	suid	smallint	int
	uid	smallint	int
sysprotects	uid	smallint	int
sysqueryplans	uid	smallint	int
sysreferences	fokey1 ... 16	tinyint	smallint
sysreferences	refkey1 ... 16	tinyint	smallint
sysremotelogins	suid	smallint	int
sysroles	id	smallint	int
syssrvroles	lrid	smallint	int
systhresholds	suid	smallint	int
systypes	uid	smallint	int
systypes	length	tinyint	int
sysusermessages	uid	smallint	int
sysusers	gid	smallint	int
	uid	smallint	int
	suid	smallint	int

Table 5-15 describes changes to the sysobjects table. See “sysobjects” in Reference Manual: Tables of the Reference Series for more information on the columns used in sysobjects.

**Table 5-15: Changes in the sysobjects table**
Column name	Datatype	Description
type	char(2)	F = SQLJ function
sysstat2	int	Addition of: New bit (0x2000000) that represents a SQLJ stored procedure. New bit (0x01000000) that represents an access rule. New bit (0x04000000) that represents an OR access rule.