|
See
Also
|
·
|
All output expressions must have an alias. In the case of a
SetSelect: the first SELECT statement under the invoke must provide
the mandatory aliases. |
|
·
|
Aliases are required to provide the link between the data and
the metadata within the XML document. Aliases must be unique within
the XML document. |
|
·
|
If a database column is not given an alias in the statement,
USoft Developer will create its own alias, as in the following
examples: |
|
Statement
|
Alias
|
|
SELECT id, name FROM emp
|
<ColumnName>
Example: ID, NAME
|
|
SELECT id, id, id FROM emp
|
<ColumnName>_<Seqno>
Except for the first alias.
Example: ID, ID_2, ID_3
|
|
SELECT e.id, d.id FROM emp e, dept d
|
<TableName>_<ColumnName>
Example: EMP_ID, DEPT_ID
|
|
SELECT 'Application' id, id FROM emp
|
<ColumnName>_<Seqno>
Except for the first alias.
Example: ID, ID_2
|
|
