general | April 07, 2026

ALTER PROCEDURE statement - Documentation for ALTER and BMC AMI Change Manager for Db2 13.1

This option specifies whether references to archive-enabled tables in SQL statements are affected by the value of the SYSIBMADM.GET_ARCHIVE global variable. The following table lists valid values for the ARCHIVE SENSITIVE keyword.

ARCHIVE SENSITIVE keyword values

Value

Description

NO

Specifies that references are not affected.

YES

Specifies that references are affected.