Hi,

I m using IBM DB2 8.2 work group edition. I found one problem of
running stored procedure to process inserting data, it cannot process
all the data I selected. Example: I select 1290 records which will
generated another 390 record. (Total record :1290 * 390 = 503100
records). After SP run completed, I checked the record, it only
generated 50 * 390 = 19500 records. I don't know what problem why
happen like that or need to set any configuration parameter of db2 ,
then it can only process all the records.

When I filter already inserted records in the same stored procedure and
run again, it will continue inserting the rest of records. But I need
to run many times for the same stored procedure and check until no more
record. Is it need to set the db2 configuration to allow more record
for inserting?


Thanks in advance,



- Powered by TIME dotNet Berhad -

DB2 & UDB email list listserv db2-l LazyDBA home page