(A Humble Request - Please bookmark and share the page using the buttons at the end of the page.)
Download Free AS/400 Reference Ebooks
- Online resources for i Series Reference - System I Network
- Online resources for i Series Reference - IBM libraries
My I Series Tool Kit:
My I series Tool Kit consists of some really useful tools for the AS/400. These programs are mostly written in RPGLE and CL and compiled in IBMI v6.1. You can download the savefile ATOMTOOLS.SAVF. Then FTP it to the AS400 host and start using the utilities and tools. You find the detailed documentations of the tools in this page. There is also a link to download the various source files of my tool kit.
Download Link for My ToolKit: Download My ToolKit SAVF Here
Download Link for the Source Files: Download Sourcefiles HereThe utilities and tools you get in My toolkit are (Click the links to view the Documentation of the Tools):
|1. My Query Tool for AS/400 (Click to Download Documentation)|
My Query Tool is a SQLRPGLE program which provides a wide range of functionalities in SQL Queries and Reporting Domain in i/OS environment. It brings on table the best features of various available Query tools and also introduces its own very useful features which make it a very useful utility for a developer or a user. The various functions the tool can perform include:
|2. My Lock Management Tool (Click to Download Documentation)|
The Lock Management Tool is a SQLRPGLE program which can run in both Interactive and Batch Mode to list all the active locks by active jobs on all records of all database files on the system. With Interactive Mode, we can work with the current active locks on the system and the Batch Mode is used for logging the locks and sending out email alerts. The program uses various iSeries APIs like QUSCRTUS (Create User Space), QUSRTVUS (Retrieve User Space), QUSLJOB (List Active Jobs), and QDBRJBRL (Retrieve Job Record Locks) etc to build the active locks on the system.
Interactive Mode Features:
Batch Mode Features:
|3. My Job Tool (Click to Download Documentation)|
The Job Tool is a SQLRPGLE program which uses the i-Series native APIs QUSLJOB, QUSRJOBI, QUSLSPL, QUSRSPLA etc to scan thru the jobs on the system to come up with the list of jobs fulfilling the user search criteria. Using the tool, you can search for jobs with one or more of the selection criteria given below:
|4. Find Multiple Strings in Multiple Source Files (Click to download Documentation)|
|5. Get Spooled files - Download to IFS, Copy to PF or Send Email (Click to Download Documentation)|
GETSPLF(Get Spooled File Utility) is a CL Program based on simple AS400 techniques for spooled files like copying spooled files to physical files(CPYSPLF), PC Stream Files(CPYTOSTMF), send Distribution(SNDDST) and the API QUSRSPLA to help you retrieve and access the spooled files on Your AS400. The various things you can do using this command are:
|6. My Instant Messanger Tool For AS/400 (Click to download Documentation)|
My Instant Messenger tool is a SQLRPGLE application based on the logic of Data Queues and Display File Programming on the IBMI. The fundamental concept of the program is to have a display file with Data Queue option enabled on it. The program keeps waiting for an entry in the Data Queue and gets interrupted on the arrival of any entry in it. Each entry coming into the Queue has a Identifier and the program processes the entry based on this identifier. The entry can come to the Queue either from the display file of the same user or can be from any other user involved in the IM session. Every user has his own Data Queue and communications happen between the Display file, Data Queue and the program to create a live chat session. The main features of this IM Application include:
|7. My Clean Spooled Files Tool for AS/400 (Click to download Documentation)|
The Clean Spooled Files (CLNSPLF) utility is a SQLRPGLE program to clean up your Out Queues based on various criteria and parameters. It’s a very flexible way of managing your spooled files based on Job, User, OUTQ, and Status etc. The job can be scheduled to run every night and this cleans up your spooled files based on the retention period set on various criteria stored in a physical file.