Problem solve Get help with specific problems with your technologies, process and projects.

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 last published in July 2001

Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.