1 Reply Latest reply: Nov 17, 2012 8:24 AM by Mark D Powell RSS

    Control File seems to be excluding records

    958603
      Hi,
      I have a control file:
      OPTIONS (SKIP=1)
      LOAD data
      CONTINUEIF LAST != "|"
      INTO TABLE load_ash_lnids
      TRUNCATE
      FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
      TRAILING NULLCOLS
      (
      REPORT_DT date "DD/MM/YYYY" ,
      DEMAND_NO,
      ORIGINATOR,
      SUBMITTED_DATE date "DD/MM/YYYY",
      RDD_DATE date "DD/MM/YYYY",
      DEM_TYPE,
      NSN,
      ITEM_NAME CHAR(200),
      QTY_REQ,
      EDD_DESTINATION_DATE date "DD/MM/YYYY",
      REQUISITION,
      AC,
      RAA,
      SIO,
      COMMENTS CHAR(4000) "replace(:COMMENTS,'\\n',chr(10))",
      PART_NO,
      CAMM2_NO
      )

      But it is randomly skipping random records. Although if then load the records that did load, they load (had to keep doing this, as each time recordes still weren't loaded. There was meant to be 128 records, but only 111 were loading. No errors occured.

      Can anybody see what I could be missing?

      pip "|" delimited .csv is the source file format.

      Thanks

      Edited by: jamjcam on Nov 16, 2012 1:14 PM
        • 1. Re: Control File seems to be excluding records
          Mark D Powell
          jamjcam, without a sample input file that reproduces the behavior in question you have left forum readers with no real choice but to guess at the issue. My guess is that your data does not properly match to your CONTINIEIF condition where the file lines are to be conbined into a single row of data.

          What is the full Oracle version?

          HTH -- Mark D Powell --