0 Replies Latest reply on Apr 20, 2007 1:37 AM by 3004

    Db2 Update Failed at the 6th Occurrence

      <p>We have a program that updates a Db2 table and always fails atthe sixth element of an array.  </p><p> </p><p>The new data is loaded into an array from a different procedure.When it comes to the update procedure, it loops through that arrayand do an update on a table.  We tried to startthe update from an occurrence other than 1, it still fails at thesixth occurrence.</p><p> </p><p>The Db2 column has a VARCHAR(120) data type and the new value is32 characters only.</p><p> </p><p>Any input will be appreciated. I suspect that there is a buffersetting in Hyperion that limits that number of updates. Anythoughts? Let me know if you need more information.</p><p> </p><p>thank you.</p>