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. |
| 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. Options include: 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. |
See Also