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:
| Argument | Description |
|---|---|
|
fieldname
|
The name of the field in your source data |
| aliasname | An alias name you want to use instead |
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. |
