You would like to explore the Zend Server databases, or perform an edit when asked by Zend Support.
Zend Server for IBM i 9.1.x, 2018.0.x, 2019.0.x or higher running on any supported version of IBM i.
Here are two free SQLite editors that can be used with the Zend Server databases. The first runs on your Windows PC, and can be used if you have a network drive set up to access your IBM i. The second can be used from a web browser.
DB Browser for SQLite (formerly SQLite Database Browser) is a simple SQLite manager that is easy to use and free to download. The windows download can be found here:
To install this in Windows, just download and run the .exe file. To open a database, navigate to the /usr/local/zendphp7/var/db directory and choose one of the files with a .db extension. Before making any changes to any of these files, make a back up copy.
phpLiteAdmin is a PHP script that provides a SQLite management GUI in a web browser. You can find the download here:
There are some installation instructions here:
To use phpLiteAdmin with the Zend Server databases, probably the simplest thing to do is to download the software and unzip it on your PC. The entire software consists of a single phpLiteAdmin.php file. There is an optional configuration file, or you can make your configuration changes right in the phpLiteAdmin.php file.
To configure, find these two lines of code:
Change the password to anything you like. Change the directory to the Zend Server databases directory:
Save your changes, then upload the phpLiteAdmin.php file (and the configuration file if you used it) to your web site. You can then run the phpLiteAdmin.php script on your website to work with the Zend Server databases. Remember to back up any database files before making any changes.