SQL Anywhere and SQL AnywhereSybase IQ do not support certain Adaptive Server Enterprise system functions.
These Adaptive Server Enterprise system functions are not supported by SQL Anywhere and Sybase IQ:
curunreservedpgs() – number of pages free on a dbspace.
data_pgs() – number of pages used by a table or index.
host_id() – UNIX pid of the server process.
hos_name() – name of the machine on which the server is running.
lct_admin() – manages the “last chance threshold” for the Transaction manager.
reserved_pgs() – number of pages allocated to a table or index.
rowcnt() – number of rows in the specified table.
valid_name() – whether a name would be a valid name if used, for example, for a table.
valid_user() – returns TRUE if that user has connect permissions.
ptn_data_pgs() – number of data pages in a partition.
index_colorder() – returns the column order in an index.