I am running a script the loads data from .dat files int informix...everything worked well a few days ago...but now I receive the error below
========SCRIPT===============
# -- load the tables in the order they were created, no
# --logging, commit not needed
dbload -d maximo -c craftcodes.ctl -l craftcodes.log -e 100
dbload -d maximo -c eqstatus.ctl -l eqstatus.log -e 100
sleep 2
onpload -j employee_ld -fl
sleep 2
onpload -j locations_ld -fl
sleep 2
onpload -j equipment_ld -fl
sleep 2
onpload -j wosummary_ld -fl
sleep 2
onpload -j pm_ld -fl
# added 7/15/02
#
dbaccess maximo <<-eof
SET PDQPRIORITY 80;
DELETE FROM pmdetail WHERE substr(pmnum,1,1) = ' ' or pmnum is null;
eof
onpload -j jobplan_ld -fl
sleep 2
onpload -j fleet_ld -fl
sleep 2
onpload -j invoice_ld -fl
===========ERROR=============
62900 Row(s) loaded so far to table maximo_eqstatus.
Table maximo_eqstatus had 62995 row(s) loaded into it.
Database selected.
PDQ Priority set.
2 row(s) deleted.
Database closed.
Cannot open database 'sysmaster@mxprd01_tcp' - SQL error -908, ISAM error 22
End of LOADTABLES.SH
Wed Nov 17 03:41:38 EST 2004
Database selected.
1 row(s) retrieved.
Database closed.
Database selected.
1 row(s) retrieved.
Database closed.
========SCRIPT===============
# -- load the tables in the order they were created, no
# --logging, commit not needed
dbload -d maximo -c craftcodes.ctl -l craftcodes.log -e 100
dbload -d maximo -c eqstatus.ctl -l eqstatus.log -e 100
sleep 2
onpload -j employee_ld -fl
sleep 2
onpload -j locations_ld -fl
sleep 2
onpload -j equipment_ld -fl
sleep 2
onpload -j wosummary_ld -fl
sleep 2
onpload -j pm_ld -fl
# added 7/15/02
#
dbaccess maximo <<-eof
SET PDQPRIORITY 80;
DELETE FROM pmdetail WHERE substr(pmnum,1,1) = ' ' or pmnum is null;
eof
onpload -j jobplan_ld -fl
sleep 2
onpload -j fleet_ld -fl
sleep 2
onpload -j invoice_ld -fl
===========ERROR=============
62900 Row(s) loaded so far to table maximo_eqstatus.
Table maximo_eqstatus had 62995 row(s) loaded into it.
Database selected.
PDQ Priority set.
2 row(s) deleted.
Database closed.
Cannot open database 'sysmaster@mxprd01_tcp' - SQL error -908, ISAM error 22
End of LOADTABLES.SH
Wed Nov 17 03:41:38 EST 2004
Database selected.
1 row(s) retrieved.
Database closed.
Database selected.
1 row(s) retrieved.
Database closed.