Benchmark Factory for Database 9.0 - User Guide

Returns a random string determined by a mode and having a length n.

Length n-The length of a string.

Mode constant-One of the following:

ALPHA-Returns only random letters.

ALPHA_LOWER-Returns random lowercase letters.

ALPHA_NUM-Returns random letters and numbers.

ALPHA_UPPER-Returns random uppercase letters.

ANY-Returns any random ASCII characters.

NUM-Returns only numbers.

RANGE-Returns ASCII characters in the range specified.

$BFRandStr(n,[constant],[1..255],[1..255])

$BFRandStr(10) ; Returns 10 random characters.

$BFRandStr(1,RANGE,65,67) ; Returns either A, B, or C.

Randomly select unique items from a list.

string1-The first string to return from a list.

string2-The second string to return from a list.

stringN-The last string to return from a list.

$BFURandList(string1,string2,… stringN)

$BFURandList("Red", "White", "Blue", "Yellow") ; returns Blue the first time this function executes then Yellow, Red, White, and Blue for subsequent executions of this function. Notice that Blue did not repeat until all other colors returned.

Returns an item from a list. The item returned depends on the mode selected.

Retrieval Mode:

Random: Select a random item from the list.

SEQUENTIAL: Select each item sequentially.

UNIQUE: Select a non-repeating item from the list.

string1-The first string to return from a list.

string2-The second string to return from a list.

stringN-The last string to return from a list.

$BFList(Retrieval Mode, string1,string2,… stringN)

$BFList (Sequential "1", "2", "3", "4")

Returns  1

             2

            etc.

$BFList (Random 1, 2, 3, 4)

Returns 2

            3

            3

            1

            2

            4

            etc.

$BFList (Unique, "1", "2", "3","4")

Returns 2

            4

            3

            1

            2

            etc.