Re: Let me try this again..........

Sorry no SCO here. We do have an Apache/Perl/DBI/Informix/AIX environment. Here's a cron/script/dbaccess sample. The root crontab runs daily_stuff as informix. Among other things daily_stuff runs groups of update statistics and logs completion. There are other ways to run dbaccess; e.g. cat script.sql | dbaccess -e online1. From root's crontab: # M-F 8PM Informix runs the daily_stuff script 00 20 * * 1,2,3,4,5 su - informix -c /usr/local/adm/daily_stuff daily_stuff: #Do some UNIX file maintenance... <intentionaly left blank> #Quiesce the db, run level 0 archive, stop/start logging, send some e-mail, etc... <intentionaly left blank> #Run some update statistics... dbaccess //crap/online1 /home/system/dba/upd1_stats.sql >> /home/system/dba/upd1_stats.log 2>&1 & dbaccess //crap/online1 /home/system/dba/upd2_stats.sql >> /home/system/dba/upd2_stats.log 2>&1 & NEWS 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. > > Please reply to gary.berger@odnss.com. > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----