Re: Running SQL as a cron job

On 28 May 97 at 3:42, SH Lim wrote: > I've tried it this "/usr/informix/bin - > /usr/informix/sqlfile.sql" as the > command to the cron. There's a -32766 error which upon investigation > could be INFORMIXDIR set incorrectly. > Any idea how I can do this ? Write a shell script which sets up your environment correctly: INFORMIXDIR=/usr/informix PATH=$INFORMIXDIR/bin export INFORMIXDIR PATHdbaccess - /usr/informix/sqlfile Then run that script from cron. HTH. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Johannesburg, Murder Capital of the World GEMINI May 21 - June 20 You are quick and intelligent and a thinker. People like you because you are bisexual. However, you are inclined to expect too much for too little. This means you are a cheap bastard. Geminis are liars, notoriously lousy lovers and thrive on incest.