IBM's SQL is an auditor's worst nightmare. Sure, it's powerful and relatively easy to use. But SQL can also be used to copy, change or delete whole reams of data, which can be done on the fly in relative obscurity. Just what the auditor's don't want!
A superior alternative to IBM's SQL/400!
ProData's SQL/Pro, on the otherhand, is similar in power yet provides controls that auditor's are looking for. SQL/Pro is a software program that takes the complex structure of SQL and breaks it down to a simple English-like language for everyone to understand. Technical and non-technical users alike can implement SQL/Pro to query, print and manipulate data in almost any way imaginable. Add, change, deletes can be protected on a user profile basis, which means authority can be dished out in spoonfuls to only the 'right' users. Taking it one step further, updating records via SQL/Pro can be completely eliminated and changes could be made via ProData's powerful database utility, DBU. The Search & Replace feature within DBU can handle database fixes in a faster and easier manner than SQL!
Auditors love this because DBU Audit journals each and every DBU change to all databases on their iSeries. DBU Audit works by journaling all adds, changes, deletes, reactivation of deleted records and VIEWING of sensitive data made by users thru DBU to a standalone IBM journal. DBU Audit enables administrators to start and stop auditing, monitor access and changes to data, display the audit information and generate reports for SOX or other regulatory compliance mandates.
Click here for more Info ....