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.
I've implemented similar import procedure in SQL Server 2000 (using DTS
Service):
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.
Has somebody implemented similar data load procedure? Please share you
experience.
Are there some other ways to sinchronize the state of DBMS and file system?
Thanks,
Pranas Baliuka
Danet Baltic UAB
http://www.danet.com
P.S. JDBC calls for importing large data sets are slow.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
