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

Attachments

Library

Quick Reference