Re: cron and isql

} Subject: cron and isql } Date: Tue, 17 Jan 1995 16:11:48 +0000 } From: johnson@hqcso.attmail.com } To: informix-list@rmy.emory.edu } } Hi! } We are successful running loads and ACE reports in cron, but are } not able to do isql updates in cron. We were told that this is not } supported. Is this true? Anyone have any suggestions? } We are running this on an AT&T 3B2 with Informix 2.10 SE (yes, old } stuff). We are moving to current version of SE on an NCR box soon. } Don't know if the problem occurs on new box yet. } And we think we have all the environment variable set (PATH, } INFORMIXDIR, DBPATH) correctly. } } Thanks for any suggestions! } } Ray Johnson } AT&T Corporate ITS } rayjohnson@attmail.com } } Ray Johnson 908.771.3398 rayjohnson@attmail.com or attmail!hqcso!johnson Using Informix SE 2.10 on Sun computers, I have been able to run ISQL updates via cron. Unless there is some limitation specific to the AT&T port of SE 2.10, I do not know why you should not be able to do the same. I used a script containing the command line: isql dbname sqlfile The sysadmin and I needed to fiddle a bit with the environment variables to get everything to work, but it sounds like you have already addressed that issue. Regards, Alan +---------------------------+-----------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, SLS | Voice: 303-977-9998 | | P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | | Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | +---------------------------+-----------------------------------------------+