Copying to and from Secure Adaptive Server

Each row in a Secure Adaptive Server table has a sensitivity column, which contains the sensitivity label for the row. Secure Adaptive Server uses sensitivity labels to mediate access to data.

When bulk copying into or from a Secure Adaptive Server table, an application can choose whether or not to include the table’s sensitivity column in the bulk-copy operation.

To include the sensitivity column, an application sets the BLK_SENSITIVITY_LBL property to CS_TRUE. BLK_SENSITIVITY_LBL has a default value of CS_FALSE, which means that by default the sensitivity column is not included.

Users copying into the sensitivity column must have the bcpin_labels_role activated on Secure Adaptive Server. If a user does not have this role, the bulk-copy operation will fail. See your Secure Adaptive Server documentation for more information on setting this role.