Adaptive Server Enterprise System Function Compatibility

Not all Adaptive Server Enterprise system functions are implemented in SAP Sybase IQ.

Status of Adaptive Server Enterprise system functions in SAP Sybase IQ

Function

Status

col_length

Implemented

col_name

Implemented

db_id

Implemented

db_name

Implemented

index_col

Implemented

object_id

Implemented

object_name

Implemented

proc_role

Always returns 0

show_role

Always returns NULL

tsequal

Not implemented

user_id

Implemented

user_name

Implemented

suser_id

Implemented

suser_name

Implemented

datalength

Implemented

curunreservedpgs

Not implemented

data_pgs

Not implemented

host_id

Not implemented

host_name

Not implemented

lct_admin

Not implemented

reserved_pgs

Not implemented

rowcnt

Not implemented

used_pgs

Not implemented

valid_name

Not implemented

valid_user

Not implemented

Notes

  • Some of the system functions are implemented in SAP Sybase IQ as system stored procedures.

  • The db_id, db_name, datalength, suser_id, and suser_name functions are implemented as built-in functions.