Re: Beginner: How can I load/import *.sql-Files?!?
Posted in 2000
Use the dbaccess utility. You can run it in menu mode or commandline mode.
In menu mode:
dbaccess databasename
Then choose <Query> then <Choose> then select the .sql file by name or type
in the filename without the .sql extension and it will be loaded into the
SQL editor. Choose <Run> or <Output> and an output option to execute it.
Commandline mode:
dbaccess databasename - <myfile.sql
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