Re: Running SQL as a cron job
} 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: "SH Lim" <sweehock@hotmail.com>
} X-Informix-List-Id: <list.14670>
} Content-Type: text/plain
} Content-Length: 520
} Status: RO
}
} 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 ?
}
Try sticking the command into a shell script of choice. Then set your Informix
environment variables in the shell script. Then stick the shell script into
cron. Dont forget to add "#!/bin/ksh", or whatever shell you want cron to use,
at the very first line. It uses bourne shell as it's default.