Hi Pranas, > Environment: > SAP DB Loader: SAP DB 7.4 > I need some way to import "large" data sets from ASCII files. > Application should not try to import files twice or lost > files in any way. > Tables: > * FileList table > * Data table > 1. Transaction Start > 2. Remove files (stored in FileList table) from file system > 2.1 Delete records from FileList table > 3. Read file list of files from input directory and store in FileList tables > 4. Import files > 5. COMMIT > -------------------------------------------------------------- > The problem with SAP DB Loader - it is not possible to invoke > and control DATALOAD, SELECT, INSERT, DELETE in the same transaction, isn't it.
i think the *autocommit off* statement of sapdb loader solves your problem. use sql and loader statements in one loader session. use user ... http://www.sapdb.org/7.4/htmhelp/0f/ebf2d7ddd211d2a97500a0c9449261/frameset.htm // autocommit off http://www.sapdb.org/7.4/htmhelp/0f/ebf2c8ddd211d2a97500a0c9449261/frameset.htm // delete from FileList ... // insert into FileList ... // dataload ... http://www.sapdb.org/7.4/htmhelp/ec/d93fb9400d11d3aa27006094b92fad/frameset.htm // commit Regards Hans-Georg -- Hans-Georg Bumes SAP DB, SAP Labs Berlin http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
