Re: Scheduling SQL statement

NEWS <gary.berger@odnss.com> wrote: > Is there a way that I can put SQL statements in a file and run them from > cron? I am on Informix 5 on SCO. The manuals refer to being able to supply > a file of inputs instead of going interactive. The programs it sites are > dbaccess and informix-sql. > > Your assistance is greatly appreciated. > > Also, I am paritculary interested in knowing if anyone has Apache running on > SCO linking into Informix data tables. The basic problem with cron is ensuring the Informix environment is set correctly -- the default environment is (deliberately) minimal, and you need to fix it before doing any work. You could investigate SQLCMD from the IIUG software archive (http://www.iiug.org) as an alternative to isql/dbaccess. I'm not certain that the version 5.x support is still OK, but I believe it should be. I can't help on SCO specifically, but I've got Apache linking to Informix on my Solaris box via Perl/DBI/DBD::Informix with or without mod_perl, and via PHP (mod_php), and ... -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"