2 Replies Latest reply: Mar 26, 2013 4:27 PM by Mathias Schreiber RSS

    STORE INTO on a sorted resident table exports unsorted

    Mathias Schreiber

      Hello,

       

      for data conversion I have to export data sorted to a txt-file.

       

      Auftragspos:
      LOAD
        Angebotsnr,
        POSITIONSNR as Position,
      RESIDENT Auftragspos_tmp ORDER BY Angebotsnr,POSITIONSNR;


      Auftragspos2:
      NOCONCATENATE LOAD
          Angebotsnr,
          Position,
      RESIDENT Auftragspos;

       

      STORE Angebotsnr,Position FROM Auftragspos2 INTO $(varOutputPath)Auftragspos.txt (ansi, delimiter is '|');

       

      DROP TABLE Auftragspos

       

      The table viewer show sorted table Auftragspos2 correctly.

      Then I stored this internal table into an external text-file "Auftragspos.txt". When I opening the text-file the lines are not sorted.

       

      Anyone an idea how I can force a sorted export ?