Versions Compared

Key

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

Public Methods

MethodsDescription
EnhGenerateFKConstraintsGenerate FK Constraints. GenType: 0 = Don't generate, 1 = Generate by Create Table, 2 = Generate by Alter Table. PARAMETERS: GenType (Integer), DependencyOrder (Boolean).
GenDDLUsingFileBasedQuickLaunchGenerate DDL using the Quick Launch setting identified by the given filename. PARAMETERS: FileName (Strings).
GenDDLUsingQuickLaunchGenerate DDL using the Quick Launch setting identified by the given name. PARAMETERS: Name (Strings).
GenerateAllEntitiesSet a flag to generate all Entities.
GenerateAllStoredProceduresSet a flag to generate all Stored Procedures.
GenerateAllTriggersSet a flag to generate all Triggers.
GenerateDDLGenerate the DDL. Return TRUE for success or FALSE for failure. RETURN DATATYPE: Boolean.
GenerateFKConstraintNamesGenerate FK Constraint Names when GenerateNames is TRUE. If SupplyNames is TRUE, then unnamed FK are given unique names. PARAMETERS: GenerateNames (Boolean), SupplyNames (Boolean).
GenerateNoEntitiesSet a flag to not generate any Entities.
GenerateNoStoredProceduresSet a flag to not generate any Stored Procedures.
GenerateNoTriggersSet a flag to not generate any Triggers.
GenerateSelectedEntitiesSet a flag to generate selected Entities, according to Entity names given in the parameter array. PARAMETERS: EntityNames (VariantArray of Strings).
GenerateSelectedStoredProceduresSet a flag to generate selected Stored Procedures, according to Procedure names given in the parameter array. PARAMETERS: StoredProcedureNames (VariantArray of Strings).
GenerateSelectedTriggersSet a flag to generate selected Triggers, according to Trigger names given in the parameter array. PARAMETERS: TriggerNames (VariantArray of Strings).
GetQuickLaunchListReturn all the names of available Quick Launch settings for the Model. RETURN DATATYPE: StringObjects.

Public Properties

