Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Dec 2009 @ 15:35:01 GMT

  <Prev Next>  
Next> Last>>  

Subj:   BTEQ - import export
From:   Rahul Shashidhar Phadnis


I want to

1. Export a file using bteq

2. Should be in a position to view that exported file (hence using FILE/REPORT FILE option).

3. Import the same using bteq

The following fails inserting junk data.

     Tab1,tab2 are tables with 2 columns (col1 integer,col2 integer).

If I use datafile instead of file(vartext) the script runs without any errors. But in that case I will not be able to view the exported file hence trying with FILE/REPORT FILE.

Anybody can suggest what is the problem ?

     .Set Echoreq off
     .Set Titledashes off
     .Set Separator '|' ALL
     .Set Format off
     .set titledashes off;
     .OS rm data1.txt
     .export FILE=data1.txt
     select col1(title ''),col2(title '') from gautars.tp1; .export reset .quit;

     .logon.import VARTEXT '|' file=data1.txt .quiet on .REPEAT * using(a int, b int) insert
     into gautars.tp2(col1,col2) values (:a,:b); .quit;



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023