Test Data Management
- Test Data Management 10.5.2
- All Products
UDTname=Datatype;Precision;SourceSQLFunction;TargetSQLFunction
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. |
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%)