If you want to rename the columns that appear in your result, you can create a computed column that contains, as an expression, just the name of the column you want to rename. Type in a new name in the Computed Column Name field. Your result column is automatically renamed. If you do not provide a name, a default (Column 1) is used.
This option is not supported by DB2 version 3.x and earlier. Therefore, it is not available in DB2 mode.