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>>

Attachments

Library

Quick Reference