Versions Compared

Key

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

...

PropertyDescription
AlternateKeyConstraintTypeSet how Alternate Key is generated. Options include: 0 = Don't generate, 1 = Unique index, 2 = Unique constraint. DATATYPE: Integer.
BufferPoolEnable/Disable Storage option - BufferPool. DATATYPE: Boolean.
ConnectionNameConnection Name for generating DB objects. DATATYPE: String.
CreateNewDatabaseCreate a new Database. DATATYPE: Boolean.
CreationScriptFilePathPath to the Database creation script file. DATATYPE: String.
DatabaseDeviceFilenameDatabase Device Filename for new database. DATATYPE: String.
DatabaseLoginDatabase Login for new database. DATATYPE: String.
DatabaseNameDatabase name for new database. DATATYPE: String.
DatabasePasswordDatabase Password for new database. DATATYPE: String.
DataDeviceNameData Device Name for new database. DATATYPE: String.
DataDeviceSizeData Device Size for new database. DATATYPE: Integer.
DataSourceNameData Source Name for generating DB objects. DATATYPE: String.
DropObjectsDrop Object flag. DATATYPE: Boolean.
EnforceFKCreationFlag that indicates whether to enforce Foreign Key creation. DATATYPE: Boolean.
ExtentGrowthFactorEnable/Disable Storage option - ExtentGrowthFactor. DATATYPE: Boolean.
FillfactorEnable/Disable Storage option - FillFactor. DATATYPE: Boolean.
FreeListGroups

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

FreeLists

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

GenAliasCommentGenerate Alias Comment flag. DATATYPE: Boolean.
GenAliasCreateStatementGenerate Alias Create Statement flag. DATATYPE: Boolean.
GenAliasDropStatementGenerate Alias Drop Statement flag. DATATYPE: Boolean.
GenAllOwnerNamesGenerate All Owner Names flag. DATATYPE: Boolean.
GenAuxTableCommentGenerate AuxTable Comment flag. DATATYPE: Boolean.
GenAuxTableCreateStatementGenerate AuxTable Create Statement flag. DATATYPE: Boolean.
GenAuxTableDropStatementGenerate AuxTable Drop Statement flag. DATATYPE: Boolean.
GenBufferPoolCommentGenerate BufferPool Comment flag. DATATYPE: Boolean.
GenBufferpoolCreateStatementGenerate Bufferpool Create Statement flag. DATATYPE: Boolean.
GenBufferPoolDropStatementGenerate BufferPool Drop Statement flag. DATATYPE: Boolean.
GenCloseDatasetGenerate Close Dataset flag. DATATYPE: Boolean.
GenColConstraintNameGenerate Column Constraint Name flag. DATATYPE: Boolean.
GenColDefaultNameGenerate Column Default Name flag. DATATYPE: Boolean.
GenCommitStatementGenerate Commit Statement flag. DATATYPE: Boolean.
GenDB2DatabaseCommentGenerate DB2Database Comment flag. DATATYPE: Boolean.
GenDB2DatabaseCreateStatementGenerate DB2Database Create Statement flag. DATATYPE: Boolean.
GenDB2DatabaseDropStatementGenerate DB2Database Drop Statement flag. DATATYPE: Boolean.
GenDefaultDropStatementGenerate Default Drop Statement flag. DATATYPE: Boolean.
GenDefaultTableStoredProceduresGenerate Default Table Stored Procedures flag. DATATYPE: Boolean.

Generate Aliases flag. DATATYPE: Boolean.

Generate AuxTables flag. DATATYPE: Boolean.

Generate Bufferpools flag. DATATYPE: Boolean.

Generate Column Comment flag. DATATYPE: Boolean.

Generate Column Constraint flag. DATATYPE: Boolean.

Generate Column Default flag. DATATYPE: Boolean.

Generate Column Label flag. DATATYPE: Boolean.

Set the method of creating the Database. GenType: 1 = Single file, 2 = ODBC, 3 = Direct Connection, 4 = Multiple files. DATATYPE: Integer.

Generate DB2Databases flag. DATATYPE: Boolean.

Enable/Disable generation of Defaults. DATATYPE: Boolean.

Flag that indicates whether Foreign Key Constraints are generated. DATATYPE: Boolean.

Generate Indexes flag. DATATYPE: Boolean.

Flag that indicates whether Logical Foreign Keys are generated. DATATYPE: Boolean.

