You can use USoft BenchMark to
play a test that reads data from an external file. The contents of
this file are described by an external set that is defined with
To insert records that are
defined in an external file into an application table within a test
||First, record a test procedure that inserts a record with dummy
values into the application table.
||Save the recorded procedure.
||Define a test that executes this procedure.
||In USoft Batch, define an external set that describes the data
to be inserted. This external set must have File Format:
The names of the external set
elements must correspond with the names of the columns in which
values are inserted.
You can ease this process and
also define a Batch export task that exports existing records from
the application table into an external file. This file can then be
used as template.
For more details, see the
USoft Batch Help topic: "How to Define External Sets and their
||In BenchMark, open the Tests window, select the test defined in
step 3, and click the Edit Procedure button.
||In the Procedures Executed by this Test window, set Iterations
to the number of records in the external file.
||In the Set Name field, specify the name of the external
||In the File Name field, specify the name of the external
||Play the test procedure.
The recorded insert is
executed for all records defined in the external file. If a value
is inserted in a column that occurs in the external set, the value
is taken from the external file.
If a value is inserted in a
column that does not occur in the external set, the recorded value
in the test procedure is inserted.
The same mechanism applies
when updating records and when entering query conditions.