Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

PropertyDescription

Set how Alternate Key is generated. 0 - don't generate, 1 - unique index, 2 - unique constraint. DATATYPE: Integer.

Enable/Disable Storage option - BufferPool. DATATYPE: Boolean.

This is the Connection Name for generating DB objects. DATATYPE: String.

Create a new Database. DATATYPE: Boolean.

This is the path to the Database creation script file. DATATYPE: String.

Database Device Filename for new database. DATATYPE: String.

Database Login for new database. DATATYPE: String.

DATATYPE: String. Database name for new database.

Database Password for new database. DATATYPE: String.

Data Device Name for new database. DATATYPE: String.

Data Device Size for new database. DATATYPE: Integer.

This is the Data Source Name for generating DB objects. DATATYPE: String.

This is the Drop Object flag. DATATYPE: Boolean.

Flag to indicate if Foreign Key creation should be enforced. DATATYPE: Boolean.

Enable/Disable Storage option - ExtentGrowthFactor. DATATYPE: Boolean.

Enable/Disable Storage option - FillFactor. DATATYPE: Boolean.

Enable/Disable Storage option - FreeLists. DATATYPE: Boolean.

This is the generate Alias Comment flag. DATATYPE: Boolean.

This is the generate Alias Create Statement flag. DATATYPE: Boolean.

This is the generate Alias Drop Statement flag. DATATYPE: Boolean.

This is the generate All Owner Names flag. DATATYPE: Boolean.

This is the generate AuxTable Comment flag. DATATYPE: Boolean.

This is the generate AuxTable Create Statement flag. DATATYPE: Boolean.

This is the generate AuxTable Drop Statement flag. DATATYPE: Boolean.

This is the generate BufferPool Comment flag. DATATYPE: Boolean.

This is the generate Bufferpool Create Statement flag. DATATYPE: Boolean.

This is the generate BufferPool Drop Statement flag. DATATYPE: Boolean.

This is the generate Close Dataset flag. DATATYPE: Boolean.

This is the generate Column Constraint Name flag. DATATYPE: Boolean.

This is the generate Column Default Name flag. DATATYPE: Boolean.

This is the generate Commit Statement flag. DATATYPE: Boolean.

This is the generate DB2Database Comment flag. DATATYPE: Boolean.

This is the generate DB2Database Create Statement flag. DATATYPE: Boolean.

This is the generate DB2Database Drop Statement flag. DATATYPE: Boolean.

This is the generate Default Drop Statement flag. DATATYPE: Boolean.

This is the generate Default Table Stored Procedures flag. DATATYPE: Boolean.

This is the generate Aliases flag. DATATYPE: Boolean.

This is the generate AuxTables flag. DATATYPE: Boolean.

This is the generate Bufferpools flag. DATATYPE: Boolean.

This is the generate Column Comment flag. DATATYPE: Boolean.

This is the generate Column Constraint flag. DATATYPE: Boolean.

This is the generate Column Default flag. DATATYPE: Boolean.

This is the generate Column Label flag. DATATYPE: Boolean.

Set the method of creating the Database. 1 - single file, 2 - ODBC, 3 - Direct Connection, 4 - multiple files. DATATYPE: Integer.

This is the generate DB2Databases flag. DATATYPE: Boolean.

Enable/Disable generation of Defaults. DATATYPE: Boolean.

Flag to indicate if Foreign Key Constraints should be generated. DATATYPE: Boolean.

This is the generate Indexes flag. DATATYPE: Boolean.

Flag to indicate if Logical Foreign Keys should be generated. DATATYPE: Boolean.

This is the generate Logical PK flag. DATATYPE: Boolean.

This is the generate MaterializedQueryTables flag. DATATYPE: Boolean.

This is the generate MaterializedViews flag. DATATYPE: Boolean.

This is the generate Nodegroups flag. DATATYPE: Boolean.

Flag to indicate if defined NonUnique Indexes should be generated. DATATYPE: Boolean.

This is the generate PK by Alter statement flag. DATATYPE: Boolean.

This is the generate PK by Alter statement and unique index flag. DATATYPE: Boolean.

This is the generate RollbackSegments flag. DATATYPE: Boolean.

Enable/Disable generation of Rules. DATATYPE: Boolean.

This is the generate Sequences flag. DATATYPE: Boolean.

This is the generate StoGroups flag. DATATYPE: Boolean.

This is the generate Synonyms flag. DATATYPE: Boolean.

This is the generate System Triggers flag. DATATYPE: Boolean.

Enable/Disable generation of Table CheckConstraints. DATATYPE: Boolean.

This is the generate Table Comment flag. DATATYPE: Boolean.

This is the generate PK by Alter statement flag. DATATYPE: Boolean.

This is the generate Table PostSQL statement flag. DATATYPE: Boolean.

