UNIX for Beginners Questions & Answers

LOAD DATA
  infile   '  '     #specifies the name of a datafile containing data that you want to load
  BADFILE ' '                              #specifies the name of a file into which rejected records are placed
  BADFILE ' '                              #specifies the name of a file into which discarded records are placed
  APPEND      #to insert data in a nonempty table
  INSERT      #to enter the data into an empty table
  INTO TABLE ts_item_loc_stage_data
  FIELDS TERMINATED BY "|" optionally enclosed by '"'
  TRAILING NULLCOLS 
  (
   Seq_no                    NUMBER(10 ),
   Item                      CHAR(25),
   Loc         			     NUMBER(10),
   Mail_id   		         CHAR(100),
   Status    		         CHAR(1),
   Error_message			 CHAR(255),
   Mail_ind			         CHAR(1)
  );