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

Adding records to an iSeries file

I'm trying to add records to an iSeries file that I have connected to in Microsoft Access. Every time I try to add a record or update a record in the file, it gives me an error that tells me that this operation is not valid for this file. I've made sure that the file I'm accessing has been defined in the DDS to have the UNIQUE keyword and has a field defined as the key field. I have heard that the commit level has to be at *none. Is that correct? If s, where do I find the commit level?

This is really a commit level issue. It is my suggestion that you not change the commit level when working in client server environment.

In order to be able to allow add operations -- without changing the commit level -- you should journal the updated file on the iSeries database (all files under the same transactions are to be connected to the same journal).

Adding a file to a journal on the iSeries is done by using command STRJRNPF.


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on Physical connections to iSeries

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.