Names

Names are used to identify random variables, named constants, users, transactions, functions, parameters, variables, Web forms, SQL commands, database cursors and the benchmark itself. There is no length limitation for names (except for names identifying users, cursors and SQL commands). Benchmark Description Language does not distinguish between upper-case and lower-case letters (for example, IndX INDX indx).

The table below lists all length restrictions for identifiers in BDL:

Identifier Maximum length
for SQL command 18 characters
for user group 15 characters
for database cursor 8 characters

Syntax

ident  = letter { letter | digit}

letter =  "abcdefghijklmnopqrstuvwxyz"
          "ABCDEFGHIJKLMNOPQRSTUVWXYZ_@".
digit  =  "0123456789".

Examples

The following names are valid:

  • abc123
  • a
  • _a
  • __1x
  • ABX1
  • _1
  • This_is_a_very_long_name

The following are invalid names:

  • 123
  • 1a

The following names for cursors and users are valid:

  • abc123
  • a
  • usr1
  • cursor1
  • c_1

The following are invalid names for cursors and users:

  • 1a
  • name_is_too_long
  • 12