dbimport failed - IDS 9.30 UC3
Posted in 2003
Hi,
I have recently installed IDS 9.30 UC3 on Linux 7.3. Done a dbexport
with -ss and started dbimport with -d <dbspace-name>. After about 5
hrs, dbimport failed with following error:
------------------------------------
*** prepare sqlobj
201 - A syntax error has occurred.
------------------------------------
The statement just above where dbimport failed was a "create trigger"
as below:
-------------------------------------------------------------------
create trigger "auth".trg_altask_del delete on "auth".aualtask
referencing old as old
for each row
(
execute procedure "auth".sp_stop_clock('D' , , ,old.doc_typ
,old.doc_yer ,old.doc_num ,old.doc_prt ,old.wrk_typ ,old.seq_num
, , , ,old.mdu_ref ));
*** prepare sqlobj
201 - A syntax error has occurred.
-------------------------------------------------------------------
Pl. note that after this create statement, all statement were update
stats.
So what I did, created trigger seperately and ran update stats based
upon dbexport SQL file using dbaccess.
I did read few archives about this error but none of them reported
above error followed by 201 error.
There was an issues similar to this with dbimport in earlier verson of
IDS but I don't think it will be still an known bug with IDS 9.30 UC3.
Can some guru help me about this please ?
Pl. let me know if onconfig or some other info. is needed.
TIA
Hari