Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 |
|
|
Mobi · ePub |
createMIVModuleCommand = OMBCREATE ( CMI_MODULE "QUOTED_STRING" USING CMI_DEFINITION "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET "setReferenceClauseForDataMetadataModule" ] | "setReferenceClauseForDataMetadataModule" ) ] [ "addModuleReferenceLocationClause" ] ) setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" setReferenceClauseForDataMetadataModule = ( "setReferenceLocationClause" [ SET "setReferenceMetadataLocationOrIconSetOrJCTClause" ] | "setReferenceMetadataLocationOrIconSetOrJCTClause" ) addModuleReferenceLocationClause = "addReferenceLocationClause" { "addReferenceLocationClause" } propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } setReferenceLocationClause = ( REFERENCE | REF ) LOCATION "QUOTED_STRING" setReferenceMetadataLocationOrIconSetOrJCTClause = ( "setJournalCodeTemplateClause" [ SET "setReferenceMetadataLocationOrIconSetClause" ] | "setReferenceMetadataLocationOrIconSetClause" ) addReferenceLocationClause = ADD ( REFERENCE | REF ) LOCATION "QUOTED_STRING" [ SET AS DEFAULT ] propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" ) setJournalCodeTemplateClause = ( REFERENCE | REF ) CDC_CT "QUOTED_STRING" | ( ( REFERENCE | REF ) CDC_CT OPTIONS "(" "propertyValueList" ")" VALUES "(" "propertyValueList" ")" ) setReferenceMetadataLocationOrIconSetClause = ( "setReferenceMetadataLocationClause" [ SET "setReferenceIconSetClause" ] | "setReferenceIconSetClause" ) setReferenceMetadataLocationClause = ( REFERENCE | REF ) METADATA_LOCATION "QUOTED_STRING" setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
Associate a set of properties with a CMI module. For example, you can use this clause to set the platform for a module. For example:
OMBCREATE CMI_MODULE 'PPLSOFT' SET PROPERTIES (TYPE) VALUES ('DB2UDB')
Basic properties for CMI_MODULE: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: NAME Business name of an CMI Module Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of an CMI Module
Set metadata location and/or icon set for the CMI module.
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
DB_LOCATION |
STRING |
none |
none |
none |
empty string |
If this is a source module, this value indicates the location from which data will be read. If this is a target warehouse module, this value indicates the location where generated code will be deployed to and/or where data will be written to. |