Re: Getting error "-23101 Unable to load locale categories"...Please Help.!!

Neil wrote: > I currently have a sun ultra 5 running informix 7.2 > and dbaccess version 7.23.UC4 Look to upgrade - 7.23 is not Y2K-compliant. > I am using cron to run a script file that calls another script file that Your question involves cron and things not working that work at the command line. The answer involves the environment. Cron doesn't set it for you -- so you have to do it for yourself. Run a shell script which sets the environment and then runs the command. > contains the following command. > "echo 'SELECT node_id,node_name FROM node' | $SQL_DBACCESS/dbaccess > stratacom >> $SQL_DIR/sqlresult-nodelist" > The command above run's fine when I am logged in as a user of the machine. > Can see a list of results read from the informix DB. > > When checking mailx I see a message with the following error returned from > dbaccess/informix. > when the cron job is runned... > > Your "cron" job on saturn > /usr/users/utils/schedule/runevents > produced the following output: > -23101 Unable to load locale categories. > > What can I do to get this script-cron job to run.. All the nessacery vars > like > $INFORMIXDIR, $CLIEN_LOCALE, $DB_LOCALE are set in /etc/.login > is there anything else that I missed. ?? > > Thanks > Neil.B > > my "env" variables for the sun machine are as follows > [...snip...] -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/