<< About Correlating Database Statements | Using Correlated Query Functions >>

Decide which value to correlate

Database Vuser Scripts · Correlating Database Statements

Creating Vuser Scripts

Chapter 10, page 163

VuGen guides you through the steps of correlating queries. The main steps are:

Decide which value to correlate.

VuGen helps you decide what to correlate. You can double-click an error message
in the execution log to jump to the problematic statement in your script and search
for possible values to correlate. You can also select a specific value to correlate
directly from the script if you know where you can optimize your script or handle a
unique constraint error.

Save the results.

When VuGen scans your script for values to correlate, it provides a list of all
matching values from the results of previous queries. You save the value of a
query to a variable using the lrd_save_col function. You save the result of a
database procedure using the lrd_save_value function.

Reference the saved values.

VuGen replaces the constants in the query or database statement with the saved
variables.