Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Dec 2009 @ 10:18:19 GMT


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


Subj:   Re: File truncation issue with BTEQ data export
 
From:   Chandana Oak

Mohommod.Khan wrote:

  It is difficult to provide a solution without knowing what script you are running and what platform and how you are running etc.  


  ...  


  As you are saying below about chopping off the record, ensure you set a Width statement some thing like this:  


Hi,

I am using BTEQ on Windows platform.

Also, even if I set the width to 3000 (even though the max record length is not more than 1000), I am facing this issue.

This is the script that I am running -

     .export Report file = <>

          .set titledashes off
          .set heading ''
          .set width 3000
          .set format off

          /* TAB DELIMITED. CHANGE TO DIFFERENT DELIMITER AS DESIRED */
         .set separator '|'

          SELECT
              TRIM(FIRST_NM),
              TRIM(LAST_NM),
              TRIM(COUNTRY)
          FROM <>
          <>;

        .export reset



The estimated no. of records to be exported are 80,000.


Thanks,

Chandana



     
  <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