| Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 | 
 | 
| 
 | Mobi · ePub | 
To create a module based on a platform. You can create a module for seeded platforms (DB2, SQL Server) as well as for unseeded platforms that are created using OMBCREATE PLATFORM.
UNQUOTED_STRING represents <PLATFORM NAME>_MODULE and must be defined using upper case.
For example, to create a DB2 module called MODULE1, the command is:
OMBCREATE DB2UDB_MODULE 'MODULE1'
Note that the module name is specified within quotes.
parseCreateCommand =  OMBCREATE ( "UNQUOTED_STRING" "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 module: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: NAME Business name of the module Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the module