The broken link has been reported.
iSeries (AS/400) tools (free) and example programs written by fellow AS/400 developers Tips, Techniques, and Articles
Return to list of categories.
- 2 subfiles example
- A simple FTP program for getting iPTF's from IBM.
- AppServer4RPG
- ARP-ZIP (free zip software for the System i, iSeries, AS/400)
- AS/400 SMTP Mail Sender Utility barebones example from IBM
- AS400 / ISERIES boolean operators decimal - binary - hexadecimal table ... biton ... bitoff ... testb
- Automatic Source Archive
- Backup Using Save Files
- Calculator program for AS400 /ISERIES
- CGI_WRKDBF - Open Source CGI to work with database files
- Check number of spooled files in an outq
- CL Database IO Commands
- CL example of an ODBC exit point program that disallows certain users; it is relatively easy to modify to do other items as well.
- Commitment control (STRCMTCTL ENDCMTCTL) in an Interractive RPG job
- Convert RPG to RPG Free tool
- Copy an AS/400 database file to a PC .CSV file for use in Spreadsheet programs like EXCEL By Hideyuki Yahagi
- CPYFRMSPLF - Copy Spooled files - from Code400.com
- Create FTP Script (generic)
- Creating xls spreadsheets using cgidev2
- CRTCSVDTA - Create .csv data by Martin Rowe
- CVT101 - Converting IFS strings
- DB2XTool2 - convert a database file to an IFS stream file, in one of four PC formats.
- DBinfo for iSeries - i5 - AS/400 - Free database display editor
- Display a list of the Database File Locks
- Display File Layout - Replacement for the DSPFFD command.
- DoCmd - This allows you to process the same command across a group of objects.
- Dropdown Box in DSPF example by Booth Martin
- DSPLICINF (Display License Information) command displays a number of system unique values for the IBM System i computer.
- DSPREL Command - Are you having trouble getting in-depth information about your files?
- Dumpster is a freeware utility that dumps the internals of i5/OS spooled files and print resources.
- Dynamic Screen Manager
- E-Police is a collection of iSeries utilities dealing with out-of-line situations.
- Example of generating xml and soap documents with CGIDEV2 on iSeries or AS/400
- Excel workbook that allows you to type in a long string into a large cell, and it justifies it into the D-Spec keyword area, with continuation marks. by Tony Carolla
- Externalize Database Processing in RPG IV (V5R1)
- F.R.O.G. for the IBM iSeries DB2
- Field level encryption and decryption APIs example
- File Upload/Download for iSeries
- Find all versions of a source file
- FNDMSGFT - Find text in message File.
- Format RPG Program - This command is a programmer tool that makes RPG program sources easier to read.
- Format text lines - with limited word wrapping. by Martin Rowe
- Free sftp client that supports ccsid conversions and also supports sending directly from PFs and SAVFs
- Free Utility to Generate Excel Spreadsheets
- FUtil - File Utilities
- Generic File Comparison Utility
- GetiPTF - automate the download of PTF image files from IBM.
- HSSFCGI - A simple way to create Spreadsheets with HSSFR4
- HTMLDOC Utility Converts HTML to PDF
- HTTP API - RPG IV service program that uses socket calls to implement the HTTP 1.1 protocol.
- IBM iSeries / AS/400 - Change To/From Daylight Saving Time
- IDATE is a SQL User Defined Function that takes iSeries dates (really just decimal and characters fields) and converts them to SQL Date Data Type.
- IFS-Procedures
- iSeries (AS/400) based user-maintained FAQ process by Booth Martin
- iSeries freeware/shareware library from search400.com
- iSockets Gets Google by Robert Cozzi, Jr.
- iSockets: The Cool, New, Free Way to Do Web Services
- Kevin Juenemann's Quick Query Utility
- List object locks into a user space by Rick Chevalier
- Log4rpg is a powerful logger for RPG.
- Menu Documentation Tool
- Message Subfile example
- MineSweeper 5250 v.91
- Modifying QDSIGNON and Getting the Message Across
- Monitors the QSYSMSG queue for disabled User profiles
- MOVOUTQ with List Spooled Files (QUSLSPL) API
- NetServer ToolKit
- ODBCLOG - provides a log of users using ODBC type connections to your AS/400 as well as a controlling who is allowed to get in via PC programs such as Microsoft?s EXCEL.
- Open-Source File Encapsulation Utility
- Opening Images in RPG - a way to use a dataque to show a series of images.
- Peek/400 - The ultimate file editor
- Peter K. Levy Programming Tools
- Pop-up Calendar from Booth Martin
- PRGSPLF -- Purge Spooled Files by specified number of days to keep
- Program References Cross Reference Builder
- Program to list installed ciphers
- Progress Bar by Booth Martin
- Purging old spool files
- Push Button in DDS example from Booth Martin
- Record lock notification utility
- Retrieve Call Stack Entries (QWVRCSTK) example
- Retrieve MSGW Job Error Log and Send Error Text to User
- Retrieve object locks and send to job log as *DIAG messages by Rick Chevalier
- RPG and Excel with Java (POI)
- RPG Pie Charts, Bar Graphs and more, all on the iSeries AS/400
- RPG Port Sniffer
- RPG Report Engine
- RPG To Desktop - automatically open desktop applications from RPG
- RPGBeans - Service Program File Encapsulation
- RPGDOC Reads program source and creates HTML program documentation similar to that produced by JAVADOC.
- RPGUnit is an open source framework aimed at making unit testing easy for RPG programmers.
- RUNPGMTRC/PRTPGMTRC - Tracks all executed statements when a program is run, and prints an indented listing of the source showing how many times each line has been run. by Martin Rowe
- Sample imbedded SQLRPGLE program using /free
- Sample program that demonstrates writing XML to the IFS
- Sample Trigger program
- Scan spoolfiles in an outq for a text string(V5R2+ only)
- Selective SPOOLFILE copy to CSV files and e-mail
- Service program to encrypt/decrypt data using 128-bit AES
- Show Library Size
- Simple Socket Client Program
- Spool Tracker (versions 4.5 and 5.1 only)
- SQL Call Level Interface - A RPG-IV translation of the SQLCLI.h and the translated ?Embedded SQL? example from the IBM manual.
- SQL Cursor loaded subfile
- SQL Remove Duplicate Records Directory
- SQL2SYLK - To produce an AS400 file directly readable by Excel is at your hand
- The ARCHIVE Utility by Ted Holt
- The RPG Source
- Trigger Mediator II by Alan Campin
- Trigger Template by Pete Hall
- TYLOGIX Free Downloads & Utilities
- Undel II (undelete records)
- Use the OPNQRYF functionality from within RPG (/Free)
- Using a data queue to pass data from Java to RPG
- Using the <eXpat/> XML Parser on iSeries:
- Validation Lists -- utilities for working with
- Various Sort Routine examples
- Virtual Save & Transfer
- Visual RPG Express - an RPG IV editor
- Visual RPG prototype generator - generate the RPG prototypes JAVA methods.
- Wordfile - Syntax checking ability for Net.Data within Ultra-Edit.
- Work with all output queues defined to print TCP/IP
- Work with the QZDASOINIT (ODBC) jobs.
- Write directly to IFS
- WRKACTJOBS - Output Work Active Jobs to file.
- WRKDBF - Work with Database File tool (now shareware)
- WRKSPLF php script
- WSDL2RPG - This tool takes a WSDL document and automatically generates an RPG program.
- XLPARSE - Use RPG to read an Excel spreadsheet
- XLSCGI - Using CGIDEV2 to create Spreadsheets
- XML Parser v. 4.5
- XML Wrapper
- xRPG Core Library - This free set of tools and procedures intended to demonstrate the power of the xRPG approach.
- ZIPSAVE Save & Zip - Zip and unzip on your iSeries platform