The "CLOBs to Be Loaded" screen loads CLOBs into the database with SQL Loader.
A CLOB (Character Large Object) is a potentially large data element in a database. It consists of characters with a character encoding that is tied to the database, as opposed to a BLOB. Data stored in a CLOB with a specific character encoding is also returned by the database in that character encoding.
The entry fields are:
- "Name of Object": The table in which the CLOBs are stored.
- "Column": The column in which the CLOBs are stored.
- "Natural Key": The natural key of the row in which the CLOB is stored.
- "Original System Reference Value": The reference value of the CLOB in the system of origin.
- "CLOB": The CLOB that is stored.
- "Loading Message": The result of the last attempt to load the CLOB into the database.
The other fields are:
- "Sequence": The sequence number of the CLOB.