PropertyDescription
AlternateKeyConstraintTypeSet how Alternate Key is generated. 0 - donOptions include: 0 = Don't generate, 1 - unique = Unique index, 2 - unique = Unique constraint. DATATYPE: Integer.
BufferPoolEnable/Disable Storage option - BufferPool. DATATYPE: Boolean.
ConnectionNameThis is the Connection Name for generating DB objects. DATATYPE: String.
CreateNewDatabaseCreate a new Database. DATATYPE: Boolean.
CreationScriptFilePathPath This is the path to the Database creation script file. DATATYPE: String.
DatabaseDeviceFilenameDatabase Device Filename for new database. DATATYPE: String.
DatabaseLoginDatabase Login for new database. DATATYPE: String.
DatabaseNameDATATYPE: String. Database 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.
DataSourceNameThis is the Data Source Name for generating DB objects. DATATYPE: String.
DropObjectsThis is the Drop Object flag. DATATYPE: Boolean.
EnforceFKCreationFlag that indicates whether to indicate if enforce Foreign Key creation should be enforced. 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 This is the generate Alias Comment flag. DATATYPE: Boolean.This
GenAliasCreateStatementGenerate is the generate Alias Create Statement flag. DATATYPE: Boolean.
GenAliasDropStatementGenerate This is the generate Alias Drop Statement flag. DATATYPE: Boolean.
GenAllOwnerNamesGenerate This is the generate All Owner Names flag. DATATYPE: Boolean.
GenAuxTableCommentGenerate This is the generate AuxTable Comment flag. DATATYPE: Boolean.This is
GenAuxTableCreateStatementGenerate the generate AuxTable Create Statement flag. DATATYPE: Boolean.
GenAuxTableDropStatementGenerate This is the generate AuxTable Drop Statement flag. DATATYPE: Boolean.
GenBufferPoolCommentGenerate This is the generate BufferPool Comment flag. DATATYPE: Boolean.
GenBufferpoolCreateStatementGenerate This is the generate Bufferpool Create Statement flag. DATATYPE: Boolean.
GenBufferPoolDropStatementGenerate This is the generate BufferPool Drop Statement flag. DATATYPE: Boolean.
GenCloseDatasetGenerate This is the generate Close Dataset flag. DATATYPE: Boolean.
GenColConstraintNameGenerate This is the generate Column Constraint Name flag. DATATYPE: Boolean.This is the
GenColDefaultNameGenerate generate Column Default Name flag. DATATYPE: Boolean.
GenCommitStatementGenerate This is the generate Commit Statement flag. DATATYPE: Boolean.
GenDB2DatabaseCommentGenerate This is the generate DB2Database Comment flag. DATATYPE: Boolean.This is
GenDB2DatabaseCreateStatementGenerate the generate DB2Database Create Statement flag. DATATYPE: Boolean.
GenDB2DatabaseDropStatementGenerate This is the generate DB2Database Drop Statement flag. DATATYPE: Boolean.This is the generate
GenDefaultDropStatementGenerate Default Drop Statement flag. DATATYPE: Boolean.
GenDefaultTableStoredProceduresGenerate This is the generate Default Table Stored Procedures flag. DATATYPE: Boolean.This
GenerateAliasesGenerate is the generate Aliases flag. DATATYPE: Boolean.This is
GenerateAuxTablesGenerate the generate AuxTables flag. DATATYPE: Boolean.
GenerateBufferpoolsGenerate This is the generate Bufferpools flag. DATATYPE: Boolean.This is
GenerateColumnCommentGenerate the generate Column Comment flag. DATATYPE: Boolean.
GenerateColumnConstraintGenerate This is the generate Column Constraint flag. DATATYPE: Boolean.This is the
GenerateColumnDefaultGenerate generate Column Default flag. DATATYPE: Boolean.
GenerateColumnLabelGenerate This is the generate Column Label flag. DATATYPE: Boolean.
GenerateDatabaseMethodSet the method of creating the Database. 1 - single Options include: 1 = Single file, 2 - = ODBC, 3 - = Direct Connection, 4 - multiple = Multiple files. DATATYPE: Integer.
GenerateDB2DatabasesGenerate This is the generate DB2Databases flag. DATATYPE: Boolean.
GenerateDefaultsEnable/Disable generation of Defaults. DATATYPE: Boolean.
GenerateFKConstraintsFlag that indicates whether Flag to indicate if Foreign Key Constraints should be are generated. DATATYPE: Boolean.
GenerateIndexesGenerate This is the generate Indexes flag. DATATYPE: Boolean.
GenerateLogicalFKsFlag to indicate if that indicates whether Logical Foreign Keys should be are generated. DATATYPE: Boolean.
GenerateLogicalPKGenerate This is the generate Logical PK flag. DATATYPE: Boolean.This is the generate
GenerateMaterializedQueryTablesGenerate MaterializedQueryTables flag. DATATYPE: Boolean.
GenerateMaterializedViewsGenerate This is the generate MaterializedViews flag. DATATYPE: Boolean.This is the generate
GenerateNodegroupsGenerate Nodegroups flag. DATATYPE: Boolean.
GenerateNonUniqueIndexesFlag that indicates whether to indicate if generate defined NonUnique Indexes should be generated. DATATYPE: Boolean.
GeneratePKByAlterStatementGenerate This is the generate PK by Alter statement flag. DATATYPE: Boolean.This is
GeneratePKByAlterStatementAndUniqueIndexGenerate the generate PK by Alter statement and unique index flag. DATATYPE: Boolean.
GenerateRollbackSegmentsGenerate This is the generate RollbackSegments flag. DATATYPE: Boolean.
GenerateRulesEnable/Disable generation of Rules. DATATYPE: Boolean.
GenerateSequencesGenerate This is the generate Sequences flag. DATATYPE: Boolean.This is the generate
GenerateStoGroupsGenerate StoGroups flag. DATATYPE: Boolean.
GenerateSynonymsGenerate This is the generate Synonyms flag. DATATYPE: Boolean.This
GenerateSystemTriggersGenerate is the generate System Triggers flag. DATATYPE: Boolean.
GenerateTableCheckConstraintsEnable/Disable generation of Table CheckConstraints. DATATYPE: Boolean.
GenerateTableCommentGenerate This is the generate Table Comment flag. DATATYPE: Boolean.
GenerateTableCreateStatementGenerate This is the generate PK by Alter statement flag. DATATYPE: Boolean.
GenerateTablePostSQLGenerate This is the generate Table PostSQL statement flag. DATATYPE: Boolean.This is
GenerateTablePreSQLGenerate the generate Table Pre SQL statement flag. DATATYPE: Boolean.
GenerateTablespacesGenerate This is the generate Tablespaces flag. DATATYPE: Boolean.
GenerateUserDatatypesEnable/Disable generation of UserDatatypes. DATATYPE: Boolean.
GenerateViewsEnable/Disable generation of Views. DATATYPE: Boolean.
GenFKDropStatementGenerate This is the generate FK Drop Statement flag. DATATYPE: Boolean.
GenForceBackticksGenerate This is the generate Force Backticks flag. DATATYPE: Boolean.This is the generate
GenForceBracketsGenerate Force Brackets flag. DATATYPE: Boolean.
GenForceQuotesGenerate This is the generate Force Quotes flag. DATATYPE: Boolean.
GenFunctionCommentGenerate This is the generate Function Comment flag. DATATYPE: Boolean.This is
GenFunctionCreateStatementGenerate the generate Function Create Statement flag. DATATYPE: Boolean.This
GenFunctionDropStatementGenerate is the generate Function Drop Statement flag. DATATYPE: Boolean.
GenIncludeObjHeaderGenerate This is the generate Include Object Header flag. DATATYPE: Boolean.
GenIndexDropStatementGenerate This is the generate Drop statement flag for indexes. DATATYPE: Boolean.
GenIndexStorageBufferPoolGenerate This is the generate BufferPool property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageExtentGrowthFactorGenerate generate ExtentGrowthFactor property of Index Storage. DATATYPE: Boolean.
GenIndexStorageFillFactorGenerate This is the generate FillFactor property of Index Storage. DATATYPE: Boolean.This is the generate
GenIndexStorageFreeListGenerate FreeList property of Index Storage. DATATYPE: Boolean.
GenIndexStorageFreeListGroupsGenerate This is the generate FreeListGroups property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageIncludeGenerate generate Include property of Index Storage. DATATYPE: Boolean.
GenIndexStorageInitialExtentSizeGenerate This is the generate InitialExtentSize property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageLocationGenerate generate Location property of Index Storage. DATATYPE: Boolean.
GenIndexStorageLockModeGenerate This is the generate LockMode property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageLoggingGenerate generate Logging property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMaxExtentsGenerate This is the generate MaxExtents property of Index Storage. DATATYPE: Boolean.This is the generate
GenIndexStorageMaxRowsPerPageGenerate MaxRowsPerPage property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMaxTransactionsGenerate This is the generate MaxTransactions property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageMinExtentsGenerate generate MinExtents property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMinTransactionsGenerate This is the generate MinTransactions property of Index Storage. DATATYPE: Boolean.This is the generate
GenIndexStorageNextExtentSizeGenerate NextExtentSize property of Index Storage. DATATYPE: Boolean.
GenIndexStoragePadIndexGenerate This is the generate PadIndex property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageParallelGenerate generate Parallel property of Index Storage. DATATYPE: Boolean.
GenIndexStoragePctFreeGenerate This is the generate PctFree property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStoragePctUsedGenerate generate PctUsed property of Index Storage. DATATYPE: Boolean.
GenIndexStorageReverseScansGenerate This is the generate ReverseScans property of Index Storage. DATATYPE: Boolean.This is the
GenIndexStorageSortTempDBGenerate generate SortTempDB property of Index Storage. DATATYPE: Boolean.
GenKeywordBackticksGenerate This is the generate Keyword Backticks flag. DATATYPE: Boolean.This is the
GenKeywordBracketsGenerate generate Keyword Brackets flag. DATATYPE: Boolean.
GenKeywordQuotesGenerate This is the generate Keyword Quotes flag. DATATYPE: Boolean.This
GenLOBSegmentsGenerate is the generate LOB Segments flag. DATATYPE: Boolean.
GenMaterializedQueryTableCommentGenerate This is the generate MaterializedQueryTable Comment flag. DATATYPE: Boolean.This is
GenMaterializedQueryTableCreateStatementGenerate the generate MaterializedQueryTable Create Statement flag. DATATYPE: Boolean.This
GenMaterializedQueryTableDropStatementGenerate is the generate MaterializedQueryTable Drop Statement flag. DATATYPE: Boolean.
GenMaterializedViewPostSQLThis is the Generate Materialized View Post SQL flag. DATATYPE: Boolean.
GenMaterializedViewPreSQL

