ALIAS function

The ALIAS function returns the alias corresponding to the integer value of expression.

Syntax 

 

ALIAS ( integer-expression )

integer-expression

If there are, for example, three currently defined aliases, the functions ALIAS(1), ALIAS(2), and ALIAS(3) return them. If the ALIAS function cannot find a defined alias, it returns the Unknown value (?). For example, building on the previous example of three defined aliases, the functions ALIAS(4), ALIAS(5), and ALIAS(6) return the Unknown value (?) because they cannot find a defined alias.

Example 

This procedure displays the aliases and logical names of all connected databases.

 

r-aliasf.p

DEFINE VARIABLE ix AS INTEGER NO-UNDO.   REPEAT ix = 1 TO NUM-ALIASES: DISPLAY ALIAS(ix) LABEL "Alias" LDBNAME(ALIAS(ix)) LABEL "Logical Database". END.

See also 

CONNECT statement, CONNECTED function, CREATE ALIAS statement, CREATE CALL statement, DATASERVERS function, DBCODEPAGE function, DBCOLLATION function, DBRESTRICTIONS function, DBTYPE function, DBVERSION function, DELETE ALIAS statement, DISCONNECT statement, FRAME-DB function, LDBNAME function, NUM-ALIASES function, NUM-DBS function, PDBNAME function, SDBNAME function