Benchmark Factory for Database 9.0 - User Guide

Returns the current number of iterations of a test.

N/A

$BFNumberOfIterations()

$BFNumberOfIterations() ; returns "1"

Returns driver specific information, such as database name.

Profile (constant)-The following provides a list of database type constants:

MSSQL (native), SAP:

• SERVERNAME
• DATABASE
• USERNAME

ORACLE:

• NETSERVICENAME
• USERNAME

ODBC, MYSQL (ODBC), MSSQL (ODBC):

• DATASOURCENAME
• USERNAME

DB2:

• DATABASEALIAS
• USERNAME

$BFProfile(constant)

$BFProfile(USERNAME) ; returns 'sa'

Returns the run ID of the current test.

N/A

$BFRunID()

$BFRunID() ; returns  "186"

Stores a value for later use by $BFGetVar.  Used to store a value to be reused within its own transaction, or any transaction in a given user scenario.  Each virtual user gets its own variable space, so values are not shared between them.  Typically, $BFSetVar is placed at the beginning of a dynamic statement, as scripts are evaluated from left to right.  

Variable Name (VarName)-An alphanumeric identifier of the value stored.

Text to Store (Value)-A string.  The value to be stored for later retrieval.

Syntax:$BFSetVar("VarName", "Value")

$BFSetVar("Totalrow", "2") ; $BFSetVar sets the variable "Totalrow" to 2