Re: Running SQL as a cron job
On Wed, 28 May 1997, Chris Swecker wrote:
} 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 INFORMIXDIR
also add:
INFORMIXSERVER=<your server name here>;export INFORMIXSERVERyou might not need that line if you're only runnig one server.. I use
those two environment variables everytime I access Informix...
} dbaccess database-name < mysqlfile.sql
}
}
} #<EOF>
}
}
}
}
} Something like that.
}
} Hope this helps.
}
}
} Chris Swecker
} chris_swecker@avid.com
}