Function types
310
♦ "SPACE function" on page 366
♦ "STR function" on page 367
♦ "STRING function" on page 368
♦ "STUFF function" on page 368
♦ "SUBSTRING function" on page 369
♦ "TRIM function" on page 372
♦ "UCASE function" on page 373
♦ "UPPER function" on page 374
System functions
System functions return system information.
The following system functions are available:
♦ "CONNECTION_PROPERTY function " on page 321
♦ "DATALENGTH function" on page 325
♦ "DB_ID function" on page 331
♦ "DB_NAME function " on page 332
♦ "DB_PROPERTY function" on page 332
♦ "EVENT_CONDITION function" on page 335
♦ "EVENT_PARAMETER function" on page 336
♦ "NEXT_CONNECTION function" on page 351
♦ "NEXT_DATABASE function" on page 352
♦ "PROPERTY function" on page 357
♦ "PROPERTY_DESCRIPTION function" on page 356
♦ "PROPERTY_NAME function" on page 358
♦ "PROPERTY_NUMBER function" on page 358
The following table shows the Adaptive Server Enterprise system functions
and their status in Adaptive Server Anywhere:
List of functions
Compatibility