OVERRIDE_TABLE procedure

The OVERRIDE_TABLE procedure sets the blocking size for a table.

Read syntax diagramSkip visual syntax diagramOVERRIDE_TABLE( schema-name,table-name,blocking-size )

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);