DB2 Version 4.1


Column naming and renaming

The AS clause names or renames a column or expression that appears in a SELECT clause. Example:

SELECT FIRSTNME AS FIRST_NAME ...

Prior to DB2 V4.1, the only way to rename a column was to create a VIEW -- a cumbersome procedure.

Query coded the old way:

Produces this result:




Query coded the new way, with column renaming:

Produces this delightful result:






©Copyright 1996 Chuck Anesi all rights reserved