Adaptive Server System Function Compatibility

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

Status of Adaptive Server 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.