Skip to main content

SQL Audit

SQL Audit tracks and monitors modifications made to any IBM iSeries (AS400) database using SQL. Log and monitor database activity including inserts, updates or deletes. If journalling is not active on the system, SQL Audit automatically journals the before and after image of the data updated with SQL. Capture information about who executed the SQL, when it was done, what library/file it was run against and other pertinent information. Using the SQL Audit menu, users can report all this information and use it to tailor their SQL statements and/or report these modifications as required by internal audits or compliance regulations.

Download SQL Audit Today!

SQL Audit Screenshots


Journals can be retrieved by file or by user.


DBU the audit journal to see what happened. The before and after images are displayed with the changes highlighted.

SQL Audit Support
Documentation Compatibility
SQL Protection FAQs

DBUnifier

DBUnifier - unify the ease of DBU applications and the complexity of your development environment. Dynamically build database maintenance applications with field prompting and field/record validation in minutes. Instantly increase productivity and standardize programs. It's the ultimate in the 'code-less' creation of your applications! Simplify the process of creating database maintenance programs NOW! DBUnifier combines: DBUapps + field prompting + field/record validation = Maintenance in Minutes! The solution is easy!

Contact our Customer Support staff to order DBUnifier!

Step 1

DBU your file and unify! Any file on the iSeries can be DBU’ed! DBU will now allow you to unify a DBU maintenance application or select the file from DBUnifier (WRKDBUAPP).

Step 2

Define your initial display. Choose the specific fields you would like listed for your multiple record display (subfile).

Step 3

Design your maintenance screen. Set your initial values, control screen layout, position fields, define field validation rules with relational operators, ranges, list of values or database validity checks

Step 4

Save your DBU application. Select optional exit programs for pre or post processing. Select modes such as inquiry, update, or add/change. Incorporate into your legacy applications through calls, commands and/or menu options. And wha-la, you’ve found the treasure!

Step 5

RUN it! Call your application from any high level language and your customers have access to secure database maintenance in a matter of minutes!

Documentation Compatibility FAQs
Create an Application Applications

CvtRPGIV

CvtRPGIV converts older versions of RPG to the newest release of the programming language. Then work with the new enhancements that make the conversion all worthwhile. CvtRPGIV is a conversion tool only. No attempt is made to correct or change program logic or deficiencies. Only operations that can be safely converted, will be converted. The operation of CvtRPGIV is simple. On a command line, key in the command and prompt. Fill in the necessary parameters and . That's it! Now bring up your source member and admire your new RPGILE program!

Contact our Customer Support staff to order CvtRPGIV!

CvtRPGIV picks up where IBM's CVTRPGSRC leaves off
  • Converts defined calulation fields to the new D specifications
  • ADD, Z-ADD, SUB, Z-SUB, MULT, and DIV are converted to EVAL
  • Operation code and new values to mixed case
  • EQ, NE, GT, LT, GE and LE are converted to the RPGIV operators
  • Convert a single source member or *ALL source members for a given source file
  • Highlight comments in the source file
Documentation Compatibility
FAQs CvtRPGIV Command
Defined Calculations IFxx, WHxx & DOxxx Operations
Move/Eval Operations

NestRPG

NestRPG is used to place nesting information in a source member. A source member can also be nested and printed/partially printed with NestRPG. In addition to the nesting and references, a summary of the location of all references will be printed at the bottom of the list.

A compile listing shows the nesting of all conditional operators on the right hand side of the source listing. NestRPG puts this same information in the source member, saving compiles and compile time. In addition to its nesting feature, NestRPG also tracks the statement number of each BEGSR, EXSR, CAB.., and GOTO tag, etc. This allows the programmer to know exactly where to find them without having to scan.

The operation of NestRPG is simple. On a command line line, key in NestRPG and prompt. Fill in the necessary parameters and . That's all there is to it, bring up your source member and start to work.

Contact our Customer Support staff to order NestRPG!

ProTools

These are tools that we have developed over the years. And you get the source!!!! All the utilities included in ProTools are listed below. You can easily test them, and learn how to use them. ProTools is for V4R2 & above.

Contact our Customer Support staff to order ProTools!

Calculator

for everyone with an editable tape. Perfoms adding machine type functions and recalculates the results when you EDIT the TAPE. Print your results for a permanenct copy.

Zip/Unzip Files

Zip and UnZip Stream Files. Zip/Compress files which then can be opened using PKZIP or JAR. UnZip or uncompress files that have been zipped or compressed using PKZIP or JAR

Send Email Message

