Adaptive Server Enterprise System Views

Certain views are not supported by SAP Sybase IQ.

SAP Sybase IQ no longer supports these Adaptive Server Enterprise views:

sysalternates
sysaudits
sysauditoptions
sysconstraints
syscharsets
sysconfigures
syscurconfigs
sysdatabases
sysdepends
sysdevices
sysengines
syskeys
syslanguages
syslocks
syslogs
sysloginroles
sysmessages
sysprocedures
sysprocesses
sysprotects
sysreferences
sysremotelogins
sysroles
syssegments
sysservers
syssrvroles
systhresholds
sysusages

Column Name Differences

The column name used in the Adaptive Server Enterprise view SYSTYPES is “allownulls”. The column name used in the SAP Sybase IQ view SYSTYPES is “allowsnulls”.