Calculated Field
Thanks for your reply. The reason for using the DATE field is that I want the column that is returned to contain the System Date.
I have been looking fufther, Would this involve the use of the INTO statement? I can use the "current date" function when I query a DB2...
I am trying to return a calculated field of the system date on an sql query to a Progress database. I tried the following...
SELECT COUNT(DISTINCT AL1."control#"), DATE From ...
But I get an error saying that the "DATE" column is not found in the table.
Is there a way to return columns...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.