Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
createFlatFileModuleCommand = OMBCREATE ( FLAT_FILE_MODULE "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"
Basic properties for FLAT_FILE_MODULE: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: NAME Business name of the flat file module. Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the flat file module.
Set metadata location and/or icon set and/or journal code template for the new flat file module.
Add a data location to the new flat file module as the new configuration default.