Long description columns in Oracle databases
Long description columns are stored in a CLOB (character large object) column in an Oracle database.
However, interface tables contain two versions of each CLOB column, one with data type CLOB, and one with data type ALN with a character length of 4000. In the following example, the name of the CLOB column is the column alias. The name of the alphanumeric column is the column alias with the suffix 2.
|
Data type |
Description column name |
|---|---|
|
CLOB |
PO_DESCRIPTION_LD |
|
ALN |
PO_DESCRIPTION_LD2 |
Maximo® Asset Management populates both columns in outbound transactions. For inbound transactions, the integration framework uses the value in the ALN column if it is not null; otherwise, the value in the CLOB column is used.