The ODBC protocol is used in client-server application to record only the database activities. The recorded script contains only about the events of the database .
To record the application using ODBC, we need to specify the application path in the “Program to record” dialog box and where to record the script as shown below:
Unlike web application, many events are recorded for each user action. Therefore the transactions are named between each user clicks and the response time are calculated for that.
Parameterization is done by right clicking the value to be parameterized and specifying a name for the parameter.
The data returned by the database query during the recording session is displayed in a grid. By viewing the grid once can determine how the application generates SQL statements. Correlation of dynamic data can be done by:
· Locate the value you want to correlate, and choose Vuser->Scan for correlation or right click on the value to correlate and select Scan for correlation (at cursor).
· VuGen. Scans the value and lists all results within the script that match this value. The correlation value are listed in the correlation query tab as shown below:
· In the correlation query tab, double click the result you want to correlate. VuGen. sends the cursor to the grid location of the value in the script.
· In the grid, select the value to correlate, and choose Vuser->Create Correlation or right click and choose Create Correlation.
· VuGen. Prompt to enter parameter name.· Specify a name or accept the default name. Click OK to continue. VuGen. Automatically insert the appropriate correlation statement (lrd_save_value or lrd_save_col).
· To replace the other occurrences, VuGen. Prompt for searching similar value. Click yes to search similar value or click No to replace only the selected value.
The validity of each transaction can be verified through data check similar to text check in Web. The value in any of the grid is captured and is verified to be not null as shown below:
