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.