ERROR - -565 During execution procedure

During execution procedure: ERROR - -565 (ISAM -101) Example of procedure : create dba procedure uni_test() create temp table ttt (key_1 integer, key_2 integer ) ; insert into ttt values (100, 100 ); insert into ttt values (100, 100 ); insert into my_table select unique key_1, key_2 from ttt ; -- my_table -- key_1 integer, -- key_2 integer, -- primary key (key_1, key_2) END PROCEDURE There is no error during execution of this simple SQL- statement without SPL. INFORMIX 7.31 UC2 HP-UX10.20

Traube Yuri wrote: > During execution procedure: ERROR - -565 (ISAM -101) > Example of procedure: > > create dba procedure uni_test()> > create temp table ttt > (key_1 integer, > key_2 integer ) ;> > insert into ttt values (100, 100 ); > insert into ttt values (100, 100 );> > insert into my_table > select unique key_1, key_2 from ttt ;> > -- my_table > -- key_1 integer, > -- key_2 integer, > -- primary key (key_1, key_2) > > END PROCEDURE > > There is no error during execution of this simple SQL- statement > without SPL. > > INFORMIX 7.31 UC2 > HP-UX10.20 Is there any chance that the row (100, 100) already exists in my_table when you run the SP? Can you show that it does not exist? I agree it looks suspicious. Have you run with SET EXPLAIN ON to see what the query plans are? You'd probably need to do UPDATE STATISTICS FOR PROCEDURE uni_test() to get the information. Have you run with SPL debug logging on? This might tell you what is going on -- give you the evidence you need to file a bug report, that is. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>