I have a Lotus Notes application that has to access a DB2 database located in an AS/400 server via ODBC (using...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Lotus Script). I can access all the data I want, but cannot change it, delete it, or insert new records. I've checked the ODBC settings and is everything ok, mainly the access option that permits R/W. What could be wrong?
The problem is probably similar to problems that are common to ODBC updates to AS/400 files.
* the target file (table) on the AS/400 has no unique key.
* The commit level is not *none and the target files on the AS/400 are not journalled, so no update, delete, or insert is allowed.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.