Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Apr 2005 @ 09:35:59 GMT


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


Subj:   Export data to flat file using bteq
 
From:   Dhanraj Palani

Hi,

I am using bteq for creating flat files which in turn are used by some application. Following is what i am doing. Please suggest if the approach is right or i need anything else to do.

     .LOGON testdsn/dbc,dbc
     .SET FORMAT OFF
     .SET NULL AS ''
     .SET SEPARATOR 0
     .OS del emp.dat
     .EXPORT REPORT file=emp.dat
     SELECT empno (title ''), ename(title '') FROM emp;
     .EXPORT RESET

Regards,

Dhanraj P



     
  <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