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?

Environment

TDM 4.9.1+

Cause

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

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