Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 12 Jul 2004 @ 13:26:41 GMT

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

Subj:   Re: Windows-based Fast Export Script
From:   Geoffrey Rommel

  I need to get rid of the 'Small Square followed by space' from the beginning and end of every field.  

Your query includes character literals as separate fields. These are varchar and therefore preceded by smallint length fields, which are the odd characters you have noticed. For instance:

     SEL NPANXXX          (FORMAT '9999999999') (CHAR(10))
           , ','
           , OWNER_MARKET_ID  (FORMAT '9999999999')  (CHAR(10))

In the query above, the comma (varchar) will be preceded by a binary length of 1 (x'0001' or x'0100', depending on the platform). Others have already suggested ways around this problem.

  <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