This is the generate Table Pre SQL statement flag. DATATYPE: Boolean.

This is the generate Tablespaces flag. DATATYPE: Boolean.

Enable/Disable generation of UserDatatypes. DATATYPE: Boolean.

Enable/Disable generation of Views. DATATYPE: Boolean.

This is the generate FK Drop Statement flag. DATATYPE: Boolean.

This is the generate Force Backticks flag. DATATYPE: Boolean.

This is the generate Force Brackets flag. DATATYPE: Boolean.

This is the generate Force Quotes flag. DATATYPE: Boolean.

This is the generate Function Comment flag. DATATYPE: Boolean.

This is the generate Function Create Statement flag. DATATYPE: Boolean.

This is the generate Function Drop Statement flag. DATATYPE: Boolean.

This is the generate Include Object Header flag. DATATYPE: Boolean.

This is the generate Drop statement flag for indexes. DATATYPE: Boolean.

This is the generate BufferPool property of Index Storage. DATATYPE: Boolean.

This is the generate ExtentGrowthFactor property of Index Storage. DATATYPE: Boolean.

This is the generate FillFactor property of Index Storage. DATATYPE: Boolean.

This is the generate FreeList property of Index Storage. DATATYPE: Boolean.

This is the generate FreeListGroups property of Index Storage. DATATYPE: Boolean.

This is the generate Include property of Index Storage. DATATYPE: Boolean.

This is the generate InitialExtentSize property of Index Storage. DATATYPE: Boolean.

This is the generate Location property of Index Storage. DATATYPE: Boolean.

This is the generate LockMode property of Index Storage. DATATYPE: Boolean.

This is the generate Logging property of Index Storage. DATATYPE: Boolean.

This is the generate MaxExtents property of Index Storage. DATATYPE: Boolean.

This is the generate MaxRowsPerPage property of Index Storage. DATATYPE: Boolean.

This is the generate MaxTransactions property of Index Storage. DATATYPE: Boolean.

This is the generate MinExtents property of Index Storage. DATATYPE: Boolean.

This is the generate MinTransactions property of Index Storage. DATATYPE: Boolean.

This is the generate NextExtentSize property of Index Storage. DATATYPE: Boolean.

This is the generate PadIndex property of Index Storage. DATATYPE: Boolean.

This is the generate Parallel property of Index Storage. DATATYPE: Boolean.

This is the generate PctFree property of Index Storage. DATATYPE: Boolean.

This is the generate PctUsed property of Index Storage. DATATYPE: Boolean.

This is the generate ReverseScans property of Index Storage. DATATYPE: Boolean.

This is the generate SortTempDB property of Index Storage. DATATYPE: Boolean.

This is the generate Keyword Backticks flag. DATATYPE: Boolean.

This is the generate Keyword Brackets flag. DATATYPE: Boolean.

This is the generate Keyword Quotes flag. DATATYPE: Boolean.

This is the generate LOB Segments flag. DATATYPE: Boolean.

This is the generate MaterializedQueryTable Comment flag. DATATYPE: Boolean.

This is the generate MaterializedQueryTable Create Statement flag. DATATYPE: Boolean.

This is the generate MaterializedQueryTable Drop Statement flag. DATATYPE: Boolean.

This is the Generate Materialized View Post SQL flag. DATATYPE: Boolean.

This is the generate MaterializedView Comment flag. DATATYPE: Boolean.

This is the generate MaterializedView Create Statement flag. DATATYPE: Boolean.

This is the generate MaterializedView Drop Statement flag. DATATYPE: Boolean.

This is the generate Model PostSQL flag. DATATYPE: Boolean.

This is the generate Model PreSQL flag. DATATYPE: Boolean.

This is the generate NodeGroup Comment flag. DATATYPE: Boolean.

This is the generate NodeGroup Create Statement flag. DATATYPE: Boolean.

This is the generate NodeGroup Drop Statement flag. DATATYPE: Boolean.

This is the generate ObjectType Comment flag. DATATYPE: Boolean.

This is the generate ObjectType Create Statement flag. DATATYPE: Boolean.

This is the generate ObjectType Drop Statement flag. DATATYPE: Boolean.

This is the generate Package Comment flag. DATATYPE: Boolean.

This is the generate Package Create Statement flag. DATATYPE: Boolean.

This is the generate Package Drop Statement flag. DATATYPE: Boolean.

This is the generate Procedure Create Statement flag. DATATYPE: Boolean.

This is the generate Procedure Drop Statement flag. DATATYPE: Boolean.

This is the generate Procedure Comment flag. DATATYPE: Boolean.

This is the generate RollBackSegment Comment flag. DATATYPE: Boolean.

This is the generate RollBackSegment Create Statement flag. DATATYPE: Boolean.

This is the generate RollBackSegment Drop Statement flag. DATATYPE: Boolean.