Generate Logical PK flag. DATATYPE: Boolean.

Generate MaterializedQueryTables flag. DATATYPE: Boolean.

Generate MaterializedViews flag. DATATYPE: Boolean.

Generate Nodegroups flag. DATATYPE: Boolean.

Flag that indicates whether defined NonUnique Indexes are generated. DATATYPE: Boolean.

Generate PK by Alter statement flag. DATATYPE: Boolean.

Generate PK by Alter statement and unique index flag. DATATYPE: Boolean.

Generate RollbackSegments flag. DATATYPE: Boolean.

Enable/Disable generation of Rules. DATATYPE: Boolean.

Generate Sequences flag. DATATYPE: Boolean.

Generate StoGroups flag. DATATYPE: Boolean.

Generate Synonyms flag. DATATYPE: Boolean.

Generate System Triggers flag. DATATYPE: Boolean.

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

Generate Table Comment flag. DATATYPE: Boolean.

Generate PK by Alter statement flag. DATATYPE: Boolean.

Generate Table PostSQL statement flag. DATATYPE: Boolean.

Generate Table Pre SQL statement flag. DATATYPE: Boolean.

Generate Tablespaces flag. DATATYPE: Boolean.

Enable/Disable generation of UserDatatypes. DATATYPE: Boolean.

Enable/Disable generation of Views. DATATYPE: Boolean.

Generate FK Drop Statement flag. DATATYPE: Boolean.

Generate Force Backticks flag. DATATYPE: Boolean.

Generate Force Brackets flag. DATATYPE: Boolean.

Generate Force Quotes flag. DATATYPE: Boolean.

Generate Function Comment flag. DATATYPE: Boolean.

Generate Function Create Statement flag. DATATYPE: Boolean.

Generate Function Drop Statement flag. DATATYPE: Boolean.

Generate Include Object Header flag. DATATYPE: Boolean.

Generate Drop statement flag for indexes. DATATYPE: Boolean.

Generate BufferPool property of Index Storage. DATATYPE: Boolean.

Generate ExtentGrowthFactor property of Index Storage. DATATYPE: Boolean.

Generate FillFactor property of Index Storage. DATATYPE: Boolean.

Generate FreeList property of Index Storage. DATATYPE: Boolean.

Generate FreeListGroups property of Index Storage. DATATYPE: Boolean.

Generate Include property of Index Storage. DATATYPE: Boolean.

Generate InitialExtentSize property of Index Storage. DATATYPE: Boolean.

Generate Location property of Index Storage. DATATYPE: Boolean.

Generate LockMode property of Index Storage. DATATYPE: Boolean.

Generate Logging property of Index Storage. DATATYPE: Boolean.

Generate MaxExtents property of Index Storage. DATATYPE: Boolean.

Generate MaxRowsPerPage property of Index Storage. DATATYPE: Boolean.

Generate MaxTransactions property of Index Storage. DATATYPE: Boolean.

Generate MinExtents property of Index Storage. DATATYPE: Boolean.

Generate MinTransactions property of Index Storage. DATATYPE: Boolean.

Generate NextExtentSize property of Index Storage. DATATYPE: Boolean.

Generate PadIndex property of Index Storage. DATATYPE: Boolean.

Generate Parallel property of Index Storage. DATATYPE: Boolean.

Generate PctFree property of Index Storage. DATATYPE: Boolean.

Generate PctUsed property of Index Storage. DATATYPE: Boolean.

Generate ReverseScans property of Index Storage. DATATYPE: Boolean.

Generate SortTempDB property of Index Storage. DATATYPE: Boolean.

Generate Keyword Backticks flag. DATATYPE: Boolean.

Generate Keyword Brackets flag. DATATYPE: Boolean.

Generate Keyword Quotes flag. DATATYPE: Boolean.

Generate LOB Segments flag. DATATYPE: Boolean.

Generate MaterializedQueryTable Comment flag. DATATYPE: Boolean.

Generate MaterializedQueryTable Create Statement flag. DATATYPE: Boolean.

Generate MaterializedQueryTable Drop Statement flag. DATATYPE: Boolean.

Generate Materialized View Post SQL flag. DATATYPE: Boolean.

Generate MaterializedView Comment flag. DATATYPE: Boolean.

Generate MaterializedView Create Statement flag. DATATYPE: Boolean.

