Sybase Adaptive Server Anywhere - Page 330

Function types
312
System function Description
Col_length( table-name , column-name )
Returns the defined length of column
Col_name( table-id , column-id [,
database-id ] )
Returns the column name
Datalength( expression )
Returns the length of the expression,
in bytes
Db_id( [ database-name ] )
Returns the database ID number
Db_name( [ database-id ] )
Returns the database name
Index_col ( table-name , index-id , key _# [,
userid ] )
Returns the name of the indexed
column
Object_id ( object-name )
Returns the object ID
Object_name ( object-id [, database-id ] )
Returns the object name
Suser_id( [ user-name ] )
Returns an integer user identification
number
Suser_name( [ user-id ] )
Returns the user ID (server user name
in Adaptive Server Enterprise)
Tsequal ( timestamp , timestamp2 )
Compares timestamp values to
prevent update on a row that has been
modified since it was selected
User_id( [ user-name ] )
Returns an integer user identification
number. This does not return the
Adaptive Server Anywhere user ID
User_name( [ user-id ] )
Returns the user ID (user name in
Adaptive Server Enterprise)
Text and image functions
Text and image functions operate on text and image data types. Adaptive
Server Adaptive Server Anywhere supports only the
textptr text and image
function.
♦ Adaptive Server Anywhere does not currently support the Adaptive
Server Enterprise textvalid function.
The following text and image function is available:
♦ "TEXTPTR function" on page 371
Compatibility
List of functions