Manual Correlation

Manual correlation is only recommended for applications with which you have advanced knowledge. To perform manual correlation, right-click a replay parameter in the SQL Command view and choose Find Correlation.

Manual correlation is available in In Body view (input parameters), Out Body view (result sets), and SQL Command view. When used in In Body view, TrueLog Explorer searches for correlating values (in Out Body view) that precede the SQL command. When used in Out Body view, TrueLog Explorer searches for correlating values (in In Body view) that follow the SQL command. When used in SQL Command view, TrueLog Explorer searches for correlating values (in Out Body view) that precede the SQL command, in case parameters are hard-coded in SQL commands.

For example:

INSERT INTO MY_PERSON (P_NO, P_FIRSTNAME, P_LASTNAME)
VALUES ( 2289, "Michael", "Smith" )