Re: Beginner: How can I load/import *.sql-Files?!?

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 |/ ////////| +----------------------+-----------------------------------+-----------+

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 |/ ////////| > +----------------------+-----------------------------------+-----------+