Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Oct 2002 @ 22:45:02 GMT


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


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

++++++++++++++++++



     
  <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: 15 Jun 2023