Version 3 Technical Highlights - Aliasing Tables Programmatically

Published ByDateVersionKnowledge LevelKeywords
Sprezzatura Ltd01 NOV 19923.0+EXPERTSETALIAS_SUB, SETALIAS, TABLE

SetAlias_Sub

To SetAlias tables programmatically the subroutine SetAlias_Sub has been added. This routine takes six parameters, identical to the corresponding TCL command as follows -

SetAlias_Sub( Location , Account , Password , Table , NewTable , Options)

where

LocationThe location of the table being SetAliased to.
AccountThe account the table being SetAliased to resides in. Note that if it is not in the same account or the global account, or the current account is not SysProg, a password will be required if the account is password protected.
PasswordPassword of the account being SetAliased to.
TableName of the table being SetAliased to.
NewTableName of the table to act as alias for the table being SetAliased to. Note that if this is left blank the aliased table will be SysAlias NOT QFILE.
OptionsThe only options supported are those described in the AREV 3.0 reference for SETALIAS the TCL verb.

(Volume 4, Issue 6, Page 11)