Archives of the TeradataForum
Message Posted: Thu, 31 Oct 2002 @ 22:45:02 GMT
| Subj: | | Re: Help in fast Export script |
| |
| From: | | Reddy, Ponnolu |
| | Question 1: What format do you wish to have the output file (fixed length text, varying length text, Teradata
fastload[binary])? | |
I think, if we specify FORMAT as TEXT, this is valid only for char type.. what will happen, if we have data in DECIMAL format.....
assume that, in my table i have following columns
name char(20)
phone decimal(12,0) FORMAT '999-999-9999'
location char(10)
How to pull this type of data using fastexprt?
| | Question 2: Why are you doing an IMPORT? Isn't the data already in the emp9 table? | |
Does fast export allows us to import data also? I got follwing sample script from Teradata manual i just tried that one........
++++++++++++++++++
Chapter 1: Overview
A FastExport Example
Teradata FastExport Reference 1 - 13
A FastExport Example
The following FastExport job script example executes a
single SELECT
statement and returns the results to a data set on the
client system:
.LOGTABLE utillog ; /* define restart log */
.LOGON tdpz/user,pswd ; /* DBC logon string */
.BEGIN EXPORT /* specify export function */
SESSIONS 20; /* number of sessions to be used */
.LAYOUT UsingData ; /* define the input data */
.FIELD ProjId * Char(8) ; /* values for the SELECT */
.FIELD WkEnd * Date ; /* constraint clause. */
.IMPORT INFILE ddname1 /* identify the file that */
LAYOUT UsingData ; /* contains the input data */
.EXPORT OUTFILE ddname2 ; /* identify the destination */
/* file for exported data */
SELECT EmpNo, Hours FROM CHARGES /* provide the SQL SELECT */
WHERE WkEnd = :WkEnd /* statement with values */
AND Proj_ID = :ProjId /* provided by the IMPORT */
ORDER BY EmpNo ; /* command */
.END EXPORT ; /* terminate the export */
/* operation */
.LOGOFF ; /* disconnect from the DBS */
++++++++++++++++++
| 
