VMS Help  —  SQLMOD72  Arguments  ALIAS
    Specifies the default alias for the module. If you do not specify
    a module alias, the default alias is the authorization identifier
    for the module.

    When the FIPS flagger is enabled, the ALIAS clause (by itself
    or used with the AUTHORIZATION clause) is flagged as nonstandard
    syntax.

    If the application needs to refer to only one database across
    multiple modules, it is good practice to use the same alias
    for the default database in all modules that will be linked
    to make up an executable image. If that image will include
    modules processed with the SQL precompiler, you should specify
    RDB$DBHANDLE in the AUTHORIZATION clause of all SQL modules in
    the image because the alias RDB$DBHANDLE always designates the
    default database in precompiled SQL programs.
Close Help