Archives of the TeradataForum
Message Posted: Thu, 25 Apr 2002 @ 13:42:18 GMT
| Subj: || || Re: Question IMPORT BTEQ |
| From: || || Edmond Ray |
Replies are below.
| || -----Original Message-----|
From: Rudel Simard
Sent: Thursday, April 25, 2002 7:20 AM
Subject: Question IMPORT BTEQ
| ||With bteqwin, we run a script :|| |
.EXPORT DATA FILE = 'DATA1.TXT'
| ||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?|| |
| ||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
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.
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.
Régie de l'assurance-maladie du Québec
DBA de l'environnement informationnel