Im trying to write a query to find out list of tables being affected by DML operations. I joined dbqlogtbl,dbqlsqltbl and dbqlobjtabl.
but the objecttbl is logging the table that is being used in the read part.
for exanple below is a insert logged in the sqltable
INSERT INTO sampletable(acolumn,bcolumn,ccolumn)SELECT a,b,cFROM sampletable1 CROSS JOIN( SELECT day_of_calendar AS x FROM sys_calendar.CALENDAR WHERE x BETWEEN 1 AND 2)
When i join the dbqllogtable, dbqlsqltable and object table it is giving me all the 3 tables (sampletable, sampletable1, CALENDAR ) in my result.
Is there a way to get just the sampletable??
Is there a way to get just the "sampletable" from the above logged query
some where condition like below?
c.sqltextinfo NOT LIKE '%from%' || TRIM(a.objecttablename) || '%with data%' --that is one of my where clause conditions