Changed system tables

Table 2-12 summarizes the system tables that have been changed in this release.

**Table 2-12: 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. See “Row-Level Access Locking“ for more information.
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. See “Row-Level Access Locking“ for more information.
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 set to 1,000 ms.
systypes	New accessrule column. The object ID of the access rule in sysprocedures. See “Row-Level Access Locking“ for more information.

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

Changes to sysobjects

Table 2-13 describes changes to the sysobjects table. See “sysobjects” in the system tables chapter of the Adaptive Server Enterprise Reference Manual for more information on the columns used in sysobjects.

**Table 2-13: 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.