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

By SQL statement fill method

This method is the most convenient one when you want to use the results obtained through using functions built into your DBMS. When the "use first result set's column as a list" option is switched off, independent of the obtained data set, the program will use only the first field of the first record in the results in the generation process. Please refer to fields group feature to use another columns of the result set.

There are settings for this fill method:

  • When "Use result set as a list" is switched on the program uses result set of the statement execution. Otherwise, the program will execute entered statement for each value and use only first value of the first results column.
  • "Use list items as a mask" means each list value will be processed as a mask before using.
  • "Use values sequentially" option means the program will use list items from the first to the last. When the list ends the program starts from the first item again.