Deletes an alias from the alias table.

Syntax

DELETE ALIAS {alias| VALUE ( expression ) }
alias
An existing alias. It can be an unquoted string or a quoted string.
VALUE (expression)
A character-string expression that evaluates to an existing alias.

Example

This procedure deletes the alias myalias from the alias table:

r-dalias.p 

DELETE ALIAS myalias.

Notes

  • If a precompiled program requires an alias and you delete that alias, the program will not run.
  • If you try to delete a nonexistent alias, nothing happens.

See also

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