Generate MaterializedView Drop Statement flag. DATATYPE: Boolean.

Generate Model PostSQL flag. DATATYPE: Boolean.

Generate Model PreSQL flag. DATATYPE: Boolean.

Generate NodeGroup Comment flag. DATATYPE: Boolean.

Generate NodeGroup Create Statement flag. DATATYPE: Boolean.

Generate NodeGroup Drop Statement flag. DATATYPE: Boolean.

Generate ObjectType Comment flag. DATATYPE: Boolean.

Generate ObjectType Create Statement flag. DATATYPE: Boolean.

Generate ObjectType Drop Statement flag. DATATYPE: Boolean.

Generate Package Comment flag. DATATYPE: Boolean.

Generate Package Create Statement flag. DATATYPE: Boolean.

Generate Package Drop Statement flag. DATATYPE: Boolean.

Generate Procedure Create Statement flag. DATATYPE: Boolean.

Generate Procedure Drop Statement flag. DATATYPE: Boolean.

Generate Procedure Comment flag. DATATYPE: Boolean.

Generate RollBackSegment Comment flag. DATATYPE: Boolean.

Generate RollBackSegment Create Statement flag. DATATYPE: Boolean.

Generate RollBackSegment Drop Statement flag. DATATYPE: Boolean.

Generate Rule Drop Statement flag. DATATYPE: Boolean.

Generate Sequence Comment flag. DATATYPE: Boolean.

Generate Sequence Create Statement flag. DATATYPE: Boolean.

Generate Sequence Drop Statement flag. DATATYPE: Boolean.

Generate Sequence Post SQL flag. DATATYPE: Boolean.

Generate Sequence Pre SQL flag. DATATYPE: Boolean.

Generate StoGroup Comment flag. DATATYPE: Boolean.

Generate StoGroup Create Statement flag. DATATYPE: Boolean.

Generate StoGroup Drop Statement flag. DATATYPE: Boolean.

Generate Synonym Comment flag. DATATYPE: Boolean.

Generate Synonym Create Statement flag. DATATYPE: Boolean.

Generate Synonym Drop Statement flag. DATATYPE: Boolean.

Generate Table Constraint Name flag. DATATYPE: Boolean.

Generate Tablespace Comment flag. DATATYPE: Boolean.

Generate Tablespace Create Statement flag. DATATYPE: Boolean.

Generate Tablespace Drop Statement flag. DATATYPE: Boolean.

Generate AuditOptions property of Table Storage. DATATYPE: Boolean.

Generate CacheStrategy property of Table Storage. DATATYPE: Boolean.

Generate DataBlockSize property of Table Storage. DATATYPE: Boolean.

Generate Encoding property of Table Storage. DATATYPE: Boolean.

Generate Fallback property of Table Storage. DATATYPE: Boolean.

Generate IdentityGap property of Table Storage. DATATYPE: Boolean.

Generate IndexTablespace property of Table Storage. DATATYPE: Boolean.

Generate Journaling property of Table Storage. DATATYPE: Boolean.

Generate LogDataChanges property of Table Storage. DATATYPE: Boolean.

Generate Logging property of Table Storage. DATATYPE: Boolean.

Generate LongTablespace property of Table Storage. DATATYPE: Boolean.

Generate NotLoggedInitially property of Table Storage. DATATYPE: Boolean.

Generate Organization property of Table Storage. DATATYPE: Boolean.

Generate Parallel property of Table Storage. DATATYPE: Boolean.

Generate ReservePageGap property of Table Storage. DATATYPE: Boolean.

Generate RestrictOnDrop property of Table Storage. DATATYPE: Boolean.

Generate Trigger Create Statement flag. DATATYPE: Boolean.

Generate Trigger Drop Statementt flag. DATATYPE: Boolean.

Generate UserDatatype Drop Statement flag. DATATYPE: Boolean.

Generate Verify Statement flag. DATATYPE: Boolean.

Generate View Create Statement flag. DATATYPE: Boolean.

Generate View Drop Statement flag. DATATYPE: Boolean.

Generate View PostSQL flag. DATATYPE: Boolean.

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. GenType: 0 = Don't generate, 1 = Unique index, 2 = PK constraint. DATATYPE: Integer.

Use an existing Database. DATATYPE: Boolean.

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

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

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

User Name for generating DB objects. DATATYPE: String.

User Password for generating DB objects. DATATYPE: String.

...