Test Data Manager Masking: Masking Functionality about varchar(max)

Article Id: 16133

Status: Published

Updated On: 14-02-2018 07:50

Legacy Id: TEC1649626

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

Will masking and sub-setting work if XML files are stored in SQL varchar(max) data sets?

Environment:

Release: TDMTDD99000-4.4-Test Data Manager-for Test Data on Demand
Component:

Resolution:

Prior to SQL 2016, there is a MAX of 2000 for each column. If XML data goes beyond 2000, and SQL 2016 and up is being used, the upper limit is 8000.