Re: dbimport failed - IDS 9.30 UC3
Thank you very much Art. Appreciated for explaining the issue and work
around solution as well.
BUT I still not don't get why one has to look for dbexport SQL file and edit
manually. When this is
a known bug then why can't IBM fix this ? When professional (Guru) like Art
can fix such issue with their
own developed utilities, IBM _SHOULD_ fix without any if and buts.
Sorry about my language if I said some thing wrong.
Hari
"Hari Gupta" <hariog@yahoo.com> wrote in message
news:1a1cd35b.0310052339.69ca95e2@posting.google.com...
> 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