Progress
Language Reference


CREATE ALIAS Statement

Interfaces
OS
SpeedScript
All
All
Yes

Creates an alias for a database. Once an alias is created, it can be used in place of the database’s logical name.

NOTE: A database can have more than one alias, but each alias refers to one and only one database.

SYNTAX

CREATE ALIAS alias-string | value ( expression )
  FOR DATABASE logical-name-string | value ( expression )
  [ NO-ERROR ] 

alias-string | value ( expression )

An unquoted string, quoted string, or CHARACTER expression that represents an alias for the database.

FOR DATABASE logical-name-string | value ( expression )

An unquoted string, quoted string, or CHARACTER expression that represents the logical name of the database.

NOTE: The logical name must already be set.

NO-ERROR

Tells Progress to allow the alias to be created even if the database is not connected.

If you CREATE ALIAS for a database that is not connected and omit NO-ERROR, Progress reports a run time error.

NOTE: The NO-ERROR option of the CREATE ALIAS statement behaves differently from the NO-ERROR option of other 4GL elements.

EXAMPLE

This procedure creates the alias myalias for database mydb.

r-cralas.p
CREATE ALIAS myalias FOR DATABASE mydb NO-ERROR 

NOTES

SEE ALSO

ALIAS Function, CONNECT Statement, CONNECTED Function, CREATE DATABASE Statement, DATASERVERS Function, DBCODEPAGE Function, DBCOLLATION Function, DBRESTRICTIONS Function, DBTYPE Function, DBVERSION Function, DELETE ALIAS Statement, DISCONNECT Statement, ERROR-STATUS System Handle, FRAME-DB Function, LDBNAME Function, NUM-DBS Function, PDBNAME Function, SDBNAME Function


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095