Alias

The alias statement is used for setting an alias according to which a field will be renamed whenever it occurs in the script that follows.

Syntax:  

alias fieldname as aliasname {,fieldname as aliasname}

Arguments:  

Examples and results:

Example	Result
Alias ID_N as NameID;
Alias A as Name, B as Number, C as Date;	The name changes defined through this statement are used on all subsequent SELECT and LOAD statements. A new alias can be defined for a field name by a new alias statement at any subsequent position in the script.