At 10:15 AM 12/03/2003 +0000, Roman Rokytskyy wrote:

>Robert,
>
> > Thanks Rick, but I'm not sure this answers my question. Do I have
> > to parse the SQL DDL script file and process the lines myself or is
> > there a call I can use to execute the script and handle the parsing
> > and comments correctly?
>
>Not sure about the comments, but you cannot execute more than one
>_statement_ at once. So, you will need to split your SQL script and
>handle correctly ";" and "SET TERM". I think comments in your SQL
>should be ok, server should handle this (however, I never tried).

Is is really this hard to do DDL with Java? Surely then the best advice
would be to use isql to run scripts...

Helen