Product Home
DTM DB Stress Online Documentation Prev Page Prev Page
General Information
Product Profile
Product Versions
Execution Modes
Task Properties
General Properties
Task Options
Parameters
Task Connection
Task Scripts
Group of tasks
Execution Console
Execution Reports
Data Generator
Project Properties
Connect to Database
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Statistics
Settings
Diagram
Log Viewer
Hot Keys
Advanced Options
Dynamic Statements
Command Line
Performance Counters
Show Execution Plan
SQL Library
Report Comparison
Version Controls
SQL console
Report Visualizer
Additional Information
Installation
Uninstall
License
Demo and Full versions
Technical support
How to order
Upgrade
Trademark Information
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:

Description Pattern Sample 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 after 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 our support staff if you have difficulties during complex patterns creation or built-in functions usage.