13 Replies Latest reply: May 22, 2009 6:50 PM by danhilz RSS

    Specific fields causing 1% of rows to not load in a SQL Select QVD load

      In the Sql select load statement below, if I uncomment "PART_NO,
      800+ fewer rows out of 180,000 are found. Does anyone else have this sort of problem where
      certain fields are causing a few rows to not load?
      Does anyone have any suggestions for troubleshooting or correcting incomplete SQL loads?

       

       

      OrderLines:

      LOAD

      //"PART_NO" AS OrderLines_ItemNbr,

      "MCODE" AS OrderLines_MfgCode,

      "ORDER_NO" AS OrderLines_OrderNbr,

      "LINE" AS OrderLines_OrderLineNbr

      SQL SELECT

      //"PART_NO",

      "MCODE",

      "ORDER_NO",

      "LINE"

      FROM "ORDER_LINE";

      STORE OrderLines INTO [UV_OrderLines.qvd];