I wrote a small skript which transfers some data saved in tdpur4120m000 to a new table. I use db.insert for this (see below). When I have look it works and all data written in the customized session is written to the new table. But when I have a look later in the new table some of the records are gone.
Records I saw before (with the main session for this new table) there suddenly gone! Hopefulle someone can help.

Thanks
Alex

bthw. These function is called in the main.table.io section in after.rewrite.

tcmcs.dll0004.read.default.number(2, output_number, tcckon.purch.req, 6, 1, 0 ,0)
tdzzz400.zaeh = output_number
tdzzz400.pulv = tdpur045.item
tdzzz400.chrg = tdpur045.chrg
tdzzz400.mass = tdpur045.mass
tdzzz400.mnge = tdpur045.dqua
tdzzz400.wenr = tdpur045.reno
db.insert(ttdzzz400, db.retry)
commit.transaction()
tcmcs.dll0004.fix.default.number(2, output_number, tcckon.purch.req, 6, 1)
commit.transaction()

did you check it from SQL PLUS side .???

Meanwhile I found the error. From a subsession I updated the records and in some cases the main index field was empty, so the record was corrupt.

Great boss u solved the error ur self