bizarre infrequent error with dbload
Posted in 1997
hi,
This script runs 14x throughout the day, extracting data from ods vers7.13UC3 on hpux10.01, and loads data into ods 7.23uc4 on solaris 2.5.1.
i would get this error now and then, and could not understand why.
Dropping and creating tables in the datamart: Thu Dec 11 15:57:56 PST 1997
Error in line 1Near character position 18
Error in line 113Near character position 35
and this error originates from this line in my script:
dbaccess dbname summfile.sql
--> and my summfile.sql :>
drop table summfile;
create table summfile(
...) extent size 54000 next size 20000;
drop table summhead;
create table summhead (...);
and if i run the script again, everything will run without any hiccups. i get this error once a few months, and could not really understand why.
pls advise. thanks.
hk