What is the largest value for a where clause in and FDM Masking through TDM Portal?

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When setting up masking with FDM to run through the TDM Portal.
what is the maximum length of the where clause the can be used?

Cause

This limit is based on the gtrep schema as the where clause information is stored in this database to be reused.

Environment

TDM 4.9
FDM

Component : TDM Web Portal
Fast data masker

Resolution

there is currently a 2000 Character limitation for the where clause in FDM the same as for the variable field length.

This is stored in gtrep_mask_where