How to use a column alias in an Informix database table

Question

I want to use column aliases when selecting a column in an Informix database table. For example, in the following query:

SELECT hire_dt as "Hire Date" FROM employee

The column rent_dt should be displayed as the date of hiring. How to do this in informix?

Answer 1

This is great if you have an environment variable DELIMIDENT. Read about this in the documentation .

Answer 2

In the connection string you can use:

Database=mydatabase;Host=192.168.100.1;Max Pool Size=3;
Min Pool Size=1;Pooling=True;Protocol=onsoctcp;Password=informix;
Server=ol_server;Service=1256;User ID=informix;delimident=y

delimident = y