Clearing the OLT
Sometimes, you must manually clear data from the output list table (OLT). For example, before you modify the output list table, you must clear data that is entered by a previous run of the process. You must also clear the OLT manually to remove obsolete data.
About this task
Number of digits manageable by Deliver:
Bigint data type of DB2 support maximum 2^63-1 value which works with Deliver OLT as well, 19-digit value (9223372036854775806) in Deliver and OLT is created successfully on OD side as well.
Bigint data type of DB2 (User tables) gets created as Decimal in OD table which supports even bigger numbers than bigint.
Procedure
- On the Output tab of the Deliver process, click Clear table now.
- When prompted, confirm the request to clear the table.