Recent content by texasprd

In response to tamhas; If you equate "simple field" to "column" (select column from table), tried that already (see post #3). Also tried putting parens around the entire MAX function - no joy there, either. And "AS" in all attempts returns the same result - ""** AS or LIKE phrase not allowed...

That's correct - I am doing this in the Progress client/editor on AIX. My apologies for not specifying that earlier... As for why I'm trying to do SQL from the Progress client, I do SQL whenever I can in order to build my skills in that area. The reasons for that belong in another thread -...

medu, thanks for your reply! Unfortunately, "date" as keyword and column name isn't the issue. (I didn't design this db - it was done by someone before me. I would not have used a keyword as a column name) "select g1.date from glc g1" works, so the table-name alias works, and clearly the...

We're running our data mart on Progress 9.1E. Even with an extremely simple query like "select g1.date DATE1 from glc g1" the column-alias fails and I get the following: "** Unable to understand after -- "select". (247)". "select g1.date alias DATE1 from glc g1" yields the same result...

Hello; We don't have a Progress DBA here, so I need a bit of help with the following: I'm writing a purge routine for our data warehouse, and we need to copy the db to another host (Progress 9.1E, AIX 5.2) for testing. The production db occupies multiple file systems due to space...