Want to Know More About Import, Load and Special Register in DB2

Posted by
Tableau+Jobs
        Tableau+Jobs

Special register — a storage area that is defined for an application process by DB2 and isused to store information that can be referenced in SQL statements. Examples of a “specialregister” are CURRENT TIMESTAMP or CURRENT USER.

Difference between Load vs Import

The INSERT statement lets you insert a row or several rows of data into the table. The LOAD utility, intended for loading large volumes of data, places rows directly onto data pages, maintains indexes in bulk rather than row-by-row, and has the capability to avoid logging. Note: Linux, UNIX, and Windows provides an IMPORT utility to insert rows from a file of data. It uses INSERT statements, and is designed for loading small amounts of data.