Administrator Guide

10.4.1
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

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%)

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Datatype Conversion Parameters

Datatype Conversion Parameters