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
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
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
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
AS/400 (IBM iSeries, AS/400e, eServer iSeries/400)
The AS/400 - formally renamed the 'eServer iSeries/400,' but still commonly known as AS/400 - is a middle-size server designed for small businesses and departments in large enterprises and now redesigned so that it will work well in distributed ...Continue Reading
Running source member SQL statements with RUNSQLSTM
The RUNSQLSTM command expects a semi-colon (;) at the end of each SQL statement.Continue Reading
Enabling IBM i to access Microsoft SQL server data
Microsoft SQL Server does not fully support the open group DRDA standard, and thus middleware is needed to enable the AS/400 to access Microsoft SQL server data.Continue Reading
Linux for IBM i: Commands and terminology
If you are a Linux novice, David Vasta shares terminology and basic useful commands to get you acquainted with Linux lingo.Continue Reading
Selecting a PF with multiple members from SQL
The simplest technique for selecting a PF with multiple members on AS/400 from SQL is to create an alias.Continue Reading
Referencing a renamed column on SELECT clause in SQL
The SQL Standard does not allow a renamed column on the SELECT clause to be referenced on a different part of the SQL statement such as the WHERE clause. To do it on a single statement, an SQL common table expression can be used.Continue Reading
Linux for IBM i: Introducing Linux to IBM i people
Linux on i is a cheap, easy and very powerful operating system. This introduction to Linux for the AS/400 walks you through some history and resources including where to get Linux. The advantages of the OS are described, along with a brief ...Continue Reading
Encrypting files or fields on the iSeries
Encrypting files on iSeries is no trivial undertaking. Using vendor technologies such as those from Linoma Software and nuBridges may be easier than cobbling it all together with IBM tools.Continue Reading
Joining files using SQLRPGLE
In DB/400, for a join operation returning a single row, the SELECT INTO statement can be used in SQLRPGLE.Continue Reading
Using SQL syntax to override DB2 automatic column name generator on iSeries
If you don't want to drop and recreate a table to change the internal names in your AS/400 DB2, a special SQL syntax can solve your problem.Continue Reading
Making a file with an automatic key in iSeries with DDS keyword
If you want to create an automatic key using a DDS keyword on AS/400, Kent Milligan explains that any native writes performed against an SQL table created with an identity table will result in DB2 generating identity values.Continue Reading
Using SQL on System i to color source code and inline comments
Without use of an advanced emulator, how do you color source code? SQL. This tip provides a complete table of valid hex values for display colors and the SQL queries to implement it on your system.Continue Reading
Determining relationships between tables and files in DB2 UDB
There is no SQL command that can simply determine relationships between tables and files on your iSeries. If you have referential integrity constraints in place, you can write queries against the system catalog objects such as QSYS2/SYSREFCST to ...Continue Reading
SQL statement history storage
Hitting the wrong button in iSeries can cause a serious headache. If you have exited an STRSQL session without saving and want to retrieve your lost information, you may be out of luck. But Scott Ingvaldson explains where SQL statement history is ...Continue Reading
Copying IFS files with QCMDEXC as SQL stored procedure
ISeries PC/Windows connectivity expert Shahar Mor discusses how to copy IFS files to AS/400 with the QCMDEXC command.Continue Reading
Report Program Generator (RPG)
RPG (Report Program Generator) is a programming language that originated as a report-building program used in DEC and IBM minicomputer operating systems and evolved into a fully procedural programming language. (Continued...)Continue Reading
EBCDIC (Extended Binary Coded Decimal Interchange Code)
EBCDIC (Extended Binary Coded Decimal Interchange Code ) (pronounced either "ehb-suh-dik" or "ehb-kuh-dik") is a binary code for alphabetic and numeric characters that IBM developed for its larger operating systems. (Continued...)Continue Reading
SQL packages on remote servers
ISeries expert Kent Milligan offers AS/400 advice on SQL packages to remote servers.Continue Reading
An example of using COUNT() in a STRSQL statement
iSeries expert Kenneth Graap gives an example of using COUNT() in a STRSQL statement.Continue Reading
Fast guide to iSeries SQL
Need SQL tips and advice? We've compiled some novice iSeries SQL tips and expert advice, as well as more advanced iSeries SQL information, in this Fast Guide to iSeries SQL. After you've spent some time with the material, test your knowledge with ...Continue Reading
iSeries (i5, i5 Series)
iSeries is IBM's midrange server line, designed for small businesses and departments in large enterprises. (Continued...)Continue Reading
System i/iSeries Backup and Recovery Learning Guide
Would you be able to recover your systems in the event of a disaster? Hopefully the answer is yes. To help you make sure your backups and restores are being done correctly, we've pulled together a multitude of tips, articles, white papers and other ...Continue Reading
Advanced Function Printing (AFP)
Advanced Function Printing (AFP) is an IBM architecture and family of associated printer software and hardware that provides document and information presentation control independent of specific applications and devices.Continue Reading
Learning guide: Simple steps to a secure iSeries
This organized list will guide you along your way to maintaining a secure iSeries system. Undoubtedly, the iSeries is one of the most secure platforms out there, but don't be mistaken in thinking that it is untouchable. Address the basic security ...Continue Reading
iSeries freeware/shareware library
Check out our iSeries freeware and shareware library for a comprehensive listing of i5/iSeries downloads, code samples and useful tools that can be used as is or customized to fit your needs. You'll find freeware and shareware from IBM, Search400 ...Continue Reading
System i backup and recovery: Top 10 Q&As
Ken Graap ,System i backup and recovery expert, answers users top 10 questions.Continue Reading
Squirrel: The universal SQL client
Jim Mason, president of ebt-now, shares his thoughts on the open-source product Squirrel. According to Jim, Squirrel is a great tool for accessing any type of data anywhere using SQL. In this tip, he explains what Squirrel is, the challenges of ...Continue Reading
WebSphere Development Studio Client (WDSC)
WebSphere Development Studio Client (WDSC) is a set of application development tools designed for the IBM (International Business Machines) iSeries server. The WDSC basic edition offers user-friendly, easy-to-learn tools to help providers optimize ...Continue Reading
Bypassing the 65,000 row limit in Excel via the iSeries
When you need to upload more than 65,000 rows of data from the iSeries to Excel, use the "Receive files from Host icon". Learn how in this Search400.com tip.Continue Reading
Big Blue (IBM)
Big Blue refers to IBM, which has used blue as a branding color in its logo and elsewhere.Continue Reading
authorized program analysis report (APAR)
An APAR (authorized program analysis report) is a term used in IBM for a description of a problem with an IBM program that is formally tracked until a solution is provided.Continue Reading
AIX (Advanced Interactive eXecutive)
AIX is an open operating system from IBM that is based on a version of UNIX.Continue Reading
CIW (Computer Intensive Workload)
In IBM's AS/400 and iSeries line of computers, CIW (Computer Intensive Workload) is a measure that can be used to compare the workload-handling capability of different computer models when running application programs in which most of the computer ...Continue Reading
Star processor
IBM's Star processor is a reduced instruction set computer (RISC) processor that is available in several series versions for IBM's AS/400 and RS/6000 systems.Continue Reading
exit program
In computer programming, an exit program (or exit routine) is a named unit of programming code that is entered when a particular condition occurs, such as one that requires some screening for authorization.Continue Reading
RISC (reduced instruction set computer)
RISC (reduced instruction set computer) is a microprocessor that is designed to perform a smaller number of types of computer instructions so that it can operate at a higher speed (perform more millions of instructions per second, or MIPS). (...Continue Reading
CPW (Commercial Processing Workload)
CPW (Commercial Processing Workload) is a measure used in IBM's AS/400 and iSeries line of computers to compare computer system models in terms of how efficiently each system processes a typical workload of commercial applications involving frequent...Continue Reading
midrange
In general, midrange refers to computers that are more powerful and capable than personal computers but less powerful and capable than mainframe computers.Continue Reading
UCCnet
UCCnet is a standards organization that provides an Internet-based supply chain management (SCM) data registry service for e-commerce companies and companies that have an e-commerce component.Continue Reading
Silicon-on-Insulator (SOI)
Silicon-On-Insulator (SOI) is a semiconductor fabrication technique developed by IBM that uses pure crystal silicon and silicon oxide for integrated circuits (IC) and microchips.Continue Reading
lock
A lock is a mechanism for controlling access to something. In programming, locks are often used so that multiple programs or threads on a one-at-a-time basis. Typically, a lock is of temporary duration and when the resource is no longer required, ...Continue Reading
Can commit and rollback be used on the iSeries?
Which is preferred: logical file or embedded SQL?
Calling an RPG LE program from a SQL trigger procedure
minicomputer
A minicomputer, a term no longer much used, is a computer of a size intermediate between a microcomputer and a mainframe. (Continued...)Continue Reading
Accessing MS SQL Server database from the iSeries
An ITKE member recently was looking for some information on the best way to execute a SQL statement on the iSeries. Fellow iSeries users offered advice.Continue Reading
Write results of SQL Select statement to an outfile
Outfiles are status quo on the iSeries, but did you know that SQL can produce them intrinsically? Ron Turull shows you how.Continue Reading
CHAR fields vs. VARCHAR
Run multiple SQL statements
Physical Reads and Logical Reads
iSeries Backup and Recovery Learning Guide
Would you be able to recover your systems in the event of a disaster? Hopefully the answer is yes. To help you make sure your backups and restores are being done correctly, we've pulled together a multitude of tips, articles, white papers and other ...Continue Reading
Favorite iSeries cheat sheets
Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat sheet are bits and pieces of information that come from all kinds of sources, IBM manuals, discussion lists an experience ...Continue Reading
iSeries Resource Guide for Newbies
For both iSeries newbies and seasoned professionals, the challenge of learning the ins and outs of the iSeries can be extremely overwhelming. With that in mind, we've developed a guide to provide you with some basic iSeries information and helpful ...Continue Reading
Using INSTEAD OF triggers
First introduced in DB2 UDB V8.1, INSTEAD OF triggers are very useful to isolate applications from changes in database structure. Here's a tutorial.Continue Reading
Formatting the date with SQL
Here's a simple way to provide formatting for dates in DB2.Continue Reading
Why do I keep getting SQL error SQL0204?
DB2 regular expressions for the SQL-challenged
A short (and wacky) introduction to regular expressions in DB2.Continue Reading
Working with triggers
A trigger in DB2 is a set of actions that will be executed when a defined event occurs. Here's a brief introduction.Continue Reading
How can I transfer an XML file to a physical file?
Unexpected results after doing OVRDBF then SQL
Store an image file in the iSeries
SQL/400 Developer's Guide
This book will help you create and manipulate comprehensive, complex, professional-quality SQL/400 databases.Continue Reading
SQL to select last day of month
Find the last date of a month with this DB2 tip.Continue Reading
Chose an AS/400 file member on the SQL SELECT statement
Preventing truncating trailing spaces
Using REUSEDLT on physical files
How to have the results of a Select statement written to an outfile