Re: dbimport failed - IDS 9.30 UC3

Hi Hari, hariog@yahoo.com (Hari Gupta) wrote: > 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. > ------------------------------------------------------------------- IIRC, you need to insert 'null' at the empty fields: execute procedure "auth".sp_stop_clock('D' ,null ,null ,old.doc_typ... Then it should work. This is a known bug (looks like 158980) and shall be gone with 9.30.UC4 see also (link wrapped): http://www-3.ibm.com/software/data/informix/pubs/ library/notes/relnotes/C170109.html Regards, R'diger