TraceMagic 1.2.0.0 does not capture all SELECT statements
This is my first time using TraceMagic v1.2.0.0 with file <OPID>_hostname.tracesql.
In the tracesql file I see plenty of these statements :
COM Stmt=SELECT PTCUSTOMFORMAT FROM PSUSEROBJTYPE WHERE ........
COM Stmt=SELECT DISPLAYONLY FROM PSOPROBJ A ,PSOBJGROUP........
COM Stmt=SELECT TREE_NAME, SETID, SETCNTRLVALUE, EFFDT, TO_CHAR(EFFDT,'YYYY-MM-DD'), TREE_BRANCH, EFF_STATUS, DESCR, TREE_CATEGORY, TREE_STRCT_ID, VALID_TREE, NODE_FIELDNAME, DTL_FIELDNAME, NODE_RECNAME, DTL_RECNAME, LEVEL_RECNAME FROM PSTREEDEFACCVW ......................
But within TraceMagic -> All SQL Statements tab, these statements are not captured.
Any ideas why this would be the case ?
The SQL statements captured appears to be only tables with prefix PS_*.
In the tracesql file I see plenty of these statements :
COM Stmt=SELECT PTCUSTOMFORMAT FROM PSUSEROBJTYPE WHERE ........
COM Stmt=SELECT DISPLAYONLY FROM PSOPROBJ A ,PSOBJGROUP........
COM Stmt=SELECT TREE_NAME, SETID, SETCNTRLVALUE, EFFDT, TO_CHAR(EFFDT,'YYYY-MM-DD'), TREE_BRANCH, EFF_STATUS, DESCR, TREE_CATEGORY, TREE_STRCT_ID, VALID_TREE, NODE_FIELDNAME, DTL_FIELDNAME, NODE_RECNAME, DTL_RECNAME, LEVEL_RECNAME FROM PSTREEDEFACCVW ......................
But within TraceMagic -> All SQL Statements tab, these statements are not captured.
Any ideas why this would be the case ?
The SQL statements captured appears to be only tables with prefix PS_*.
0