Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 01 Nov 2002 @ 19:13:17 GMT


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


Subj:   Re: Help in fast Export script
 
From:   Reddy, Ponnolu

Hi,

Thanx a lot for u r help...
I have few more questions embedded below.....
sorry for asking simple questions..
Actually I worked in NCR in Teradata developement side...
I worked in PDE module...I was involved porting of PDE
from windows to Solaris...
I don't have much knodledge of Teradata Client
utilities......

following are my questions.........

   .LOGTABLE I06_DailyItemTotals_FLOG;
   .RUN FILE ..\secure\loginssa.sql;

   .SYSTEM 'DEL C:\Teradata\Scripts1025\emp9\emp9.dat';

   .BEGIN EXPORT SESSIONS 20 5;
   .EXPORT OUTFILE C:\Teradata\Scripts1025\emp9\emp9.dat
    MODE RECORD
    FORMAT TEXT;

   select CAST (Name as CHAR(20)),
          CAST ((Phone (FORMAT '999-999-9999')) as CHAR(12)),
          CAST (Location as CHAR(10))
     from Emp9;

   .END EXPORT ;

   .logoff;
   .quit ;

Agter running above Script, I am getting following timestamps in my script file....from where it is getting......

12:36 PM 11/1/2002

1:08 PM 11/1/2002

   .LOGTABLE Logtable_EMP9;

   .RUN FILE ..\secure\loginssa.sql;
   .BEGIN IMPORT MLOAD
    TABLES EMP9
        WORKTABLES  WT_EMP9
        ERRORTABLES ET_EMP9
                    UV_EMP9
        ERRLIMIT 50
        AMPCHECK ALL;

What is the Meaning of AMPCHECK ALL?

   .LAYOUT INPUTLAYOUT;

   .FIELD  IN_Name        * CHAR(20);
   .FIELD  IN_Phone       * CHAR(12);
   .FIELD  IN_LOCATION    * CHAR(10);
   .FILLER                * CHAR(2);
       /*needed for Carriage Return/Linefeed */

I am running on windows 2000...
what FILLER will do?
Actually i am inserting one blank line at the endof inputdata file

   .DML LABEL INSERTS
   IGNORE DUPLICATE INSERT ROWS;

Does it ignore any duplicate rows in our input file?



     
  <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