Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 25 Apr 2002 @ 13:42:18 GMT


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


Subj:   Re: Question IMPORT BTEQ
 
From:   Edmond Ray

Rudel,

Replies are below.

Ed Ray


  -----Original Message-----
From: Rudel Simard
Sent: Thursday, April 25, 2002 7:20 AM
Subject: Question IMPORT BTEQ
 


  1- question  


  With bteqwin, we run a script :  


DATABASE P_A1GOC;
.EXPORT DATA FILE = 'DATA1.TXT'
SELECT NO_ECRIVAIN,
             NO_LIBRAIRIE,
             NBRE_LIVRES,
             NOM,
             PREN,
             DAT_SORTIE,
             NO_LIBRAIRIE
   FROM AUTEUR;
.EXPORT RESET

  We send the file data1.txt to the mainframe by FTP. This is a fixed length record.  


  Can We import the file from the Mainframe with BTEQ in batch mode?  


Yes.


  2-question : bteq import/export
When we run a bteq export on the mainframe (export DATA). We transfer the on the PC by FTP. Can we import this file with BTEQWIN (EXPORT DATA)?
 


Maybe, some numeric formats are stored differently on different platforms. It would be better to perform the IMPORT DATA on the mainframe or perform both the EXPORT and the IMPORT on the PC.


  3-question
We work with bteqwin and we use EXPORT REPORT and produce a file. Can we import the report file?
 


Yes you can import this file, but you will have to read all of the columns as characters and convert them back to the desired format. It would be much better to EXPORT DATA if you plan on importing the data later. If you need the data in a readable form you could do the EXPORT REPORT and then EXPORT DATA with the same SQL to different files. Then if you needed to import the data you could without problems.


Rudel Simard
Régie de l'assurance-maladie du Québec
DBA de l'environnement informationnel



     
  <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: 28 Jun 2020