Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 May 2010 @ 10:08:37 GMT


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


Subj:   Re: Fast export issue: log file issue
 
From:   Dmitriy.Boyko

Hi. I've never met such problems before (as I understand export data is writing both in log and data files.

I use this script to unload data from Teradata:

     .LOGTABLE dpm_adm_work.LT20100105102135;
     .LOGON <<>>;
     .BEGIN EXPORT; .EXPORT OUTFILE subs10mil.dat FORMAT TEXT MODE RECORD;


     SELECT cast(subscription_Id as char(20))
       FROM dpvm_adm.v_adm_m_subscription_new
       WHERE month_id = 201002
       QUALIFY ROW_NUMBER() OVER(ORDER BY subscription_id) <= 10000000;

     .END EXPORT;

     .LOGOFF;

By the way - I don't see any log file in your script. Can you, please, send sample for your big log and data files.


Best regards,

Dmitriy Boyko



     
  <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: 23 Jun 2019