send internet mail messages from green screens. This AS/400 command can be executed from a command line, submitted t batch or executed from a batch or interactive program.

Scan Message File

scan and filter messages containing specified phrases, words or partial words. Also allows maintenance of message description.

Sort File

allows you to quickly sort a files. Prompting allows you to select the fields and then order for the resulting sort.

Display Member

display source members on machines without IBM's Application Development Toolkit.

Create MI Program

compiles source members written in MI

Nest CL

Nest CL conditional statements

Save/Restore Library List

save your library list into memory. then restore the saved library list at any later point. Don't worry about changing your library list and trying to rebuild it. Save your library list to memory and restore it when you need to

File-Based Menu System

allows the creation & maintenance of menus. Access to menu options can be authorized by User or Group profile. Single or Multiple commands can be executed from a menu option. No program or display files need to be created wshen changing the menu options.

Send User Break Message

tired of looking up the devices a user profile is signed on at? Send a break message to the device. Just issue the USRBRKMSG command and a break message will be sent to each device the user profile is signed on to

Work with Group Jobs

Start/Stop and Manage Group Jobs. No longer do you have to log on to multiple devices and sessions. Use WRKGRPJOB and start, end and manage group jobs with this easy to use utility

View PC document

view PC text documents in a folder on your AS/400 green screen

Program/File Cross Reference

Do you need to know all the programs that are using a certain file. This utility shows them all

Interrupt Job

uses the system request function to break into interactive jobs and display the command entry screen. Debug commands and breakpoints can be set

User Index Service Program

create, delete and maintain User Indexes with ease. Use our service program to process user indexes. An example program is provided to show you how to use the USRIDX service program

Execute CL Source Member

execute a CL source member without compilation. Create CL source members of multiple commands and job streams you desire to run, then execute EXECLSRC to run them.

Save/Restore Local Data Area

save your Local Data Area into memory. Then restore the saved Local Data Area at any later point

RPGIV Templats

RPGIV Templates include well documented source code for each program. Small development shops can use this entire suite not only to perform the functionality included in the package, but to learn how to write solid RPGIV source code. Basic file maintenance, inquiry, and error-handling programs as well as more complex subfile processing programs allow developers a wide range of RPGIV programming examples. These templates are predefined models that you can either copy or use directly to create standard application programs. All programs have uniform interfaces and require little modification to base functionality.

Contact our Customer Support staff to order RPGIV Templates!

  • FM - File Maintenance Program
  • INQ - Inquiry Program
  • INQ2 - Multiple Screen Inquiry Program
  • PROMPT - Prompt/Validate/Submit Program
  • RPT - Simple Report Program
  • RPTC - Simple Report Prompt/Submit Program
  • RPTQRYC - Perform
  • OPNQRYF - Execute Report Program
  • WINRPTC - Report Prompt/Submit Program
  • SFLSEL - Subfile Selection Program
  • WINDOW - Simple Popup Window
  • PGMSTSDS - Program Status Data Structure Copy Book
  • SFLWIN - Subfile Selection Program
  • SFLDROP - Subfile Selection Program Utilizing Subfile Drop
  • SFLFM - Subfile Maintenance Utilizing Multiple Entry Adds
  • SFLWRK - Subfile Maintenance Utilizing Single Entry Adds
  • WRKSFL - Work with Subfile Process Program
  • WINSFL - Work with Subfile Process Program
  • STANDARDC - Standard CL Program with Error Handling
  • DSPOBJLST - Display Object List (Selection/specific object types)

RPGIV Templates Suport

Documentation

Splf2EML

Convert Spool File to Email (Splf2EML) allows you to convert your simple spooled output to a PDF file and then automatically Email it to a list of up to 15 recipients with the email subject and text included. Pick one spool file or multiple spool files to be merged into one PDF document. The command supports *PRV on all command parms.

NOTE: Email must be configured on iSeries.

Convert Spool File to Email

Splf2HTML

Convert Spool File to HTML Documents (Splf2HTML) allows you to convert your spooled output to an HTML stream file. The HTML document can then be eMailed or viewed directly with a web browser. The command can be executed from a command line or it can be embedded into your application for batch processing.

Convert Spool File to HTML

Splf2PDF

Convert Spool File to PDF Documents (Splf2PDF) allows you to convert your simple spooled output to a PDF file. The PDF document can then be emailed or viewed directly with Adobe Acrobat Reader. The command can be executed from a command line or it can be embedded into your application for batch processing. *AFP, IPDS or graphic output not included

Spool file to PDF