DB2 stored procedure cannot insert full new records I selected

DB2 stored procedure cannot insert full new records I selected

 

  

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.


Thanks in advance,



- Powered by TIME dotNet Berhad -

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