Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 17:18:06 GMT


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


Subj:   Re: Reading FastLoad Error files
 
From:   Dempsey, Mike

If you have SQL Assistant 6.2 you can use the last text box on the AnswerSet tab of the option screen to tell the application to treat byte columns greater than a specified size as BLOBs. (By default it will handle all Byte columns larger than 30 bytes in this way.)

When it treats a byte column as a blob it writes a file for each row/column. The data will be an exact binary image of what was in the column. You can then use an editor like notepad to view the file. (This will only really be useful if the byte column actually contains a mixture of text and 'encoded' data. I don't remember what it does contain however.)


Mike Dempsey
Teradata Client Tools



     
  <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: 27 Dec 2016