Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Dictionaries
  10. User-Defined Datatypes

Datatype Conversion Parameters

Datatype Conversion Parameters

The properties file uses parameters to define how the PowerCenter Integration Service converts user-defined datatypes.
The datatype conversion parameters in the properties file must be in the following format:
UDTname=Datatype;Precision;SourceSQLFunction;TargetSQLFunction
The following table describes the parameters in the properties file:
Parameter
Description
UDTName
Name of the user-defined datatype used in the data source or target.
Datatype
Datatype to which the user-defined datatype is converted in PowerCenter.
Precision
Precision of the data after conversion.
SourceSQLFunction
SQL function used to convert the user-defined datatype in the data source to the datatype in PowerCenter. The source database must support the SQL function. The SQL functions that you can use depend on the database type of the data source.
TargetSQLFunction
SQL function used to convert the datatype in PowerCenter to the user-defined datatype in the target. The target database must support the SQL function. The SQL functions that you can use depend on the database type of the target.
The following example shows the datatype conversion parameters defined in a user-defined datatype properties file:
AMV_AQ_MSG_OBJECT_TYPE=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_AMVAQMSGOBJECTTYPE(%port%) AQ$_JMS_TEXT_MESSAGE=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_AQ$JMSTEXTMESSAGE(%port%) AQ$_SIG_PROP=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_AQ$SIGPROP(%port%) AR_REV_REC_TYP=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_ARREVRECTYP(%port%) ASO_ORDER_FEEDBACK_TYPE=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_ASOORDERFEEDBACKTYPE(%port%) CACHESYNC_MESSAGE=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_CACHESYNCMESSAGE(%port%) XNP_MESSAGE_TYPE=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();CX_XNPMESSAGETYPE(%port%) ROWID=varchar;255;ROWIDTOCHAR(%port%);CHARTOROWID(%port%) TIMESTAMP(6)=varchar;255;to_char(%port%,'dd/mm/yyyy hh24:mi.ss.ffffff');to_timestamp(%port%, 'dd/mm/yyyy hh24:mi.ss.ffffff') xmltype=clob;4000;SYS_XMLGEN(%port%).GETCLOBVAL();xmltype(%port%)