Copying to and from Secure Adaptive Server Enterprise

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

When bulk copying into or from a Secure Adaptive Server Enterprise 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 Enterprise. If a user does not have this role, the bulk-copy operation fails. See your Secure Adaptive Server Enterprise documentation for more information on setting this role.