Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 |
|
|
Mobi · ePub |
alterMIVModuleCommand = OMBALTER ( CMI_MODULE "QUOTED_STRING" ( "renameClause" [ "alterPropertiesOrReferenceClauseForDataMetadataModule" ] | "alterPropertiesOrReferenceClauseForDataMetadataModule" ) ) renameClause = RENAME TO "QUOTED_STRING" alterPropertiesOrReferenceClauseForDataMetadataModule = ( ( SET ( ( "alterPropertiesClause" [ ( SET "setReferenceClauseForDataMetadataModule" [ UNSET "unsetReferenceClauseForDataMetadataModule" ] ) | ( UNSET "unsetReferenceClauseForDataMetadataModule" [ SET "setReferenceClauseForDataMetadataModule" ] ) ] ) | ( "setReferenceClauseForDataMetadataModule" [ UNSET "unsetReferenceClauseForDataMetadataModule" ] ) ) ) | ( UNSET "unsetReferenceClauseForDataMetadataModule" [ SET "setReferenceClauseForDataMetadataModule" ] ) ) [ "addOrRemoveOrModifyModuleReferenceLocationClause" ] alterPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" setReferenceClauseForDataMetadataModule = ( "setReferenceLocationClause" [ SET "setReferenceMetadataLocationOrIconSetOrJCTClause" ] | "setReferenceMetadataLocationOrIconSetOrJCTClause" ) unsetReferenceClauseForDataMetadataModule = ( "unsetReferenceLocationClause" [ UNSET "unsetReferenceMetadataLocationOrIconSetOrJCTClause" ] | "unsetReferenceMetadataLocationOrIconSetOrJCTClause" ) addOrRemoveOrModifyModuleReferenceLocationClause = ( "addReferenceLocationClause" | "removeReferenceLocationClause" | "modifyReferenceLocationClause" ) { "addReferenceLocationClause" | "removeReferenceLocationClause" | "modifyReferenceLocationClause" } propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } setReferenceLocationClause = ( REFERENCE | REF ) LOCATION "QUOTED_STRING" setReferenceMetadataLocationOrIconSetOrJCTClause = ( "setJournalCodeTemplateClause" [ SET "setReferenceMetadataLocationOrIconSetClause" ] | "setReferenceMetadataLocationOrIconSetClause" ) unsetReferenceLocationClause = ( REFERENCE | REF ) LOCATION "QUOTED_STRING" unsetReferenceMetadataLocationOrIconSetOrJCTClause = ( "unsetJournalCodeTemplateClause" [ UNSET "unsetReferenceMetadataLocationOrIconSetClause" ] | "unsetReferenceMetadataLocationOrIconSetClause" ) addReferenceLocationClause = ADD ( REFERENCE | REF ) LOCATION "QUOTED_STRING" [ SET AS DEFAULT ] removeReferenceLocationClause = REMOVE ( REFERENCE | REF ) LOCATION "QUOTED_STRING" modifyReferenceLocationClause = MODIFY ( 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" ) unsetJournalCodeTemplateClause = ( REFERENCE | REF ) CDC_CT unsetReferenceMetadataLocationOrIconSetClause = ( "unsetReferenceMetadataLocationClause" [ UNSET "unsetReferenceIconSetClause" ] | "unsetReferenceIconSetClause" ) setReferenceMetadataLocationClause = ( REFERENCE | REF ) METADATA_LOCATION "QUOTED_STRING" setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING" unsetReferenceMetadataLocationClause = ( REFERENCE | REF ) METADATA_LOCATION "QUOTED_STRING" unsetReferenceIconSetClause = ( REFERENCE | REF ) ICONSET
Alter existing CMI module's properties and/or locations and/or icon sets.
For example, to associate the SQL Server
platform to a CMI module:
OMBALTER CMI_MODULE 'PPLSOFT' SET PROPERTIES (TYPE) VALUES ('SQLSERVER')
Similarly, to associate a DB2
platform to a CMI module:
OMBALTER CMI_MODULE 'PPLSOFT' SET PROPERTIES (TYPE) VALUES ('DB2UDB')
Add/remove/modify data location for the CMI module.
Set a data location to the existing CMI module as the new configuration default.
Set metadata location and/or icon set for the CMI module.