Page History
Public Methods
| Methods | Description |
|---|---|
| EnhGenerateFKConstraints | Generate FK Constraints. GenType: 0 = Don't generate, 1 = Generate by Create Table, 2 = Generate by Alter Table. PARAMETERS: GenType (Integer), DependencyOrder (Boolean). |
| GenDDLUsingFileBasedQuickLaunch | Generate DDL using the Quick Launch setting identified by the given filename. PARAMETERS: FileName (Strings). |
| GenDDLUsingQuickLaunch | Generate DDL using the Quick Launch setting identified by the given name. PARAMETERS: Name (Strings). |
| GenerateAllEntities | Set a flag to generate all Entities. |
| GenerateAllStoredProcedures | Set a flag to generate all Stored Procedures. |
| GenerateAllTriggers | Set a flag to generate all Triggers. |
| GenerateDDL | Generate the DDL. Return TRUE for success or FALSE for failure. RETURN DATATYPE: Boolean. |
| GenerateFKConstraintNames | Generate FK Constraint Names when GenerateNames is TRUE. If SupplyNames is TRUE, then unnamed FK are given unique names. PARAMETERS: GenerateNames (Boolean), SupplyNames (Boolean). |
| GenerateNoEntities | Set a flag to not generate any Entities. |
| GenerateNoStoredProcedures | Set a flag to not generate any Stored Procedures. |
| GenerateNoTriggers | Set a flag to not generate any Triggers. |
| GenerateSelectedEntities | Set a flag to generate selected Entities, according to Entity names given in the parameter array. PARAMETERS: EntityNames (VariantArray of Strings). |
| GenerateSelectedStoredProcedures | Set a flag to generate selected Stored Procedures, according to Procedure names given in the parameter array. PARAMETERS: StoredProcedureNames (VariantArray of Strings). |
| GenerateSelectedTriggers | Set a flag to generate selected Triggers, according to Trigger names given in the parameter array. PARAMETERS: TriggerNames (VariantArray of Strings). |
| GetQuickLaunchList | Return all the names of available Quick Launch settings for the Model. RETURN DATATYPE: StringObjects. |
Public Properties
| Property | Description |
|---|---|
| AlternateKeyConstraintType | Set how Alternate Key is generated. |
| Options include: 0 = Don't generate, 1 |
| = Unique index, 2 |
| = Unique constraint. DATATYPE: Integer. | |
| BufferPool | Enable/Disable Storage option - BufferPool. DATATYPE: Boolean. |
| ConnectionName |
| Connection Name for generating DB objects. DATATYPE: String. | |
| CreateNewDatabase | Create a new Database. DATATYPE: Boolean. |
| CreationScriptFilePath | Path to the Database creation script file. DATATYPE: String. |
| DatabaseDeviceFilename | Database Device Filename for new database. DATATYPE: String. |
| DatabaseLogin | Database Login for new database. DATATYPE: String. |
| DatabaseName |
| Database name for new database. DATATYPE: String. | |
| DatabasePassword | Database Password for new database. DATATYPE: String. |
| DataDeviceName | Data Device Name for new database. DATATYPE: String. |
| DataDeviceSize | Data Device Size for new database. DATATYPE: Integer. |
| DataSourceName |
| Data Source Name for generating DB objects. DATATYPE: String. |
| DropObjects | Drop Object flag. DATATYPE: Boolean. |
| EnforceFKCreation | Flag that indicates whether to |
| enforce Foreign Key creation |
| . DATATYPE: Boolean. | |
| ExtentGrowthFactor | Enable/Disable Storage option - ExtentGrowthFactor. DATATYPE: Boolean. |
| Fillfactor | Enable/Disable Storage option - FillFactor. DATATYPE: Boolean. |
| FreeListGroups | Enable/Disable Storage option - FreeListGroups. DATATYPE: Boolean. |
| FreeLists | Enable/Disable Storage option - FreeLists. DATATYPE: Boolean. |
| GenAliasComment | Generate Alias Comment flag. DATATYPE: Boolean. |
| GenAliasCreateStatement | Generate Alias Create Statement flag. DATATYPE: Boolean. |
| GenAliasDropStatement | Generate |
| Alias Drop Statement flag. DATATYPE: Boolean. |
| GenAllOwnerNames | Generate All Owner Names flag. DATATYPE: Boolean. |
| GenAuxTableComment | Generate AuxTable Comment flag. DATATYPE: Boolean. |
| GenAuxTableCreateStatement | Generate AuxTable Create Statement flag. DATATYPE: Boolean. |
| GenAuxTableDropStatement | Generate |
| AuxTable Drop Statement flag. DATATYPE: Boolean. |
| GenBufferPoolComment | Generate |
| BufferPool Comment flag. DATATYPE: Boolean. |
| GenBufferpoolCreateStatement | Generate Bufferpool Create Statement flag. DATATYPE: Boolean. |
| GenBufferPoolDropStatement | Generate |
| BufferPool Drop Statement flag. DATATYPE: Boolean. |
| GenCloseDataset | Generate |
| Close Dataset flag. DATATYPE: Boolean. |
| GenColConstraintName | Generate Column Constraint Name flag. DATATYPE: Boolean. |
| GenColDefaultName | Generate |
| Column Default Name flag. DATATYPE: Boolean. |
| GenCommitStatement | Generate |
| Commit Statement flag. DATATYPE: Boolean. |
| GenDB2DatabaseComment | Generate |
| DB2Database Comment flag. DATATYPE: Boolean. |
| GenDB2DatabaseCreateStatement | Generate DB2Database Create Statement flag. DATATYPE: Boolean. |
| GenDB2DatabaseDropStatement | Generate DB2Database Drop Statement flag. DATATYPE: Boolean. |
| GenDefaultDropStatement | Generate Default Drop Statement flag. DATATYPE: Boolean. |
| GenDefaultTableStoredProcedures | Generate Default Table Stored Procedures flag. DATATYPE: Boolean. |
| GenerateAliases | Generate |
| Aliases flag. DATATYPE: Boolean. |
| GenerateAuxTables | Generate |
| AuxTables flag. DATATYPE: Boolean. |
| GenerateBufferpools | Generate Bufferpools flag. DATATYPE: Boolean. |
| GenerateColumnComment | Generate Column Comment flag. DATATYPE: Boolean. |
| GenerateColumnConstraint | Generate Column Constraint flag. DATATYPE: Boolean. |
| GenerateColumnDefault | Generate |
| Column Default flag. DATATYPE: Boolean. |
| GenerateColumnLabel | Generate |
| Column Label flag. DATATYPE: Boolean. | |
| GenerateDatabaseMethod | Set the method of creating the Database. |
| Options include: 1 = Single file, 2 |
| = ODBC, 3 |
| = Direct Connection, 4 |
| = Multiple files. DATATYPE: Integer. |
| GenerateDB2Databases | Generate |
| DB2Databases flag. DATATYPE: Boolean. | |
| GenerateDefaults | Enable/Disable generation of Defaults. DATATYPE: Boolean. |
| GenerateFKConstraints | Flag that indicates whether Foreign Key Constraints |
| are generated. DATATYPE: Boolean. |
| GenerateIndexes | Generate Indexes flag. DATATYPE: Boolean. |
| GenerateLogicalFKs | Flag |
| that indicates whether Logical Foreign Keys |
| are generated. DATATYPE: Boolean. |
| GenerateLogicalPK | Generate Logical PK flag. DATATYPE: Boolean. |
| GenerateMaterializedQueryTables | Generate |
| MaterializedQueryTables flag. DATATYPE: Boolean. |
| GenerateMaterializedViews | Generate |
| MaterializedViews flag. DATATYPE: Boolean. |
| GenerateNodegroups | Generate |
| Nodegroups flag. DATATYPE: Boolean. | |
| GenerateNonUniqueIndexes | Flag that indicates whether to |
| generate defined NonUnique Indexes |
| . DATATYPE: Boolean. |
| GeneratePKByAlterStatement | Generate |
| PK by Alter statement flag. DATATYPE: Boolean. |
| GeneratePKByAlterStatementAndUniqueIndex | Generate PK by Alter statement and unique index flag. DATATYPE: Boolean. |
| GenerateRollbackSegments | Generate |
| RollbackSegments flag. DATATYPE: Boolean. | |
| GenerateRules | Enable/Disable generation of Rules. DATATYPE: Boolean. |
| GenerateSequences | Generate Sequences flag. DATATYPE: Boolean. |
| GenerateStoGroups | Generate |
| StoGroups flag. DATATYPE: Boolean. |
| GenerateSynonyms | Generate Synonyms flag. DATATYPE: Boolean. |
| GenerateSystemTriggers | Generate System Triggers flag. DATATYPE: Boolean. |
| GenerateTableCheckConstraints | Enable/Disable generation of Table CheckConstraints. DATATYPE: Boolean. |
| GenerateTableComment | Generate Table Comment flag. DATATYPE: Boolean. |
| GenerateTableCreateStatement | Generate PK by Alter statement flag. DATATYPE: Boolean. |
| GenerateTablePostSQL | Generate Table PostSQL statement flag. DATATYPE: Boolean. |
| GenerateTablePreSQL | Generate Table Pre SQL statement flag. DATATYPE: Boolean. |
| GenerateTablespaces | Generate |
| Tablespaces flag. DATATYPE: Boolean. | |
| GenerateUserDatatypes | Enable/Disable generation of UserDatatypes. DATATYPE: Boolean. |
| GenerateViews | Enable/Disable generation of Views. DATATYPE: Boolean. |
| GenFKDropStatement | Generate FK Drop Statement flag. DATATYPE: Boolean. |
| GenForceBackticks | Generate |
| Force Backticks flag. DATATYPE: Boolean. |
| GenForceBrackets | Generate |
| Force Brackets flag. DATATYPE: Boolean. |
| GenForceQuotes | Generate Force Quotes flag. DATATYPE: Boolean. |
| GenFunctionComment | Generate |
| Function Comment flag. DATATYPE: Boolean. |
| GenFunctionCreateStatement | Generate Function Create Statement flag. DATATYPE: Boolean. |
| GenFunctionDropStatement | Generate |
| Function Drop Statement flag. DATATYPE: Boolean. |
| GenIncludeObjHeader | Generate |
| Include Object Header flag. DATATYPE: Boolean. |
| GenIndexDropStatement | Generate Drop statement flag for indexes. DATATYPE: Boolean. |
| GenIndexStorageBufferPool | Generate |
| BufferPool property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageExtentGrowthFactor | Generate ExtentGrowthFactor property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageFillFactor | Generate |
| FillFactor property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageFreeList | Generate FreeList property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageFreeListGroups | Generate |
| FreeListGroups property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageInclude | Generate Include property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageInitialExtentSize | Generate |
| InitialExtentSize property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageLocation | Generate Location property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageLockMode | Generate |
| LockMode property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageLogging | Generate |
| Logging property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageMaxExtents | Generate |
| MaxExtents property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageMaxRowsPerPage | Generate MaxRowsPerPage property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageMaxTransactions | Generate MaxTransactions property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageMinExtents | Generate MinExtents property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageMinTransactions | Generate |
| MinTransactions property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageNextExtentSize | Generate |
| NextExtentSize property of Index Storage. DATATYPE: Boolean. |
| GenIndexStoragePadIndex | Generate |
| PadIndex property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageParallel | Generate |
| Parallel property of Index Storage. DATATYPE: Boolean. |
| GenIndexStoragePctFree | Generate |
| PctFree property of Index Storage. DATATYPE: Boolean. |
| GenIndexStoragePctUsed | Generate |
| PctUsed property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageReverseScans | Generate |
| ReverseScans property of Index Storage. DATATYPE: Boolean. |
| GenIndexStorageSortTempDB | Generate |
| SortTempDB property of Index Storage. DATATYPE: Boolean. |
| GenKeywordBackticks | Generate |
| Keyword Backticks flag. DATATYPE: Boolean. |
| GenKeywordBrackets | Generate |
| Keyword Brackets flag. DATATYPE: Boolean. |
| GenKeywordQuotes | Generate Keyword Quotes flag. DATATYPE: Boolean. |
| GenLOBSegments | Generate LOB Segments flag. DATATYPE: Boolean. |
| GenMaterializedQueryTableComment | Generate MaterializedQueryTable Comment flag. DATATYPE: Boolean. |
| GenMaterializedQueryTableCreateStatement | Generate MaterializedQueryTable Create Statement flag. DATATYPE: Boolean. |
| GenMaterializedQueryTableDropStatement | Generate MaterializedQueryTable Drop Statement flag. DATATYPE: Boolean. |
| GenMaterializedViewPostSQL | Generate Materialized View Post SQL flag. DATATYPE: Boolean. |
| GenMaterializedViewPreSQL | Generate Materialized View Pre SQL flag. DATATYPE: Boolean. |
| GenMatViewComment | Generate MaterializedView Comment flag. DATATYPE: Boolean. |
| GenMatViewCreateStatement | Generate MaterializedView Create Statement flag. DATATYPE: Boolean. |
| GenMatViewDropStatement | Generate MaterializedView Drop Statement flag. DATATYPE: Boolean. |
| GenModelPostSQL | Generate Model PostSQL flag. DATATYPE: Boolean. |
| GenModelPreSQL | Generate Model PreSQL flag. DATATYPE: Boolean. |
| GenNodeGroupComment | Generate NodeGroup Comment flag. DATATYPE: Boolean. |
| GenNodeGroupCreateStatement | Generate NodeGroup Create Statement flag. DATATYPE: Boolean. |
| GenNodeGroupDropStatement | Generate NodeGroup Drop Statement flag. DATATYPE: Boolean. |
| GenObjectTypeComment | Generate ObjectType Comment flag. DATATYPE: Boolean. |
| GenObjectTypeCreateStatement | Generate ObjectType Create Statement flag. DATATYPE: Boolean. |
| GenObjectTypeDropStatement | Generate ObjectType Drop Statement flag. DATATYPE: Boolean. |
| GenPackageComment | Generate Package Comment flag. DATATYPE: Boolean. |
| GenPackageCreateStatement | Generate Package Create Statement flag. DATATYPE: Boolean. |
| GenPackageDropStatement | Generate Package Drop Statement flag. DATATYPE: Boolean. |
| GenProcCreateStatement | Generate Procedure Create Statement flag. DATATYPE: Boolean. |
| GenProcDropStatement | Generate Procedure Drop Statement flag. DATATYPE: Boolean. |
| GenProcedureComment | Generate Procedure Comment flag. DATATYPE: Boolean. |
| GenRBSegmentComment | Generate RollBackSegment Comment flag. DATATYPE: Boolean. |
| GenRBSegmentCreateStatement | Generate RollBackSegment Create Statement flag. DATATYPE: Boolean. |
| GenRBSegmentDropStatement | Generate RollBackSegment Drop Statement flag. DATATYPE: Boolean. |
| GenRuleDropStatement | Generate Rule Drop Statement flag. DATATYPE: Boolean. |
| GenSequenceComment | Generate Sequence Comment flag. DATATYPE: Boolean. |
| GenSequenceCreateStatement | Generate Sequence Create Statement flag. DATATYPE: Boolean. |
| GenSequenceDropStatement | Generate Sequence Drop Statement flag. DATATYPE: Boolean. |
| GenSequencePostSQL | Generate Sequence Post SQL flag. DATATYPE: Boolean. |
| GenSequencePreSQL | Generate Sequence Pre SQL flag. DATATYPE: Boolean. |
| GenStoGroupComment | Generate StoGroup Comment flag. DATATYPE: Boolean. |
| GenStoGroupCreateStatement | Generate StoGroup Create Statement flag. DATATYPE: Boolean. |
| GenStoGroupDropStatement | Generate StoGroup Drop Statement flag. DATATYPE: Boolean. |
| GenSynonymComment | Generate Synonym Comment flag. DATATYPE: Boolean. |
| GenSynonymCreateStatement | Generate Synonym Create Statement flag. DATATYPE: Boolean. |
| GenSynonymDropStatement | Generate Synonym Drop Statement flag. DATATYPE: Boolean. |
| GenTableConstraintName | Generate Table Constraint Name flag. DATATYPE: Boolean. |
| GenTablespaceComment | Generate Tablespace Comment flag. DATATYPE: Boolean. |
| GenTablespaceCreateStatement | Generate Tablespace Create Statement flag. DATATYPE: Boolean. |
| GenTablespaceDropStatement | Generate Tablespace Drop Statement flag. DATATYPE: Boolean. |
| GenTableStorageAuditOptions | Generate AuditOptions property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageCacheStrategy | Generate CacheStrategy property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageDataBlockSize | Generate DataBlockSize property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageEncoding | Generate Encoding property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageFallback | Generate Fallback property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageIdentityGap | Generate IdentityGap property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageIndexTablespace | Generate IndexTablespace property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageJournaling | Generate Journaling property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageLogDataChanges | Generate LogDataChanges property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageLogging | Generate Logging property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageLongTablespace | Generate LongTablespace property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageNotLogInitially | Generate NotLogInitially property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageOrganization | Generate Organization property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageParallel | Generate Parallel property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageReservePageGap | Generate ReservePageGap property of Table Storage. DATATYPE: Boolean. |
| GenTableStorageRestrictOnDrop | Generate RestrictOnDrop property of Table Storage. DATATYPE: Boolean. |
| GenTriggerCreateStatement | Generate Trigger Create Statement flag. DATATYPE: Boolean. |
| GenTriggerDropStatement | Generate Trigger Drop Statement flag. DATATYPE: Boolean. |
| GenUserDatatypeDropStatement | Generate UserDatatype Drop Statement flag. DATATYPE: Boolean. |
| GenVerifyStatement | Generate Verify Statement flag. DATATYPE: Boolean. |
| GenViewCreateStatement | Generate View Create Statement flag. DATATYPE: Boolean. |
| GenViewDropStatement | Generate View Drop Statement flag. DATATYPE: Boolean. |
| GenViewPostSQL | Generate View PostSQL flag. DATATYPE: Boolean. |
| GenViewPreSQL | Generate View PreSQL flag. DATATYPE: Boolean. |
| IndexPartitions | Enable/Disable Storage option - IndexPartitions. DATATYPE: Boolean. |
| InitialExtentSize | Enable/Disable Storage option - InitialExtentSize. DATATYPE: Boolean. |
| Location | Enable/Disable Storage option - Location. DATATYPE: Boolean. |
| LockMode | Enable/Disable Storage option - LockMode. DATATYPE: Boolean. |
| LogDeviceFilename | Log Device Filename for new database. DATATYPE: String. |
| LogDeviceName | Log Device Name for new database. DATATYPE: String. |
| LogDeviceSize | Log Device Size for new database. DATATYPE: Integer. |
| MaximumExtents | Enable/Disable Storage option - MaximumExtents. DATATYPE: Boolean. |
| MaximumTransactions | Enable/Disable Storage option - MaximumTransactions. DATATYPE: Boolean. |
| MaxRowsPerPage | Enable/Disable Storage option - MaxRowsPerPage. DATATYPE: Boolean. |
| MinimumExtents | Enable/Disable Storage option - MinimumExtents. DATATYPE: Boolean. |
| MinimumTransactions | Enable/Disable Storage option - MinimumTransactions. DATATYPE: Boolean. |
| NextExtentSize | Enable/Disable Storage option - NextExtentSize. DATATYPE: Boolean. |
| PercentFree | Enable/Disable Storage option - PercentFree. DATATYPE: Boolean. |
| PercentUsed | Enable/Disable Storage option - PercentUsed. DATATYPE: Boolean. |
| PrimaryKeyConstraintType | Set how Primary Key is generated. Options include: 0 = Don't generate, 1 = Unique index, 2 = PK constraint. DATATYPE: Integer. |
| SelectExistingDatabase | Use an existing Database. DATATYPE: Boolean. |
| SupplyAKConstraintName | If AK Constraint type is 2, then this indicates whether constraint names are supplied. DATATYPE: Boolean. |
| SupplyPKConstraintName | If PK Constraint type is 2, then this indicates whether constraint names are supplied. DATATYPE: Boolean. |
| TablePartitions | Enable/Disable Storage option - TablePartitions. DATATYPE: Boolean. |
| Username | User Name for generating DB objects. DATATYPE: String. |
| UserPassword | User Password for generating DB objects. DATATYPE: String. |
| Info | ||
|---|---|---|
| ||