This is the generate Rule Drop Statement flag. DATATYPE: Boolean.

This is the generate Sequence Comment flag. DATATYPE: Boolean.

This is the generate Sequence Create Statement flag. DATATYPE: Boolean.

This is the generate Sequence Drop Statement flag. DATATYPE: Boolean.

This is the Generate Sequence Post SQL flag. DATATYPE: Boolean.

This is the Generate Sequence Pre SQL flag. DATATYPE: Boolean.

This is the generate StoGroup Comment flag. DATATYPE: Boolean.

This is the generate StoGroup Create Statement flag. DATATYPE: Boolean.

This is the generate StoGroup Drop Statement flag. DATATYPE: Boolean.

This is the generate Synonym Comment flag. DATATYPE: Boolean.

This is the generate Synonym Create Statement flag. DATATYPE: Boolean.

This is the generate Synonym Drop Statement flag. DATATYPE: Boolean.

This is the generate Table Constraint Name flag. DATATYPE: Boolean.

This is the generate Tablespace Comment flag. DATATYPE: Boolean.

This is the generate Tablespace Create Statement flag. DATATYPE: Boolean.

This is the generate Tablespace Drop Statement flag. DATATYPE: Boolean.

This is the generate AuditOptions property of Table Storage. DATATYPE: Boolean.

This is the generate CacheStrategy property of Table Storage. DATATYPE: Boolean.

This is the generate DataBlockSize property of Table Storage. DATATYPE: Boolean.

This is the generate Encoding property of Table Storage. DATATYPE: Boolean.

This is the generate Fallback property of Table Storage. DATATYPE: Boolean.

This is the generate IdentityGap property of Table Storage. DATATYPE: Boolean.

This is the generate IndexTablespace property of Table Storage. DATATYPE: Boolean.

This is the generate Journaling property of Table Storage. DATATYPE: Boolean.

This is the generate LogDataChanges property of Table Storage. DATATYPE: Boolean.

This is the generate Logging property of Table Storage. DATATYPE: Boolean.

This is the generate LongTablespace property of Table Storage. DATATYPE: Boolean.

This is the generate NotLoggedInitially property of Table Storage. DATATYPE: Boolean.

This is the generate Organization property of Table Storage. DATATYPE: Boolean.

This is the generate Parallel property of Table Storage. DATATYPE: Boolean.

This is the generate ReservePageGap property of Table Storage. DATATYPE: Boolean.

This is the generate RestrictOnDrop property of Table Storage. DATATYPE: Boolean.

This is the generate Trigger Create Statement flag. DATATYPE: Boolean.

This is the generate Trigger Drop Statementt flag. DATATYPE: Boolean.

This is the generate UserDatatype Drop Statement flag. DATATYPE: Boolean.

This is the generate Verify Statement flag. DATATYPE: Boolean.

This is the generate View Create Statement flag. DATATYPE: Boolean.

This is the generate View Drop Statement flag. DATATYPE: Boolean.

This is the generate View PostSQL flag. DATATYPE: Boolean.

This is the generate View PreSQL flag. DATATYPE: Boolean.

Enable/Disable Storage option - IndexPartitions. DATATYPE: Boolean.

Enable/Disable Storage option - InitialExtentSize. DATATYPE: Boolean.

Enable/Disable Storage option - Location. DATATYPE: Boolean.

Enable/Disable Storage option - LockMode. DATATYPE: Boolean.

Log Device Filename for new database. DATATYPE: String.

Log Device Name for new database. DATATYPE: String.

Log Device Size for new database. DATATYPE: Integer.

Enable/Disable Storage option - MaximumExtents. DATATYPE: Boolean.

Enable/Disable Storage option - MaximumTransactions. DATATYPE: Boolean.

Enable/Disable Storage option - MaxRowsPerPage. DATATYPE: Boolean.

Enable/Disable Storage option - MinimumExtents. DATATYPE: Boolean.

Enable/Disable Storage option - MinimumTransactions. DATATYPE: Boolean.

Enable/Disable Storage option - NextExtentSize. DATATYPE: Boolean.

Enable/Disable Storage option - PercentFree. DATATYPE: Boolean.

Enable/Disable Storage option - PercentUsed. DATATYPE: Boolean.

Set how Primary Key is generated. 0 - don't generate, 1 - unique index, 2 - PK constraint. DATATYPE: Integer.

Use an existing Database. DATATYPE: Boolean.

If AK Constraint type is 2, this indicates if constraint names are supplied. DATATYPE: Boolean.

If PK Constraint type is 2, this indicates if constraint names are supplied. DATATYPE: Boolean.

Enable/Disable Storage option - TablePartitions. DATATYPE: Boolean.

This is the User Name for generating DB objects. DATATYPE: String.

This is the User Password for generating DB objects. DATATYPE: String.
Info
titleSee Also