Tips

  • Analyze the health of your IBM i server with iScore

    While more comprehensive services exist, iScore from Vision Solutions offers a free and general introductory analysis of your system's health.

  • Researching high availability for your System i shop

    Interested in a high availability solution for the AS/400? Before you delve into implementation, do your due diligence and ensure that your environment has the proper policies, resources and protoc...

  • Security considerations for IBM i backups

    Backups need to be just as physically secure as the System i. Managing a log system for backup tapes, retiring old tapes, and validating third-party storage services are part of what it takes to en...

  • Enhancing RPG with external SQL stored procedures

    Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data.

  • Putting data from IBM i on Amazon S3 using i2S3

    Kisco Systems i2S3 allows transfer of data from the AS/400 to Amazon S3 storage in the cloud. With familiar CL commands, the product is easy to use, and can fill storage needs. The danger is the se...

  • Security incident response system for System i

    Any security officers working with IBM System i need to organize a security incident response system to handle incidents of varying severity.

  • Tracking data changes on IBM i with triggers

    Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing...

  • Making a report using SQLRPGLE

    Using RPG ILE with embedded SQL can be a fast way to make database reports on the IBM i. Joe Pluta shares the code of his first SQLRPGLE program.

  • Displaying database fields in a COBOL Web page

    Learn how to display a file list from your AS/400 database on a Web page using COBOL, CL and HTML. Get code samples and see how you can use DSPOBJD to create a FILELIST that will display on the Web...

  • Taking advantage of CL advancements on IBM System i

    Using the new CL programming tools released in V5R3 on the IBM System i has advantages: New looping methods, subroutines, and multiple file declarations. See examples of old versus new programs tha...

  • Tracking remote access users on System i

    As remote access through FTP or iSeries Access becomes the standard, the system history log and exit point solutions are two options for tracking users on the AS/400.

  • TAATOOL: Useful tools for programmers on IBM i

    Over 2,000 APIs are available for the AS/400 in the TAATOOL set. The list grows as more programmers submit their tools, making the IBM i more efficient on a daily basis. If you are struggling to fi...

  • Using COBOL to make a graphic Web page from IBM i

    Learn how to use the CGI API, Write Standard Output (QtmhWrStout) to make a visual browser interface in segments, and use the COBOL STRING command to develop the segments. Then see how the Out-Data...

  • Setting up security for programmers on IBM i

    Programmers working on an AS/400 need greater security access than a standard user, but determining how much access they should get isn't always easy. Rich Loeber provides tips on what options exis...

  • Implementing a browser interface in COBOL

    Learn how to get started on developing a Web interface from the AS/400 in COBOL starting with a logon page. Includes code samples for CGI APIs and library and DDS instructions.

  • Making the most of RPG data handling on IBM i

    By virtue of being bult-in to the AS/400, RPG has speed for some operations that SQL cannot touch. Learn how RPG works with indexing to retrieve data from your IBM i.

  • Controlling remote access on your IBM i

    To control remote access via network connections on the AS/400, the most secure solution is implementation of the exit point controls in the operating system. The server controls serve as gatekeepe...

  • Migrating from RPG to EGL on IBM i

    The IBM Rational Migration Extension for IBM i (RMEi) migrates existing RPG programs to EGL. Learn when migrating from RPG to EGL may have advantages to your business, and how EGL integrates proced...

  • Translating Linux for IBM i admins: Making it easy

    Using a GUI Web interface to manage Linux on your AS/400 can save you the hassle of learning a new command language. Webmin is a free administration tool that allows Unix and Linux administration f...

  • Checking your IBM i authorization lists

    Have you ever created an object on the AS/400 without making sure the necessary authorization list is attached? By using some common commands, you can secure your IBM i, and audit objects and fix m...