On Windows, after typing the SQL statement, hit <enter> so the your cursor is on a new blank line, then hit <control>-z. That signals the EOF and hsql should continue. On Unix/Linux, you don't need to be on a blank line, and it's <control>-d instead.
Thanks..that was the problem....
CMCrossroads is a TechWell community.
Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.