Generate Materialized View Pre SQL flag. DATATYPE: Boolean.

GenMatViewCommentGenerate This is the generate MaterializedView Comment flag. DATATYPE: Boolean.This is
GenMatViewCreateStatementGenerate the generate MaterializedView Create Statement flag. DATATYPE: Boolean.This
GenMatViewDropStatementGenerate is the generate MaterializedView Drop Statement flag. DATATYPE: Boolean.
GenModelPostSQLGenerate This is the generate Model PostSQL flag. DATATYPE: Boolean.This is the
GenModelPreSQLGenerate generate Model PreSQL flag. DATATYPE: Boolean.
GenNodeGroupCommentGenerate This is the generate NodeGroup Comment flag. DATATYPE: Boolean.This is
GenNodeGroupCreateStatementGenerate the generate NodeGroup Create Statement flag. DATATYPE: Boolean.
GenNodeGroupDropStatementGenerate This is the generate NodeGroup Drop Statement flag. DATATYPE: Boolean.
GenObjectTypeCommentGenerate This is the generate ObjectType Comment flag. DATATYPE: Boolean.This
GenObjectTypeCreateStatementGenerate is the generate ObjectType Create Statement flag. DATATYPE: Boolean.This
GenObjectTypeDropStatementGenerate is the generate ObjectType Drop Statement flag. DATATYPE: Boolean.
GenPackageCommentGenerate This is the generate Package Comment flag. DATATYPE: Boolean.This is
GenPackageCreateStatementGenerate the generate Package Create Statement flag. DATATYPE: Boolean.
GenPackageDropStatementGenerate This is the generate Package Drop Statement flag. DATATYPE: Boolean.
GenProcCreateStatementGenerate This is the generate Procedure Create Statement flag. DATATYPE: Boolean.This is the generate
GenProcDropStatementGenerate Procedure Drop Statement flag. DATATYPE: Boolean.
GenProcedureCommentGenerate This is the generate Procedure Comment flag. DATATYPE: Boolean.This is the
GenRBSegmentCommentGenerate generate RollBackSegment Comment flag. DATATYPE: Boolean.
GenRBSegmentCreateStatementGenerate This is the generate RollBackSegment Create Statement flag. DATATYPE: Boolean.This is the generate
GenRBSegmentDropStatementGenerate RollBackSegment Drop Statement flag. DATATYPE: Boolean.
GenRuleDropStatementGenerate This is the generate Rule Drop Statement flag. DATATYPE: Boolean.
GenSequenceCommentGenerate This is the generate Sequence Comment flag. DATATYPE: Boolean.This is
GenSequenceCreateStatementGenerate the generate Sequence Create Statement flag. DATATYPE: Boolean.This
GenSequenceDropStatementGenerate is the generate Sequence Drop Statement flag. DATATYPE: Boolean.
GenSequencePostSQLThis is the Generate Sequence Post SQL flag. DATATYPE: Boolean.This is
GenSequencePreSQL the Generate Sequence Pre SQL flag. DATATYPE: Boolean.
GenStoGroupCommentGenerate This is the generate StoGroup Comment flag. DATATYPE: Boolean.This is
GenStoGroupCreateStatementGenerate the generate StoGroup Create Statement flag. DATATYPE: Boolean.
GenStoGroupDropStatementGenerate This is the generate StoGroup Drop Statement flag. DATATYPE: Boolean.
GenSynonymCommentGenerate This is the generate Synonym Comment flag. DATATYPE: Boolean.This
GenSynonymCreateStatementGenerate is the generate Synonym Create Statement flag. DATATYPE: Boolean.This is
GenSynonymDropStatementGenerate the generate Synonym Drop Statement flag. DATATYPE: Boolean.
GenTableConstraintNameGenerate This is the generate Table Constraint Name flag. DATATYPE: Boolean.
GenTablespaceCommentGenerate This is the generate Tablespace Comment flag. DATATYPE: Boolean.This is
GenTablespaceCreateStatementGenerate the generate Tablespace Create Statement flag. DATATYPE: Boolean.This
GenTablespaceDropStatementGenerate is the generate Tablespace Drop Statement flag. DATATYPE: Boolean.
GenTableStorageAuditOptionsGenerate This is the generate AuditOptions property of Table Storage. DATATYPE: Boolean.This is the
GenTableStorageCacheStrategyGenerate generate CacheStrategy property of Table Storage. DATATYPE: Boolean.
GenTableStorageDataBlockSizeGenerate This is the generate DataBlockSize property of Table Storage. DATATYPE: Boolean.This is the generate
GenTableStorageEncodingGenerate Encoding property of Table Storage. DATATYPE: Boolean.
GenTableStorageFallbackGenerate This is the generate Fallback property of Table Storage. DATATYPE: Boolean.This is the
GenTableStorageIdentityGapGenerate generate IdentityGap property of Table Storage. DATATYPE: Boolean.
GenTableStorageIndexTablespaceGenerate This is the generate IndexTablespace property of Table Storage. DATATYPE: Boolean.This is the
GenTableStorageJournalingGenerate generate Journaling property of Table Storage. DATATYPE: Boolean.
GenTableStorageLogDataChangesGenerate This is the generate LogDataChanges property of Table Storage. DATATYPE: Boolean.This is the generate
GenTableStorageLoggingGenerate Logging property of Table Storage. DATATYPE: Boolean.
GenTableStorageLongTablespaceGenerate This is the generate LongTablespace property of Table Storage. DATATYPE: Boolean.This is the generate NotLoggedInitially
GenTableStorageNotLogInitiallyGenerate NotLogInitially property of Table Storage. DATATYPE: Boolean.
GenTableStorageOrganizationGenerate This is the generate Organization property of Table Storage. DATATYPE: Boolean.This is
GenTableStorageParallelGenerate the generate Parallel property of Table Storage. DATATYPE: Boolean.This
GenTableStorageReservePageGapGenerate is the generate ReservePageGap property of Table Storage. DATATYPE: Boolean.This
GenTableStorageRestrictOnDropGenerate is the generate RestrictOnDrop property of Table Storage. DATATYPE: Boolean.
GenTriggerCreateStatementGenerate This is the generate Trigger Create Statement flag. DATATYPE: Boolean.This is the generate
GenTriggerDropStatementGenerate Trigger Drop Statementt Statement flag. DATATYPE: Boolean.
GenUserDatatypeDropStatementGenerate This is the generate UserDatatype Drop Statement flag. DATATYPE: Boolean.This is
GenVerifyStatementGenerate the generate Verify Statement flag. DATATYPE: Boolean.
GenViewCreateStatementGenerate This is the generate View Create Statement flag. DATATYPE: Boolean.This is the generate
GenViewDropStatementGenerate View Drop Statement flag. DATATYPE: Boolean.
GenViewPostSQLGenerate This is the generate View PostSQL flag. DATATYPE: Boolean.This is the
GenViewPreSQLGenerate generate View PreSQL flag. DATATYPE: Boolean.
IndexPartitionsEnable/Disable Storage option - IndexPartitions. DATATYPE: Boolean.
InitialExtentSizeEnable/Disable Storage option - InitialExtentSize. DATATYPE: Boolean.
LocationEnable/Disable Storage option - Location. DATATYPE: Boolean.
LockModeEnable/Disable Storage option - LockMode. DATATYPE: Boolean.
LogDeviceFilenameLog Device Filename for new database. DATATYPE: String.
LogDeviceNameLog Device Name for new database. DATATYPE: String.
LogDeviceSizeLog Device Size for new database. DATATYPE: Integer.
MaximumExtentsEnable/Disable Storage option - MaximumExtents. DATATYPE: Boolean.
MaximumTransactionsEnable/Disable Storage option - MaximumTransactions. DATATYPE: Boolean.
MaxRowsPerPageEnable/Disable Storage option - MaxRowsPerPage. DATATYPE: Boolean.
MinimumExtentsEnable/Disable Storage option - MinimumExtents. DATATYPE: Boolean.
MinimumTransactionsEnable/Disable Storage option - MinimumTransactions. DATATYPE: Boolean.
NextExtentSizeEnable/Disable Storage option - NextExtentSize. DATATYPE: Boolean.
PercentFreeEnable/Disable Storage option - PercentFree. DATATYPE: Boolean.
PercentUsedEnable/Disable Storage option - PercentUsed. DATATYPE: Boolean.
PrimaryKeyConstraintTypeSet how Primary Key is generated. 0 - donOptions include: 0 = Don't generate, 1 - unique = Unique index, 2 - = PK constraint. DATATYPE: Integer.
SelectExistingDatabaseUse an existing Database. DATATYPE: Boolean.
SupplyAKConstraintNameIf AK Constraint type is 2, then this indicates if whether constraint names are supplied. DATATYPE: Boolean.
SupplyPKConstraintNameIf PK Constraint type is 2, then this indicates if whether constraint names are supplied. DATATYPE: Boolean.
TablePartitionsEnable/Disable Storage option - TablePartitions. DATATYPE: Boolean.
UsernameThis is the User Name for generating DB objects. DATATYPE: String.This is
UserPassword the User Password for generating DB objects. DATATYPE: String.
Info
titleSee Also