OMBALTER MAPPING_MODULE

Purpose

Alter the mapping module by renaming it, and/or reseting its properties.

Prerequisites

Should be in the context of a project.

Syntax

alterMapModuleCommand =  OMBALTER ( MAPPING_MODULE "QUOTED_STRING" ( 
          "renameClause" [ 
          "alterPropertiesOrReferenceOrJCTClauseForDataMetadataModule" ] | 
          "alterPropertiesOrReferenceOrJCTClauseForDataMetadataModule" | 
          "addOrRemoveOrModifyModuleReferenceLocationClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrReferenceOrJCTClauseForDataMetadataModule =  ( 
          "alterJournalCodeTemplateClause" [ 
          "alterPropertiesOrReferenceClauseForDataMetadataModule" ] | 
          "alterPropertiesOrReferenceClauseForDataMetadataModule" )
     addOrRemoveOrModifyModuleReferenceLocationClause =  ( 
          "addReferenceLocationClause" | "removeReferenceLocationClause" | 
          "modifyReferenceLocationClause" ) { "addReferenceLocationClause" | 
          "removeReferenceLocationClause" | "modifyReferenceLocationClause" }
     alterJournalCodeTemplateClause =  SET "setJournalCodeTemplateClause" | 
          UNSET "unsetJournalCodeTemplateClause"
     alterPropertiesOrReferenceClauseForDataMetadataModule =  ( ( SET ( ( 
          "alterPropertiesClause" [ ( SET 
          "setReferenceClauseForDataMetadataModule" [ UNSET 
          "unsetReferenceClauseForDataMetadataModule" ] ) | ( UNSET 
          "unsetReferenceClauseForDataMetadataModule" [ SET 
          "setReferenceClauseForDataMetadataModule" ] ) ] ) | ( 
          "setReferenceClauseForDataMetadataModule" [ UNSET 
          "unsetReferenceClauseForDataMetadataModule" ] ) ) ) | ( UNSET 
          "unsetReferenceClauseForDataMetadataModule" [ SET 
          "setReferenceClauseForDataMetadataModule" ] ) ) [ 
          "addOrRemoveOrModifyModuleReferenceLocationClause" ]
     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
     setJournalCodeTemplateClause =  ( REFERENCE | REF ) CDC_CT "QUOTED_STRING" 
          | ( ( REFERENCE | REF ) CDC_CT OPTIONS "(" "propertyValueList" ")" 
          VALUES "(" "propertyValueList" ")" )
     unsetJournalCodeTemplateClause =  ( REFERENCE | REF ) CDC_CT
     alterPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceClauseForDataMetadataModule =  ( "setReferenceLocationClause" [
           SET "setReferenceMetadataLocationOrIconSetOrJCTClause" ] | 
          "setReferenceMetadataLocationOrIconSetOrJCTClause" )
     unsetReferenceClauseForDataMetadataModule =  ( 
          "unsetReferenceLocationClause" [ UNSET 
          "unsetReferenceMetadataLocationOrIconSetOrJCTClause" ] | 
          "unsetReferenceMetadataLocationOrIconSetOrJCTClause" )
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     setReferenceLocationClause =  ( REFERENCE | REF ) LOCATION "QUOTED_STRING"
     setReferenceMetadataLocationOrIconSetOrJCTClause =  ( 
          "setJournalCodeTemplateClause" [ SET 
          "setReferenceMetadataLocationOrIconSetClause" ] | 
          "setReferenceMetadataLocationOrIconSetClause" )
     unsetReferenceLocationClause =  ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     unsetReferenceMetadataLocationOrIconSetOrJCTClause =  ( 
          "unsetJournalCodeTemplateClause" [ UNSET 
          "unsetReferenceMetadataLocationOrIconSetClause" ] | 
          "unsetReferenceMetadataLocationOrIconSetClause" )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     setReferenceMetadataLocationOrIconSetClause =  ( 
          "setReferenceMetadataLocationClause" [ SET "setReferenceIconSetClause"
           ] | "setReferenceIconSetClause" )
     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

Parameters

alterMapModuleCommand

This command modifies an existing mapping module.

QUOTED_STRING

Name of the existing mapping module in single quotes.

renameClause

Rename a mapping module.

alterPropertiesOrReferenceOrJCTClauseForDataMetadataModule

Set properties and/or metadata location and/or icon set and/or journal code template for the mapping module.

addOrRemoveOrModifyModuleReferenceLocationClause

Add/remove/modify data location for the mapping module.

alterPropertiesOrReferenceClauseForDataMetadataModule

Set properties and/or metadata location for the mapping module.

addReferenceLocationClause

Add a data location to the mapping module.

removeReferenceLocationClause

Remove a data location from the mapping module.

modifyReferenceLocationClause

Modify a data location of the mapping module.

alterPropertiesClause

Set the properties for the mapping module.

getPropertiesClause

Basic properties for MAPPING_MODULE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of the mapping module.

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the mapping module.

setReferenceClauseForDataMetadataModule

Set location and/or icon set for the mapping module.

unsetReferenceClauseForDataMetadataModule

Unset location and/or icon set for the mapping module.

propertyValueList

The values for the named properties.

propertyNameList

The names of the properties whose values you want to set.

setReferenceLocationClause

Set a data location to the existing mapping module as the new configuration default.

setReferenceMetadataLocationOrIconSetOrJCTClause

Set metadata location and/or icon set and/or journal code template for the mapping module.

unsetReferenceLocationClause

Unset a data location to the existing mapping module.

unsetReferenceMetadataLocationOrIconSetOrJCTClause

Unset metadata location and/or icon set and/or journal code template for the mapping module.

propertyValue

A property value.

setReferenceMetadataLocationOrIconSetClause

Set metadata location and/or icon set for the mapping module.

unsetReferenceMetadataLocationOrIconSetClause

Unset metadata location and/or icon set for the mapping module.

setReferenceMetadataLocationClause

Set metadata location for the mapping module.

setReferenceIconSetClause

Set icon set for the mapping module.

unsetReferenceMetadataLocationClause

Unset metadata location for the mapping module.

unsetReferenceIconSetClause

Unset icon set for the mapping module.

MAPPING_MODULE Object

Table 3-49 MAPPING_MODULE Object

Property	Type	Choices	Min	Max	Default	Description
ABAP_DIRECTORY	STRING	none	none	none	abap\	Location where SAP data is dumped as flat files
ABAP_EXTENSION	STRING	none	none	none	.abap	File name extension for ABAP scripts
ABAP_RUN_PARAMETER_FILE	STRING	none	none	none	_run.ini	Run Parameter File Suffix for the parameter script in a ABAP job.
ABAP_SPOOL_DIRECTORY	STRING	none	none	none	abap\log\	Location where ABAP scripts are buffered during script generation processing.
APPLICATION_SHORT_NAME	STRING	none	none	none	WB	Application Short Name
ARCHIVE_DIRECTORY	STRING	none	none	none	archive\	Archive Directory
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.
DDL_DIRECTORY	STRING	none	none	none	ddl\	Location where scripts for database objects for the target schema are stored.
DDL_EXTENSION	STRING	none	none	none	.ddl	File name extension for DDL scripts.
DDL_SPOOL_DIRECTORY	STRING	none	none	none	ddl\log\	Location where DDL scripts are buffered during script generation processing.
DEFAULT_INDEX_TABLESPACE	STRING(30)	none	none	none	empty string	Default name of tablespace to install indexes into.
DEFAULT_OBJECT_TABLESPACE	STRING(30)	none	none	none	empty string	Default name of tablespace to install objects into.
DEPLOYABLE	BOOLEAN	true, false	none	none	true	Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
DESIGNER_CONTAINER_ELEMENT	STRING	none	none	none	empty string
END_OF_LINE	STRING	none	none	none	\r\n	End of Line
INPUT_DIRECTORY	STRING	none	none	none	input\	Input Directory
INVALID_DIRECTORY	STRING	none	none	none	invalid\	Directory for SQL*Loader errors and rejected records
LIB_DIRECTORY	STRING	none	none	none	lib\	LIB Directory
LIB_EXTENSION	STRING	none	none	none	.lib	LIB Extension
LIB_SPOOL_DIRECTORY	STRING	none	none	none	lib\log\	LIB Spool Directory
LOADER_DIRECTORY	STRING	none	none	none	ctl\	Location where control files are stored.
LOADER_EXTENSION	STRING	none	none	none	.ctl	Suffix for the loader scripts
LOADER_RUN_PARAMETER_FILE	STRING	none	none	none	_run.ini	Suffix for the parameter initialization file.
LOG_DIRECTORY	STRING	none	none	none	log\	Log Directory for the SQL*Loader
MAIN_APPLICATION_SHORT_NAME	STRING	none	none	none	ora	Main Application Short Name
PLSQL_DIRECTORY	STRING	none	none	none	pls\	Location where PL/SQL scripts are stored.
PLSQL_EXTENSION	STRING	none	none	none	.pls
PLSQL_GENERATION_MODE	STRING	Default, Oracle10g, Oracle10gR2, Oracle11gR1, Oracle11gR2, Oracle8i, Oracle9i	none	none	Default	Generation mode controls validation and generation for version specific features.
PLSQL_RUN_PARAMETER_FILE	STRING	none	none	none	_run.ini	Suffix for the parameter script in a PL/SQL job.
PLSQL_SPOOL_DIRECTORY	STRING	none	none	none	pls\log\	Location where PL/SQL scripts are buffered during script generation processing.
RECEIVE_DIRECTORY	STRING	none	none	none	receive\	Receive Directory
SORT_DIRECTORY	STRING	none	none	none	sort\	Sort Directory
SQLPLUS_DIRECTORY	STRING	none	none	none	sqlplus\	Location where SQLPLUS scripts are stored
SQLPLUS_EXTENSION	STRING	none	none	none	.sql	Suffix for the SqlPlus scripts
SQLPLUS_RUN_PARAMETER_FILE	STRING	none	none	none	_run.ini	Suffix for the parameter initialization file
STREAMS_ADMINISTRATOR_LOCATION	STRING	none	none	none	empty string	The location corresponding to the Streams Administrator
TCL_DIRECTORY	STRING	none	none	none	tcl\	Location for TCL scripts that are generated after registration with Oracle Enterprise Manager
TOP_DIRECTORY	STRING	none	none	none	..\..\codegen\	Top Directory where generated code will get stored
WORK_DIRECTORY	STRING	none	none	none	work\	Work Directory