How to run the Pre and Post SQL's scripts in TDM portal? In FDM we have POSTSQLCODEFILE and PRESQLCODEFILE masking options, however these options are not found in the TDM Portal.
Release : 4.10
The POSTSTEP ans PRESTEP masking options (Masking Settings page) were exposed in TDM Portal starting with TDM Portal release 4.10.184.0. In the masking options (Masking Settings page), you should find a POSTSTEP and PRESTEP option, which allows you to execute a SQL script before or after the masking is preformed.
TDM Portal/FDM can automatically create post and pre SQL scripts used to drop/recreate triggers and FK constraints during the scanning of the tables, as long as the DBUPDATES=P is set.
The options you should be aware of are:
(Note: DBUPDATES=S only available for non-DB2 databases with unique or primary key columns.)
TDM Patches are available for download at Test Data Manager (TDM) Support Patches
For more information regarding the masking options, see TDM Reference - Masking Options