Second Derivative Community Forum

If you are trying to update files on the AS400 or iSeries from your web application, you HAVE TO first journal the files on the iSeries/AS400. Here are instructions on how to do that through the Operations Navigator. Then your web application should be fine for updating.

Here is a document that includes screen prints and should help:
http://www.randrinc.com/2d_randr/files/Updating_files_on_the_iSeries_from_the_Web.pdf

1. Open Operations Navigator, select Database, Schema ,then right click and select Schemas to display.

2. Enter library names and press Add or search. When the libraries you want are in the Selected Schemas on the right, click OK.

3. You should now see your libraries under Selected Schemas

4. Right click on the Library and select New, and then Journal

5. Here I am creating journal QSQLJRN in library (schema) anntest and the journal receiver is also to be in anntest. Be sure to Click Advanced.

6. Under Advanced, be sure to check Delete Receivers when no longer needed. Otherwise, they will just remain and start taking up disk space. You can come back and check this later if you have to.

7. If I click on the New Receiver button you will get. I always accept the defaults, but you can make the storage smaller. When it reaches this size, it will start a new receiver and delete the prior (if you checked that option). Now click ok on all screens.

8. Here are all the objects in my library (Anntest) there is a file, the journal we created and the journal receiver.

9. One last step, we have to right click on the file we want to be able to modify over the web and journal it.

10. Enter the name of the journal file and the library or you can browse and select it.
Click Start and the iSeries/AS400 will start journaling the file. Now you can update this file from your web program.

11. If I right click on the file and select journaling. I can see that the file is being journaled. Click end to end the journaling.
[i]