3 Replies Latest reply on Jun 30, 2020 7:33 PM by cormaco

    Error loading position based data file using SQL loader due to multi-byte character

    1514361

      I am trying to load a position based (fixed width) data file using SQL loader. However, one field has multi-byte character present because of which the data following this character in the file gets loaded incorrectly into the staging table. While viewing in the file the position of data is correct. However, while loading the data the position of fields get shifted by one position resulting in incorrect load.

       

      Please help me in resolving this issue.

       

      Below is a portion of the control file.

       

      OPTIONS (SKIP=1)

      LOAD DATA

      CHARACTERSET WE8ISO8859P9

      INFILE *

      APPEND INTO TABLE XX.XX_TABLE

      TRAILING NULLCOLS

      (

      FIELD_NAME POSITION(2621:2665) INTEGER EXTERNAL   "TRIM(:FIELD_NAME)"

      )