Changes to system tables and view columns

In the SYS.ISYSTAB and SYS.ISYSIDX system tables, a new column called dbspace_id replaces the file_id column, which is deprecated in Sybase IQ 15.0. The file_id column remains in these tables and their associated compatibility views.

The following table lists other differences in system table and view columns between Sybase IQ versions 12.7 and 15.0.

System table and view column differences
	Sybase IQ 12.7		Sybase IQ 15.0
System table name	Column name	Data type	Column name	Data type	Possible application impact
SYSCATALOG	check	text	check	smallint	N

SYSCOLUMN	width	smallint	width	unsigned int	Y
	unused				N
	unused2				N
	format_str				N
	remote_name				N
	remote_type				N

SYSCONSTRAINT	table_id*				Y
	column_id*				Y
	index_id*				Y
	fkey_id*				Y

SYSINDEXES	indid	numeric	indid	bigint	N
	fname	text	fname	char	Y

SYSINFO	page_size	int	page_size	varchar	Y
	default_collation	char	default_collation	varchar	Y
	classes_version				Y

SYSIQCOLUMN	info_location	hs_vdorecid	info_location	smallint	N
	info_recid_size				N
	info_location_size	unsigned int	info_location_size	smallint	N

SYSIQFILE	file_name	char	file_name	text	Y

SYSIQINDEX	info_location	hs_vdorecid	info_location	smallint	N
	info_recid_size	unsigned int	info_recid_size	smallint	N
	info_location_size	unsigned int	info_location_size	smallint	N

SYSIQINFO	last_full_backup				N
	last_incr_backup				N

SYSJAR	create_time**				N
	remarks				N

SYSJARCOMPONENT	create_time**				N
	remarks				N

SYSJAVACLASS	replaced_by				N
	type_id				N
	class_descriptor				N
	create_time**				N
	remarks				N

SYSPROCPARMS	length	smallint	length	unsigned int	Y
	remarks				Y

SYSREMOTEUSER	log_send	numeric	log_send	unsigned bigint	N
	log_sent	numeric	log_sent	unsigned bigint	N
	confirm_sent	numeric	confirm_sent	unsigned bigint	N
	log_received	numeric	log_received	unsigned bigint	N
	confirm_received	numeric	confirm_received	unsigned bigint	N

SYSREMOTEUSERS	log_send	numeric	log_send	unsigned bigint	N
	log_sent	numeric	log_sent	unsigned bigint	N
	confirm_sent	numeric	confirm_sent	unsigned bigint	N
	log_received	numeric	log_received	unsigned bigint	N
	confirm_received	numeric	confirm_received	unsigned bigint	N

SYSSCHEDULE	event_id	int	event_id	unsigned int	Y

SYSTABLEPERM	ttable_id				Y

SYSUSERTYPE		smallint		unsigned int	Y
	format_str				N
	super_type_id				N
Notes: * Replaced by ref_object_id: the object ID of the column, table, or index to which the constraint applies ** The create time is available in SYSOBJECT.create_time