Archives of the TeradataForum

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

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

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