RE: Beginner: How can I load/import *.sql-Files?!?
Posted in 2000
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues
In my experiences, "dbaccess databasename script" does not
stop after the first error.
However, the following environment variable will also cause dbaccess
to stop after the first error: DBACCNOIGN=1
Otherwise, it continues it execute subsequent SQL commands.
-----Original Message-----
From: Art S. Kagel [mailto:kagel@bloomberg.net]
Sent: Wednesday, January 26, 2000 9:52 AM
To: informix-list@iiug.org
Subject: Re: Beginner: How can I load/import *.sql-Files?!?
Mark, I always thought there was a difference between the two. That
dbaccess databasename script
stops on the first error as the scripts do from within the menus while
dbaccess databasename - <script.sql
continues past errors.
Art S. Kagel
"Mark D. Stock" wrote:
> QueriX 4GL / Mehdi wrote:
> >
> > Andreas Pietzowski wrote:
> >
> > > Hi :-)
> > >
> > > I'm very new at the InformixSE at Linux and on thursday I have a
> > > SQL-test at school. I have two *.sql-Files from school and I want to
> > > practice a little bit at home with these tables because I know them
from
> > > school.
> > > The files are "cia.sql" and "movie.sql". How can I open them? I tried
to
> > > create a new database and I wanted to import these two files into this
> > > new database but I don't know how :-]
> > >
> > > It would be great if somebody can help me out because there are only
> > > three days left....
> > >
> > > Thanks :-)
> > > Pietz
> > >
> > > --
> > > Windows is NOT a virus:
> > > A virus is small and efficient.
> > > mailto:Pietz@newsfactory.net
> > > ICQ#: 36866936
> >
> > dbaccess data_base_name - <sql_file.sql
>
> I hate to be picky..., but it's in my nature. ;-)
>
> That hyphen is to indicate you don't have an sql file. Then you go and
> pump an sql file in with redirection. Why not just say:
>
> dbaccess database_name sql_file.sql
>
> You don't even need the .sql as long as your file has that suffix.
>
> Cheers,
> --
> Mark.
>
> +----------------------------------------------------------+-----------+
> | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
> | http://www.informix.com http://www.informixhandbook.com |///// / //|
> | http://www.iiug.org +-----------------------------------+//// / ///|
> | |What year 2000 bug? year 2000 bug? |/// / ////|
> | |year 2000 bug? year 2000 bug? year |// / /////|
> | |2000 bug? year 2000 bug? year 1900 |/ ////////|
> +----------------------+-----------------------------------+-----------+