Archives of the TeradataForum

Message Posted: Fri, 06 Jul 2012 @ 12:20:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

There's been other discussions on this recently, but the method we use is to invoke and Access Module (which you may know is an external program) as part of our FastLoad scripts.

The name itself is 'cp2uni_axm.so' and we invoke it like this :

     " ...
     begin loading CORCOW01
     ErrorFiles $ENV$UTIL_DB.CORCOT01_ERR1,
                $ENV$UTIL_DB.CORCOT01_ERR2;

     SET RECORD VARTEXT "^_";

     axsmod /accessmodels/cp2uni_axm.so "CodePage=UTF8, ErrorChar=U+003F, EOR=0A,
     Format=FIXED";

     DEFINE
     CON_ID  (VARCHAR(255))
      CON_DELETE_IN  (VARCHAR(255))
      CON_ADD_TD     (VARCHAR(255))
      CON_ADD_USER_ID        (VARCHAR(255))
     ....."

In our case, the special characters are translated into a question mark.

Hope that helps.

Regards

David Clough

	<Prev	Next>		<<First	<Prev	Next>	Last>>