Ask the Expert

ODBC updates to AS/400 files

I have a Lotus Notes application that has to access a DB2 database located in an AS/400 server via ODBC (using 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.

This was first published in July 2001

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: