Re: Launch an sql script...
Hello Florin,
I checked these scripts under HP-UX 10.10/IDS 7.20UC2:
a.sql:
create table a(b char(10));!dbaccess vf b
drop table a;
b.sql:
select * from a;
After I run 'dbaccess vf a.sql', I got following output:
Database selected.
Table created.
Database selected.
b
No rows found.
Database closed.
Table dropped.
Database closed.
Your problem is, that you are open a new session with '!'. If you use
temp tables, then you can't refere to a table created in a.sql.
Yours Volker
Florin Micle schrieb:
>
> Does anyone know if I can launch an Informix sql script from within another
> script?
> For example I have the script a.sql
> and I want to run it from script b.sql.
> Is there any way I can do that?
> I know that in Oracle sql there is the '@' operator which does this job.
> @ a.sql - runs the a.sql script.
> I'm looking for some equivalent in Informix sql.
--
Volker Fraenkle CS Controlling
Technical Consultant Software Systeme GmbH
E-Mail: VFraenkle@cs-controlling.de
Phone: +49 7144 8144-0 Riedbachstrasse 5
Fax: +49 7144 8144-10 D-74385 Pleidelsheim