So this is my legacy application program MITMCLAS (Maintain Item Class) I searched for the oldest program I could find and it was originally coded in RPGIII - the first thing I did was Visualize the program using the Visualize Application feature of RDi
I was discussing code coverage recently with a contact of mine, so when I got back to my desk I thought I'd have a look at it and see what it was all about.
With ODBC it is very easy for users to download data from an IBMi database to their PC's bypassing green screen security. If a user has access to a file via a native IBMi application written in a native IBMi language, then they have the ability to download that data to their PC, if there is no exit point security in place.
Following on from the previous post regarding Python and IBMi SQL services, I have updated the application to include a new service regarding Exit Points.
IBMi SQL services are nothing new, IBM are creating more functionality within SQL and DB2 in the next TR.
I have been using open source software to modernize some of our code and it works seamlessly with MDCMS and MDOPEN.
Read more: MDCMS using MDOPEN to Modernize RPGIII to free-format RPG
Before any traffic gets to your IBMi there should be various layers in place, for arguments sake there should be security on all of your connections to the internet - so your hub connecting you to the internet should have as much security and monitoring on it as possible - you should look at these logs very frequently. This hub will protect all the devices configured on your local network.
Some of these examples are built from the IBMi Security Administration and Compliance book and implemented in Enforcive installed on an IBMi.