OVERRIDE_TABLE procedure
The OVERRIDE_TABLE procedure sets the blocking size for a table.
The schema is QSYS2.
- schema-name
- A character string expression containing the name of the schema.
- table-name
- A character string expression containing the name of the table.
- blocking-size
- A character string expression containing the blocking size. It can be a specific byte count or a special value of *BUF32KB, *BUF64KB, *BUF128KB, or *BUF256KB.
Example
- Override the EMPLOYEE table to use 256K blocking for sequential
processing.
CALL QSYS2.OVERRIDE_TABLE('CORPDATA', 'EMP', '*BUF256KB');
- Remove the override.
CALL QSYS2.OVERRIDE_TABLE('CORPDATA', 'EMP', 0);