Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBALTER PLATFORM

Purpose

Alters a platform, allowing the properties and platform content to be changed. Use this to add or remove data types, change or add type mappings to and from the core platform.

Prerequisites

Should be in the context of a project, before altering a platform.

Syntax

alterPlatformCommand =  OMBALTER ( PLATFORM "QUOTED_STRING" ( [ 
          "renameClause" ] [ SET "setPropertiesClause" ] ( { 
          "addPlatformTypeClause" } ) ( { "addFromPlatformTypeMapClause" } ) ( {
           "addToPlatformTypeMapClause" } ) ( { "modifyPlatformTypeClause" } ) (
           { "modifyFromPlatformTypeMapClause" } ) ( { 
          "modifyToPlatformTypeMapClause" } ) ( { "removePlatformTypeClause" } )
           ( { "removeFromPlatformTypeMapClause" } ) ( { 
          "removeToPlatformTypeMapClause" } ) [ SET "setMIVForPlatformClause" ] 
          [ UNSET "unsetMIVForPlatformClause" ] [ SET 
          "setDefaultKMForPlatformClause" ] [ UNSET 
          "unsetDefaultKMForPlatformClause" ] ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     addPlatformTypeClause =  ADD ( PLATFORM_TYPE "QUOTED_STRING" [ SET 
          "setPropertiesClause" ] )
     addFromPlatformTypeMapClause =  ADD ( FROM_PLATFORM_TYPEMAP "QUOTED_STRING"
           [ SET "setPropertiesClause" ] )
     addToPlatformTypeMapClause =  ADD ( TO_PLATFORM_TYPEMAP "QUOTED_STRING" [ 
          SET "setPropertiesClause" ] )
     modifyPlatformTypeClause =  MODIFY ( PLATFORM_TYPE "QUOTED_STRING" [ SET 
          "setPropertiesClause" ] )
     modifyFromPlatformTypeMapClause =  MODIFY ( FROM_PLATFORM_TYPEMAP 
          "QUOTED_STRING" [ SET "setPropertiesClause" ] )
     modifyToPlatformTypeMapClause =  MODIFY ( TO_PLATFORM_TYPEMAP 
          "QUOTED_STRING" [ SET "setPropertiesClause" ] )
     removePlatformTypeClause =  REMOVE ( PLATFORM_TYPE "QUOTED_STRING" )
     removeFromPlatformTypeMapClause =  REMOVE ( FROM_PLATFORM_TYPEMAP 
          "QUOTED_STRING" )
     removeToPlatformTypeMapClause =  REMOVE ( TO_PLATFORM_TYPEMAP 
          "QUOTED_STRING" )
     setMIVForPlatformClause =  ( ( REF | REFERENCE ) CMI_DEFINITION 
          "QUOTED_STRING" )
     unsetMIVForPlatformClause =  ( ( REF | REFERENCE ) CMI_DEFINITION )
     setDefaultKMForPlatformClause =  ( DEFAULT_LOAD_CT "kmName" FOR PROJECT 
          "projectName" FOR SOURCE_PLATFORM "platformName" | 
          DEFAULT_INTEGRATION_CT "kmName" FOR PROJECT "projectName" | 
          DEFAULT_ORACLE_TARGET_CT "kmName" FOR PROJECT "projectName" )
     unsetDefaultKMForPlatformClause =  ( DEFAULT_LOAD_CT FOR PROJECT 
          "projectName" FOR SOURCE_PLATFORM "platformName" | 
          DEFAULT_INTEGRATION_CT FOR PROJECT "projectName" | 
          DEFAULT_ORACLE_TARGET_CT FOR PROJECT "projectName" )
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     kmName =  "QUOTED_STRING"
     projectName =  "QUOTED_STRING"
     platformName =  "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterPlatformCommand

Alter a platform definition in the repository.

renameClause

Rename the platform definitions.

setPropertiesClause

Set the characteristics of the platform, this includes the driver class for connecting to the system and default connection string.

platformTypeProperties

Basic properties for PLATFORM: 

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

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

platformTypeProperties

Properties for PLATFORM:
Name: COL_ALIAS_WORD
Type: STRING
Column alias word.

Name: DATE_FCT
Type: STRING
The function allowing the date and time to be returned - for example in Oracle this would by SYSDATE and DB2 UDB would be CURRENT TIMESTAMP

Name: DATE_MASK
Type: STRING
The syntax to be used to describe the Date datatype in DDL, for example in Oracle may be DATE in DB2 UDB TIMESTAMP.

Name: DDLNULL
Type: STRING
The word used to describe a column that can contain empty (null) values. For example in Oracle NULL is used.

Name: DEFAULT_MAX_NAME_LEN
Type: INTEGER
The default max length name of a relational access item (ie. a table).

Name: DEFAULT_NAME_LEN_SEMANTICS
Type: STRING
The name length semantics to be used (CHARACTER or BYTE).

Name: DELETE_IN_OVERRIDE
Type: BOOLEAN
Delete in override property

Name: DRIVER_CLASS
Type: STRING
The driver class name, all locations created for this platform will be created using this driver class.

Name: ENCLOSURE_CHAR
Type: STRING
The character used to delimit names ie. single quote, double quote etc.

Name: ESCAPE_CHAR
Type: STRING
Escape character.

Name: ILLEGAL_CHARS
Type: STRING
The list of illegal characters that can be in a name.

Name: ILLEGAL_LEADING_CHARS
Type: STRING
The list of illegal characters that a name can start with.

Name: LOCAL_OBJECT_MASK
Type: STRING
This determines how an object is named when you are connected to the location the object is based on. For Oracle this should be 
%SCHEMA.%OBJECT The list of tags available for the mask include;
%CATALOG to represent the physical catalog name
%SCHEMA to represent the schema name
%OBJECT to represent the object name

Name: NUMERIC_MASK
Type: STRING
The syntax to be used to describe the Numerical datatype in DDL, the tags %L (data length) and %P (precision) can be used.

Name: REMOTE_OBJECT_MASK
Type: STRING
This determines how an object is named when you are not connected to the location the object is based on. For Oracle this should be 
%SCHEMA.%OBJECT The list of tags available for the mask include;
%CATALOG to represent the physical catalog name
%SCHEMA to represent the schema name
%OBJECT to represent the object name
%DSERVER to represent the data server

Name: RESERVED_WORDS
Type: STRING
The list of reserved words which cannot be used for names of objects.

Name: SEEDED
Type: BOOLEAN
A flag to indicate if the platform was seeded.

Name: SPECIAL_MAX_NAME_LEN
Type: STRING
Name length for secondary objects such as column, index (the value has the following format INDEX=18:COLUMN=30:PACKAGE=18)

Name: SPECIAL_NAME_LEN_SEMANTICS
Type: STRING
SpecialNameLenSemantics

Name: TAB_ALIAS_WORD
Type: STRING
The element designed to separate a table name from its alias in a SQL FROM clause. This element may be left incomplete.

Name: URI_TEMPLATE
Type: STRING
A sample template URI for accessing the platform.

Name: VARCHAR_MASK
Type: STRING
The syntax to be used to describe the String datatype in DDL, the tags %L (data length) and %P (precision) can be used.

platformTypeProperties

Properties for PLATFORM_TYPE:
Name: IS_DEFAULT
Type: BOOLEAN
Is this the default datatype for the platform.

Name: P1
Type: STRING
Parameter from the following list (leave blank if not applicable);
size: for length
precision: for numbers
scale: for numbers

Name: P1DEFAULT
Type: STRING
Default value for P1; leave blank if not applicable

Name: P1MAX
Type: STRING
Maximum value for P1; leave blank if not applicable

Name: P1MIN
Type: STRING
Minimum value for P1; leave blank if not applicable

Name: P1TYPE
Type: STRING
Parameter type from the following supported list (Leave blank if not applicable): range

Name: SEEDED
Type: BOOLEAN
Seeded indicator for the platform types which are pre-seeded.

Name: SYNTAX
Type: STRING
DDL Syntax for columns of this data type, can use %size %precision %scale. For example CHAR(%size) is the syntax for defining a data type of CHAR which has a particular length

addPlatformTypeClause

Add a type to the platform definition.

addFromPlatformTypeMapClause

Add a mapping from this type to a generic type.

addToPlatformTypeMapClause

Add a mapping from a generic type to the platform type.

modifyPlatformTypeClause

Modify a type definition.

modifyFromPlatformTypeMapClause

Modify a mapping from this type to a generic type.

modifyToPlatformTypeMapClause

Modify a mapping from a generic type to the platform type.

removePlatformTypeClause

Remove a type from the platform definition.

removeFromPlatformTypeMapClause

Remove a mapping from this type to a generic type.

removeToPlatformTypeMapClause

Remove a mapping from a generic type to the platform type.

setMIVForPlatformClause

Set the CMI Definition for this platform. This optional class lets custom metadata import objects be defined to override the use of the JDBC metadata import for example.

unsetMIVForPlatformClause

Unset the CMI Definition for ths removes the custom import and reverts to the JDBC metadata import for example.

setDefaultKMForPlatformClause

Set the default CT for this platform.

unsetDefaultKMForPlatformClause

Unset the default CT for this platform.

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

kmName

The CT physical name.

projectName

The name for this project.

platformName

The name for this platform definition.

propertyValue

Value of a property.