Special register: A storage area that is defined for an application process by DB2 and is used to store information that can be referenced in SQL statements. Examples of a “special register” are CURRENT TIMESTAMP or CURRENT USER.
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.
In 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.
Related posts
Srinimf 