3 Replies Latest reply: Feb 7, 2013 5:41 PM by 989623 RSS

    sql loader problem

    989623
      Hi,

      i have a problem with sql loader
      i want to load dates in a field and route bad formats to bad file i use the following control file:

      LOAD DATA
      CHARACTERSET UTF8
      INFILE 'x.tsv'
      APPEND
      INTO TABLE temp_x
      FIELDS TERMINATED BY X'9'
      TRAILING NULLCOLS
      (
      x_date date "DD-MON-YY"
      )


      the problem is that it loads also '08-JUL-1' but i want to reject this record so allow only this format DD-MON-YY and reject this DD-MON-Y

      any ideas? i havent get more...

      thanks in advance