LOAD and UNLOAD functions
Updated June 2024
June 2024 change log:
- sp_load into temp table handled
- sp_load no longer specifies EXPRESS (only caused warning in message log)
September 2023 change log:
- Work-around for tables containing hidden specialized columns such as VERCOLS
- DBDATE external table option removed for better flexibility via environment
- CONSTRAINTS also disabled as necessary for EXPRESS with hidden indexes.
We have raised relevant APARs to be fixed in 14.10.xC11. They are:
IT44526 SQL error: -26190 and -236 on inserting external table from a ‘table having VERCOLS’
Worked around in “sp_load” by excluding all type of hidden specialized columns.
IT44527 Inaccurate documentation on conditions forcing DELUXE load from external table
DELUXE is in fact forced if the table contains BYTE/TEXT columns or the row size exceeds page size minus 32.
Abstract
[Read More…]