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. 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.
GenerateAliasesGenerate Aliases flag. DATATYPE: Boolean.
GenerateAuxTablesGenerate AuxTables flag. DATATYPE: Boolean.
GenerateBufferpoolsGenerate Bufferpools flag. DATATYPE: Boolean.
GenerateColumnCommentGenerate Column Comment flag. DATATYPE: Boolean.
GenerateColumnConstraintGenerate Column Constraint flag. DATATYPE: Boolean.
GenerateColumnDefaultGenerate Column Default flag. DATATYPE: Boolean.
GenerateColumnLabelGenerate Column Label flag. DATATYPE: Boolean.
GenerateDatabaseMethodSet the method of creating the Database. Options include: 1 = Single file, 2 = ODBC, 3 = Direct Connection, 4 = Multiple files. DATATYPE: Integer.
GenerateDB2DatabasesGenerate DB2Databases flag. DATATYPE: Boolean.
GenerateDefaultsEnable/Disable generation of Defaults. DATATYPE: Boolean.
GenerateFKConstraintsFlag that indicates whether Foreign Key Constraints are generated. DATATYPE: Boolean.
GenerateIndexesGenerate Indexes flag. DATATYPE: Boolean.
GenerateLogicalFKsFlag that indicates whether Logical Foreign Keys are generated. DATATYPE: Boolean.
GenerateLogicalPKGenerate Logical PK flag. DATATYPE: Boolean.
GenerateMaterializedQueryTablesGenerate MaterializedQueryTables flag. DATATYPE: Boolean.
GenerateMaterializedViewsGenerate MaterializedViews flag. DATATYPE: Boolean.
GenerateNodegroupsGenerate Nodegroups flag. DATATYPE: Boolean.
GenerateNonUniqueIndexesFlag that indicates whether to generate defined NonUnique Indexes. DATATYPE: Boolean.
GeneratePKByAlterStatementGenerate PK by Alter statement flag. DATATYPE: Boolean.
GeneratePKByAlterStatementAndUniqueIndexGenerate PK by Alter statement and unique index flag. DATATYPE: Boolean.
GenerateRollbackSegmentsGenerate RollbackSegments flag. DATATYPE: Boolean.
GenerateRulesEnable/Disable generation of Rules. DATATYPE: Boolean.
GenerateSequencesGenerate Sequences flag. DATATYPE: Boolean.
GenerateStoGroupsGenerate StoGroups flag. DATATYPE: Boolean.
GenerateSynonymsGenerate Synonyms flag. DATATYPE: Boolean.
GenerateSystemTriggersGenerate System Triggers flag. DATATYPE: Boolean.
GenerateTableCheckConstraintsEnable/Disable generation of Table CheckConstraints. DATATYPE: Boolean.
GenerateTableCommentGenerate Table Comment flag. DATATYPE: Boolean.
GenerateTableCreateStatementGenerate PK by Alter statement flag. DATATYPE: Boolean.
GenerateTablePostSQLGenerate Table PostSQL statement flag. DATATYPE: Boolean.
GenerateTablePreSQLGenerate Table Pre SQL statement flag. DATATYPE: Boolean.
GenerateTablespacesGenerate Tablespaces flag. DATATYPE: Boolean.
GenerateUserDatatypesEnable/Disable generation of UserDatatypes. DATATYPE: Boolean.
GenerateViewsEnable/Disable generation of Views. DATATYPE: Boolean.
GenFKDropStatementGenerate FK Drop Statement flag. DATATYPE: Boolean.
GenForceBackticksGenerate Force Backticks flag. DATATYPE: Boolean.
GenForceBracketsGenerate Force Brackets flag. DATATYPE: Boolean.
GenForceQuotesGenerate Force Quotes flag. DATATYPE: Boolean.
GenFunctionCommentGenerate Function Comment flag. DATATYPE: Boolean.
GenFunctionCreateStatementGenerate Function Create Statement flag. DATATYPE: Boolean.
GenFunctionDropStatementGenerate Function Drop Statement flag. DATATYPE: Boolean.
GenIncludeObjHeaderGenerate Include Object Header flag. DATATYPE: Boolean.
GenIndexDropStatementGenerate Drop statement flag for indexes. DATATYPE: Boolean.
GenIndexStorageBufferPoolGenerate BufferPool property of Index Storage. DATATYPE: Boolean.
GenIndexStorageExtentGrowthFactorGenerate ExtentGrowthFactor property of Index Storage. DATATYPE: Boolean.
GenIndexStorageFillFactorGenerate FillFactor property of Index Storage. DATATYPE: Boolean.
GenIndexStorageFreeListGenerate FreeList property of Index Storage. DATATYPE: Boolean.
GenIndexStorageFreeListGroupsGenerate FreeListGroups property of Index Storage. DATATYPE: Boolean.
GenIndexStorageIncludeGenerate Include property of Index Storage. DATATYPE: Boolean.
GenIndexStorageInitialExtentSizeGenerate InitialExtentSize property of Index Storage. DATATYPE: Boolean.
GenIndexStorageLocationGenerate Location property of Index Storage. DATATYPE: Boolean.
GenIndexStorageLockModeGenerate LockMode property of Index Storage. DATATYPE: Boolean.
GenIndexStorageLoggingGenerate Logging property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMaxExtentsGenerate MaxExtents property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMaxRowsPerPageGenerate MaxRowsPerPage property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMaxTransactionsGenerate MaxTransactions property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMinExtentsGenerate MinExtents property of Index Storage. DATATYPE: Boolean.
GenIndexStorageMinTransactionsGenerate MinTransactions property of Index Storage. DATATYPE: Boolean.
GenIndexStorageNextExtentSizeGenerate NextExtentSize property of Index Storage. DATATYPE: Boolean.
GenIndexStoragePadIndexGenerate PadIndex property of Index Storage. DATATYPE: Boolean.
GenIndexStorageParallelGenerate Parallel property of Index Storage. DATATYPE: Boolean.
GenIndexStoragePctFreeGenerate PctFree property of Index Storage. DATATYPE: Boolean.
GenIndexStoragePctUsedGenerate PctUsed property of Index Storage. DATATYPE: Boolean.
GenIndexStorageReverseScansGenerate ReverseScans property of Index Storage. DATATYPE: Boolean.
GenIndexStorageSortTempDBGenerate SortTempDB property of Index Storage. DATATYPE: Boolean.
GenKeywordBackticksGenerate Keyword Backticks flag. DATATYPE: Boolean.
GenKeywordBracketsGenerate Keyword Brackets flag. DATATYPE: Boolean.
GenKeywordQuotesGenerate Keyword Quotes flag. DATATYPE: Boolean.
GenLOBSegmentsGenerate LOB Segments flag. DATATYPE: Boolean.
GenMaterializedQueryTableCommentGenerate MaterializedQueryTable Comment flag. DATATYPE: Boolean.
GenMaterializedQueryTableCreateStatementGenerate MaterializedQueryTable Create Statement flag. DATATYPE: Boolean.
GenMaterializedQueryTableDropStatementGenerate MaterializedQueryTable Drop Statement flag. DATATYPE: Boolean.
GenMaterializedViewPostSQLGenerate Materialized View Post SQL flag. DATATYPE: Boolean.
GenMaterializedViewPreSQL

