PDO view statement in PDCR

Database
Enthusiast

PDO view statement in PDCR

Hi,

We do have PDOs from Informatica that does create views as a temporary purpose and drops them at the end of the job. While looking at history data in PDCR data, we cannot find the create view DDL step neither from DBQLOBJTBL_HST nor from DBQL SQL table. Eventhough we can see it in DBC infos, but it retains only a few hours in the past. We cannot really go back to see the older runs. Is there a way to find the DDL statement (Statementtype = 'Create View') in PDCR views for a particular session?