Update openquery as400

Per Gunnarsson. Have no problem with updating the way described in the article, exept for performance on large tables. The journal then can be used in recovering a table by either applying activities or removing them. If a table is not journaled, then you only have the backups to recover from.

Lawrence Smith Effectively if journaling is off for the table it is read-only through DB2. In the Performance tab, under the Advanced button, these are the settings:.

I've had to set up 2 different datasources, one for read, and another for write. If anyone else has run into this and solved it, or if there's a version up that's fixed this I'd love to know. You can update the table in as even if Journaling is not turn on , but ony if you are sing ADO recordset object. I do not remember the settings that need to configured for it to work , but I know it's possible. Oleg Oransky. If anyone else has run into this and solved it? Try this :. Sure can, the search engines don't care about the post date.

Tomalak k 64 64 gold badges silver badges bronze badges. Add a comment. Active Oldest Votes. Try listing your fields within the select. If anything to eliminate that as a problem.

Mike Wills Mike Wills Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Hope this will help you. ByteHamster 4, 9 9 gold badges 35 35 silver badges 51 51 bronze badges.

Roushan Kumar Roushan Kumar 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back