Lookup and reference functions
- CHOOSE
- DBLOOKUP
- DBQUERY
- DDEQUERY
- EXTRACT
- GETANDSET
- GETDIRECTORY
- GETITXUID
The GETITXUID function returns a universally unique identifier (UUID). - GETLOCALE
The GETLOCALE function returns the locale setting of the computer. - GETFILENAME
- GETPARTITIONNAME
- GETRESOURCEALIAS
The GETRESOURCEALIAS function returns the resource alias value specified in a Resource Registry resource name file (.mrn). - GETRESOURCENAME
- GETTXINSTALLDIRECTORY
The GETTXINSTALLDIRECTORY function returns the HCL Link product installation directory. - INDEX
- INDEXABS
- LASTERRORCODE
- LASTERRORMSG
- LOOKDOWN
- LOOKUP
- MEMBER
- SEARCHDOWN
- SEARCHUP
- SORTDOWN
- SORTDOWNBY
- SORTUP
- SORTUPBY
- UNIQUE
- GETENV
The GETENV function returns the value of the environment variable. If no variable exists, an empty string is returned. - GETOSNAME
The GETOSNAME function returns the name of the operating system.