Product Home
DTM Data Generator Online Documentation
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Execution
Fill Table
Table Fill Modes
Table Fill Options
Row count management
Fill Methods
Method options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Field groups
Data Preview
Table Information
Advanced
Data Rule Properties
Project Properties
Tables Selection
Program Settings
File Structure
Values Library
Clear Rule
Project migration
Command Line
Performance Tips
Schema Viewer
Format Strings
Tables Creation Options
Select column
Objects Creation
Data export
How to...
Tools
Random BLOB Loader
Values Library Builder
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

Random fill method

There are settings for this fill method:

  • "From" is minimum value that will be generated for numeric (integer, float, etc) or date/time column.
  • "to" is maximum value that will be generated for numeric or date/time column.
  • "Length from" and "to" define length range for string values.
  • Format defines the view of value. This option is applicable for numeric values only.
  • "Decimal places" defines number of decimal digits after dot in the values. This option is applicable for numeric non-integer values only. For example, 2 for this option will produce values like 1.23, 55.70, 2.43, etc.

For the "char" and "varchar" columns the user can specify extra settings: special characters usage or Unicode blocks (for Enterprise version only).

Notes:

  • You can define year range for Date values using related settings.
  • Default decimal places option helps you to change default (zero) value for this fill method property.
  • You can define default length range for string columns using related options.
  • You can change or define your own date and time format as well as date/time separator at the Settings window. The program tries to analyze acceptable format automatically when the Rule Wizard works.
  • Custom Date Conversion function can be defined in the settings and will be applied to any date value before INSERT or UPDATE execution.