Chapter 10 Generating a Database from a PDM

Test Data Generation General tab

The General tab allows you to set general generation options.


The following options are available on this tab:

Option Result of selection
Directory Specifies the directory in which the file will be saved.
File name Specifies the name of the file.

Select the One file only checkbox to specify that only a single file can be generated.
Generation type Specifies how the test data will be generated. The following settings are available:

  • Script generation - in DBMS-specific syntax
  • ODBC generation - in ODBC syntax
  • Data file – as a set of values in a file
Delete old data Deletes all existing test data.
Commit Specifies when the data will be committed. The following settings are available:

  • Auto - automatically during script generation
  • At end - at end of script generation
  • By packet - at defined intervals during script generation
Format For use with the data file option. The following settings are available:

  • CSV – comma-separated values
  • Custom delimiter – specify a custom delimiter
Default number of rows Specifies the default number of rows for table
Default number profile Specifies the default number profile for table
Default character profile Specifies the default character profile for table
Default date profile Specifies the default date profile for table
Check model Checks the PDM before generating the test database or script, and stops generation if an error is found.
Automatic archive Creates an archive of any previous test data.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.