UniDAC

TUniLoader Class

TUniLoader allows to load external data into a database table.

For a list of all members of this type, see TUniLoader members.

Unit

UniLoader

Syntax

TUniLoader = class(TDALoader);

Remarks

TUniLoader serves for fast loading of data to the database. To specify the name of the loading table set the TableName property. Use the Columns property to access individual columns. Write OnGetColumnData or OnPutData event handlers to read external data and pass it to the database. Call the Load method to start loading data.

For each type of database server TUniLoader uses its specific interfaces for loading with maximum speed.

For Oracle the Direct Path Load interface is used.

For SQL Server loading is based on the memory-based bulk-copy operations using the IRowsetFastLoad interface. Data loading is performed without transactions.

For PostgreSQL data are loaded using the COPY command.

For MySQL, InterBase, and Firebird loading uses INSERT SQL statements. In this case several rows are combined in one statement if possible. In Firebird 2.0 and higher INSERT statements are combined in one EXECUTE BLOCK statement.

Inheritance Hierarchy

TDALoader
   TUniLoader

© 1997-2020 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback