Re: Running SQL as a cron job
SH Lim wrote:
>
> 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
> ---------------------------------------------------------
What I would to is create a shell script that sets the necessary
environment variables and then executes the sql file ie;
Contents of myshellscript.sh
#!/bin/sh
INFORMIXDIR=/usr/informix;export INFORMIXDIRdbaccess database-name < mysqlfile.sql
#<EOF>
Something like that.
Hope this helps.
Chris Swecker
chris_swecker@avid.com