Get started
Bring yourself up to speed with our introductory content.
Get started
Bring yourself up to speed with our introductory content.
Running AS/400 query to find records based on date
Learn about a quick way of running an AS/400 query to select records based on current sysdate. Continue Reading
iSeries tutorials
Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about, including i5/OS, iSeries applications, iSeries 400 basics, and OS/400-i5/OS security. Continue Reading
V6R1 upgrade planning checklist
When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been installed. Continue Reading
-
Printing from the iSeries
Printing is a critical process in any organization's application flow, so keeping your iSeries printer up and running is a must. We've gathered some of the top expert advice, tips and articles to help you print and distribute your data and reports ... Continue Reading
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 data inserts, deletes or changes. Continue Reading
Translating Linux for IBM i admins: Using GUI to make 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 from a Web browser.Continue Reading
Convert a numeric physical file to a character in SQL without leading zeros
In SQL, when converting a numeric physical file to digits, pass the results of the DIGITS function through the STRIP function in order to avoid leading zeros.Continue Reading
Inserting data from a CTE into a file in SQL
To insert data from the CTE into a file in SQL, the common table expression definitions need to be declared within the nested SELECT statement when using a SQL insert statement.Continue Reading
Translating Linux for IBM i admins: Working with jobs and networking
Learn the Linux equivalent to WRKACTJOB and how NETSTAT works on in Linux. This tip continues to translate Linux commands for AS/400 adminstrators who are not familiar with the complexities of the language.Continue Reading
Expanded password rules available in System i/OS 6.1
System i/OS 6.1 provides new password security tools that can tighten up security in your AS/400 shop. Rich Loeber shares his favorite new password security tools and describes their implementation.Continue Reading
-
Translating Linux for IBM i admins: User profile commands
Linux can run on an AS/400 partition, but without understanding the commands, an IBM i admin may give up. Learn about user profile commands on Linux from an IBM i admin, including how to change passwords and assign users to groups and subgroups.Continue Reading
Linux for IBM i: Authorities and permissions
Part of administering a Linux OS is adapting permissions and authorities to the needs of your organization. David Vasta explains how to decode the file permission system, how to use chmod, and concepts in file management on the Linux OS.Continue Reading
Quiz: iSeries (AS/400) History
2003 marks the 15th anniversary of the AS/400 (now called the iSeries), so we thought we'd take a look back and see how it's changed over the years.Continue Reading
OS/400
OS/400 is IBM's operating system for its AS/400 and AS/400e line of business computers. (Continued...)Continue Reading
i5/OS
i5/OS is the name IBM has given to its newest release of OS/400 V5R3. i5/OS runs on IBM's i5 servers, which are based on IBM's Power5 microprocessors.Continue Reading