If the charDataToDisk option is enabled, character data will be written to the file system. One typical way to acquire the data in these files is to build a record manipulator that uses the IMPORT_PROP expression to read in the character data. The following is an example of such a record manipulator:

<RECORD_MANIPULATOR FRC_PVAL_IDX="TRUE" NAME="BLOB Manip.">
<RECORD_SOURCE>Records In</RECORD_SOURCE>
<EXPRESSION LABEL="" NAME="IF" TYPE="VOID" URL="">

<COMMENT>if a reference to a CLOB file exists...</COMMENT>
<EXPRESSION LABEL="" NAME="PROP_EXISTS" TYPE="INTEGER" URL="">
	<EXPRNODE NAME="PROP_NAME" VALUE="CLOB_COL_NAME"/>
</EXPRESSION>

<EXPRESSION LABEL="" NAME="IMPORT_PROP" TYPE="VOID" URL="">
<COMMENT>pull in the char data and remove the file</COMMENT>
	<EXPRNODE NAME="PROP_NAME" VALUE="CLOB_COL_NAME"/>
	<EXPRNODE NAME="REMOVE_FILES" VALUE="TRUE"/>
	<EXPRNODE NAME="ENCODING" VALUE="UTF-8"/>
</EXPRESSION>

</EXPRESSION>	
</RECORD_MANIPULATOR>


Copyright © Legal Notices