Running SQL as a cron job
Set the informix environment up in the script that runs dbaccess:
For example (assumes online):
INFORMIXDIR=/usr/informix
INFORMIXSERVER=testserver
export INFORMIXDIR INFORMIXSERVER
PATH=$INFORMIXDIR/bin:$PATH
dbaccess testdb sqlfile
That should do it, remember to redirect output to a file if you are doing selects.
Mark
MarkDenham@aol.com (home)
Denham.M@amstr.com (work)
--------------------------( Forwarded letter 1 follows )---------------------
Date: Wednesday, 28 May 1997 4:50am
X-Originating-IP: [198.133.29.51]
From: "SH Lim" <sweehock@hotmail.com>
To: informix-list@rmy.emory.edu
Subject: Running SQL as a cron job
Date: Wed, 28 May 1997 03:42:53 PDT
Sender: informix-list-owner@rmy.emory.edu
Reply-To: sweehock@hotmail.com
X-Informix-List-Id: <list.14670>
Helper(s),
Is there any way that I can run a SQL through dbaccess - <sqlfile>
specified as a cron job in AIX.
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 ?
---------------------------------------------------------
Get Your *Web-Based* Free Email at http://www.hotmail.com
---------------------------------------------------------