How to use Column Alias in Informix database table

Question

I want to use column aliases while selecting the column in an informix database table. For example in the following query:

SELECT hire_dt as "Hire Date" FROM employee

Column hire_dt should be displayed as Hire Date. How can I do this in informix?

Answer 1

This is fine as long as you have the DELIMIDENT environment variable set. Read up about it in the documentation.