Re: Q: executing sql script from within another sql script?
Posted in 1998
EA wrote:
>
> To all those Informix wizards out there:
>
> Is it possible in Informix dbaccess to call another sql script from within a
> sql script?
> In Oracle the @ sign is used for that like in
> @scriptname.sql
>
> Any help would be greatly appreciated. Thanks and
> Cheers
> E.
Not directly. But you can feed SQL scripts into dbaccess through stdin,
so a bit of mucking about with awk, sed or some such should do what you
want.
--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
Mail: Peter.Lancashire.PL1@bayer.co.uk
---
My Internet plumbing does not allow me to mail and post news together.
Sorry.
All opinions are my own and not those of Bayer plc.
---
Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/