Expressions Need Explicit Aliases for Use with Terminal Monitor
When using Terminal Monitor or in reports where column names are significant, we recommend that you assign an explicit alias to all expressions.
This also applies to queries that make use of
derived tables (see
Support for Derived Tables).
Starting with version 3.0 of Enterprise Access, expressions and literals in Terminal Monitor no longer return "col1", "col2", and so on. For Oracle and DB2 UDB, the native DBMS derived column name is returned instead. For example, in Oracle:
select 1
+------+
| 1 |
+------+
| 1 |
+------+