Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: OREPLACE : Special Characters
 
From:   David Clough

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023