System functions

System functions return special information from the database.

Table 3-8: Server class support for system functions

Function

ASE

ASA

ASIQ

dir_con

col_length

Y

Y

N

C

col_name

Y

Y

N

C

curunreservedpgs

N

N

N

N

data_pgs

N

N

N

N

datalength

Y

Y

N

C

db_id

N

N

N

N

db_name

N

N

N

N

getdate

Y

N

N

N

getutcdate

Y

N

N

N

host_id

N

N

N

N

host_name

N

N

N

N

index_col

N

N

N

N

isnull

Y

Y

N

N

lct_admin

N

N

N

N

mut_excl_roles

N

N

N

N

object_id

N

N

N

N

object_name

N

N

N

N

proc_role

N

N

N

N

ptn_data_pgs

N

N

N

N

reserved_pgs

N

N

N

N

role_contain

N

N

N

N

role_id

N

N

N

N

role_name

N

N

N

N

rowcnt

N

N

N

N

show_role

N

N

N

N

suser_id

N

Y

Y

N

suser_name

N

Y

Y

N

tsequal

Y

Y

N

N

used_pgs

N

N

N

N

user

Y

Y

Y

N

user_id

Y

Y

Y

N

user_name

Y

Y

Y

N

valid_name

N

N

N

N

valid_user

N

N

N

N