Chat now with support
Chat with Support

Benchmark Factory for Database 8.4 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

$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.

 

 

 

Global Variable

$BFGetGlobalVar

 

Description:

Generates the Get Global Variable.

Parameters:

N/A

Syntax:

$BFGetGlobalVar('myvar') 

 

  

 

 

$BFSetGlobalVar

 

Description:

Generates the Set Global Variable

Parameters:

N/A

Syntax:

$BFSetGlobalVar('myvar', 'my value') 

 

  

 

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating