Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 10 Jul 2008 @ 14:48:22 GMT


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


Subj:   Re: Queryman Import Bug
 
From:   Dempsey, Mike

I tried this test (inserting your string plus others > and < 18 characters) and saw no problem.

Check the Export/Import tab of the Options screen to make sure the option 'None' is selected for 'Enclose column data in:'. If this is set to Single or Double Quotes then it WILL remove the first and last character, since it expects these to be the quotes.

The length of the string should have no bearing on whether it removes the first and last character however. (Is your input data mixed - some quoted and some not?)

(I ran the test with SQL Assistant 12.0 since you did not mention the version you are using, but I don't think 7.2 will be any different.)


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: 28 Jun 2020