Chat now with support
Chat with Support

Benchmark Factory for Database 8.2.1 - User Guide

Getting Started Licensing Overview of Benchmark Factory Benchmark Factory Components Agents Create and Edit Connections Create and Edit Tests and Jobs Test Results and Run Reports Troubleshooting The Benchmark Factory REST API

BFFileArray

Description:

 

Selects an item from a list. Returns a single item from a comma-delimited file. The item returned depends on the mode selected. The syntax of the statement is also slightly different for each mode. Each virtual user gets a different seed value to generate unique sequences. Each agent machine must have a file with the name and path that is specified in the script function. If $BFFileArray is to return strings, the items in the file must be in double-quotes

Parameters:

 

File name-The name and path of the source file.

Retrieval Mode:

CURRENT:Select the item in the specified column of the current row.

RANDOM:Select a random item from a given column.

SELECTION:Select an item based on column and row.

SEQUENTIAL:Select each item sequentially.

UNIQUE:Select a non-repeating item from a given column.

nColumn-Which column of values to select. If none is given, a value of 1 is assumed.

nRow-Which row to select for the item.

Note: This value is only needed for the SELECTION mode.

 

Syntax:

 

$BFFileArray(FileName, Retrieval Mode[,nColumn][, nRow])

 

Example:

 

If myfile.dat consists of:

"George Washington", "Martha"

"Franklin Roosevelt","Eleanor"

"Gerald Ford","Betty"

$BFFileArray( "c:\path\myfile.dat", SELECTION, 2, 3)

Returns Betty.

$BFFileArray( "c:\path\myfile.dat", RANDOM,2)

Returns either Martha, Eleanor, or Betty. Will return Martha, Eleanor, or Betty the next time it is run.

$BFFileArray( "c:\path\myfile.dat", UNIQUE,2)

Returns either Martha, Eleanor, or Betty.  Will return Martha or Betty the next time it is run if it returned Eleanor the first time.

$BFFileArray( "c:\path\myfile.dat", SEQUENTIAL, 1)

Returns George Washington then Franklin Roosevelt then Gerald Ford.

$BFFileArray( "c:\path\myfile.dat", CURRENT, 2)

Returns Betty if the previous script function returned Gerald Ford.

 

 

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating