4 Replies Latest reply: Feb 18, 2011 3:11 AM by s j RSS

    incremental reload with unique key

      Dear,

      I've a problem with incremental reload for a big table with a complicate KEY from SAP

      this is my script (I use the SapConnector) :

      TABLE:

      load

      field1, field2, field3, field4, field5, field6,

      field7,

      field8 as date,

      field1&field2&field3&field4&field5&field6 as UNIQUEKEY;

      SQL SELECT * FROM TABLE where field7= 'X' or field7= 'Y', not exists(KeyCopa) ; // <---THIS IS THE PROBLEM

      STORE * FROM TABLE INTO TABLE.QVD;ù

       

      can you help me??

       

      thanks