Re: Q: Ignoring Errors in DBACCESS
Posted in 1998
In article <44C2247EAFF4D011B0BD00805F85B09C0A350E8F@news.maricopa.gov>,
"Fred Prose" <fprose@primenet.com> wrote:
> Is there a way to tell DBACCESS or ISQL to ignore errors in an SQL script
> file? For example, don't stop if a DROP TABLE statement executes and the
> table doesn't exist.
>
>
If you run the sql statements from the command line, the execution does not
terminate on an error.
For example, if you have a drop table statement and a create table statement
saved in a file called newtable.sql, and you want to execute it against
database demo, you can run it from the command line as follows:
$ dbaccess demo newtable
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum