Product Home
DTM DB Stress Online Documentation
General Information
Product Profile
Product Versions
Execution Modes
Task Properties
General Properties
Task Options
Parameters
Task Connection
Task Scripts
Execution Console
Execution Reports
Data Generator
Project Properties
Connect to Database
Statistics
Settings
Diagram
Advanced options
Dynamic Statements
Command Line
Performance Counters
Show Execution Plan
Additional Information
Installation
Uninstall
License
Demo and Full versions
Technical support
How to order
Upgrade
Database utilities

Built-in data generator

To make project rule more flexible the program contains simply data generator. It offers three predefined generators:

  1. Random integer. The user can specify value range.
  2. Random string. The user can specify length range and type of characters.
  3. Random date and/or time. The user can specify value format.
Moreover, the user can specify custom pattern for data generation. There are pattern items:

  • A - letter from 'A' to 'Z'.
  • a - letter from 'a' to 'z'.
  • N - digit from '0' to '9'.
  • X - hexadecimal digit from '0' to '9' and 'A' to 'F'.
  • {n} - repeater, value will be used from 1 to n times. n should be from 1 to 999.
  • {=n} - repeater, value will be used n times.
  • {n;m} - repeater, value will be used from n to m times. n should be less then m and both numbers from 1 to 999.
  • # - copy value of the last used block of elements signed by ( and ).
  • $<function>(<parameters>) - call built-in generator's function.
  • $$(<expression>) - calculate expression value.
Note: you can use '\' character for escape next mask sign. For example, \a will be used as a 'a' letter without any replacements.

Examples:

DescriptionPatternSample results
IP address$Rint(0,255).$Rint(0,255).$Rint(0,255).$Rint(0,255)41.107.214.235
187.239.95.95
190.212.237.81
From 3 to 5 days after today$$($Today(DD.MM.YYYY)+$RInt(3,5))14.12.2008
15.12.2008
14.12.2008
13.12.2008
One year afte some date$$($Date(12.10.2008,DD.MM.YYYY)+365)12.10.2009
e-mail[a{3;6}.]a{3;7}\@a{3;8}.tlsg.psf@dpo.com
xzbcoej@vpv.org
ygp.eylfpbn@ljvrvipy.net
Please contact out support staff to create more complex patterns and built-in functions usage.