Generate Materialized View Pre SQL flag. DATATYPE: Boolean.

GenMatViewCommentGenerate MaterializedView Comment flag. DATATYPE: Boolean.
GenMatViewCreateStatementGenerate MaterializedView Create Statement flag. DATATYPE: Boolean.
GenMatViewDropStatementGenerate MaterializedView Drop Statement flag. DATATYPE: Boolean.
GenModelPostSQLGenerate Model PostSQL flag. DATATYPE: Boolean.
GenModelPreSQLGenerate Model PreSQL flag. DATATYPE: Boolean.
GenNodeGroupCommentGenerate NodeGroup Comment flag. DATATYPE: Boolean.
GenNodeGroupCreateStatementGenerate NodeGroup Create Statement flag. DATATYPE: Boolean.
GenNodeGroupDropStatementGenerate NodeGroup Drop Statement flag. DATATYPE: Boolean.
GenObjectTypeCommentGenerate ObjectType Comment flag. DATATYPE: Boolean.
GenObjectTypeCreateStatementGenerate ObjectType Create Statement flag. DATATYPE: Boolean.
GenObjectTypeDropStatementGenerate ObjectType Drop Statement flag. DATATYPE: Boolean.
GenPackageCommentGenerate Package Comment flag. DATATYPE: Boolean.
GenPackageCreateStatementGenerate Package Create Statement flag. DATATYPE: Boolean.
GenPackageDropStatementGenerate Package Drop Statement flag. DATATYPE: Boolean.
GenProcCreateStatementGenerate Procedure Create Statement flag. DATATYPE: Boolean.
GenProcDropStatementGenerate Procedure Drop Statement flag. DATATYPE: Boolean.
GenProcedureCommentGenerate Procedure Comment flag. DATATYPE: Boolean.
GenRBSegmentCommentGenerate RollBackSegment Comment flag. DATATYPE: Boolean.
GenRBSegmentCreateStatementGenerate RollBackSegment Create Statement flag. DATATYPE: Boolean.
GenRBSegmentDropStatementGenerate RollBackSegment Drop Statement flag. DATATYPE: Boolean.
GenRuleDropStatementGenerate Rule Drop Statement flag. DATATYPE: Boolean.
GenSequenceCommentGenerate Sequence Comment flag. DATATYPE: Boolean.
GenSequenceCreateStatementGenerate Sequence Create Statement flag. DATATYPE: Boolean.
GenSequenceDropStatementGenerate Sequence Drop Statement flag. DATATYPE: Boolean.
GenSequencePostSQLGenerate Sequence Post SQL flag. DATATYPE: Boolean.
GenSequencePreSQLGenerate Sequence Pre SQL flag. DATATYPE: Boolean.
GenStoGroupCommentGenerate StoGroup Comment flag. DATATYPE: Boolean.
GenStoGroupCreateStatementGenerate StoGroup Create Statement flag. DATATYPE: Boolean.
GenStoGroupDropStatementGenerate StoGroup Drop Statement flag. DATATYPE: Boolean.
GenSynonymCommentGenerate Synonym Comment flag. DATATYPE: Boolean.
GenSynonymCreateStatementGenerate Synonym Create Statement flag. DATATYPE: Boolean.
GenSynonymDropStatementGenerate Synonym Drop Statement flag. DATATYPE: Boolean.
GenTableConstraintNameGenerate Table Constraint Name flag. DATATYPE: Boolean.
GenTablespaceCommentGenerate Tablespace Comment flag. DATATYPE: Boolean.
GenTablespaceCreateStatementGenerate Tablespace Create Statement flag. DATATYPE: Boolean.
GenTablespaceDropStatementGenerate Tablespace Drop Statement flag. DATATYPE: Boolean.
GenTableStorageAuditOptionsGenerate AuditOptions property of Table Storage. DATATYPE: Boolean.
GenTableStorageCacheStrategyGenerate CacheStrategy property of Table Storage. DATATYPE: Boolean.
GenTableStorageDataBlockSizeGenerate DataBlockSize property of Table Storage. DATATYPE: Boolean.
GenTableStorageEncodingGenerate Encoding property of Table Storage. DATATYPE: Boolean.
GenTableStorageFallbackGenerate Fallback property of Table Storage. DATATYPE: Boolean.
GenTableStorageIdentityGapGenerate IdentityGap property of Table Storage. DATATYPE: Boolean.
GenTableStorageIndexTablespaceGenerate IndexTablespace property of Table Storage. DATATYPE: Boolean.
GenTableStorageJournalingGenerate Journaling property of Table Storage. DATATYPE: Boolean.
GenTableStorageLogDataChangesGenerate LogDataChanges property of Table Storage. DATATYPE: Boolean.
GenTableStorageLoggingGenerate Logging property of Table Storage. DATATYPE: Boolean.
GenTableStorageLongTablespaceGenerate LongTablespace property of Table Storage. DATATYPE: Boolean.
GenTableStorageNotLogInitiallyGenerate NotLogInitially property of Table Storage. DATATYPE: Boolean.
GenTableStorageOrganizationGenerate Organization property of Table Storage. DATATYPE: Boolean.
GenTableStorageParallelGenerate Parallel property of Table Storage. DATATYPE: Boolean.
GenTableStorageReservePageGapGenerate ReservePageGap property of Table Storage. DATATYPE: Boolean.
GenTableStorageRestrictOnDropGenerate RestrictOnDrop property of Table Storage. DATATYPE: Boolean.
GenTriggerCreateStatementGenerate Trigger Create Statement flag. DATATYPE: Boolean.
GenTriggerDropStatementGenerate Trigger Drop Statement flag. DATATYPE: Boolean.
GenUserDatatypeDropStatementGenerate UserDatatype Drop Statement flag. DATATYPE: Boolean.
GenVerifyStatementGenerate Verify Statement flag. DATATYPE: Boolean.
GenViewCreateStatementGenerate View Create Statement flag. DATATYPE: Boolean.
GenViewDropStatementGenerate View Drop Statement flag. DATATYPE: Boolean.
GenViewPostSQLGenerate View PostSQL flag. DATATYPE: Boolean.
GenViewPreSQLGenerate 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. Options include: 0 = Don't generate, 1 = Unique index, 2 = PK constraint. DATATYPE: Integer.
SelectExistingDatabaseUse an existing Database. DATATYPE: Boolean.
SupplyAKConstraintNameIf AK Constraint type is 2, then this indicates whether constraint names are supplied. DATATYPE: Boolean.
SupplyPKConstraintNameIf PK Constraint type is 2, then this indicates whether constraint names are supplied. DATATYPE: Boolean.
TablePartitionsEnable/Disable Storage option - TablePartitions. DATATYPE: Boolean.
UsernameUser Name for generating DB objects. DATATYPE: String.
UserPasswordUser Password for generating DB objects. DATATYPE: String.
Info
titleSee Also