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
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
Using SQL to search within a DB2 field on IBM i
By taking advantage of the Row_Number function introduced in IBM i's V5R4, you can process a range of values within a field.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
Using SQL on System i to create multicolored comment lines
When using SQL to color source code on the AS/400, it is also possible to create multicolored comment lines. This System i tip provides the queries to do so.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
System i security report roundup
The AS/400 System Security Attributes report is useful to review all of the system values and network attributes to make sure that they are still set to the value that you expect based on your security policy. Then, for good measure, see how your ...Continue Reading
Excluding characters from AS/400 DB2 SELECT statements prevents mapping errors
In DB2 on AS/400, rows with characters that cannot be converted to a numeric value (A or #) need to be excluded from a SELECT statement in order to avoid a data mapping error when running the INT function on GLSBL.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
The SETOBJACC command
The SETOBJACC command loads data into memory, and with abnormal system end, will not prevent changed data from being written to disk.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 Updates with functions
How to code an SQL UPDATE on AS/400 with mathematical functions is explained by Kent Milligan.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
Creating an SQL command to view two files as one
Expert Kent Milligan explains an SQL statement that will allow two separate transaction files to be viewed as a single file.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
Fast guide to SQL on iSeries quiz
Is your SQL knowledge on iSeries lacking? Brush up on our fast guide to SQL on iSeries and follow it up with this quiz.Continue Reading
Establish strong OS security to ward off FTP hackers
iSeries expert Richard Loeber offers more FTP server security tips to prevent hacking on your System i.Continue Reading
Using object level security to control data access
Expert Carol Woodbury explains how to use object level security to control employees' access to files without limiting their method of access.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
Maintaining user profiles boosts iSeries security
Keeping user profiles current is necessary to IBM System i (iSeries, AS400) security. iSeries security expert Richard Loeber offers news and advice about maintaining user profiles.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 FTP: Fast guide to Redbooks and articles
Need information fast on FTP for the iSeries? Take a look at these publications. We've found Redbooks, articles and FAQs for everyone from novice users to experienced pros.Continue Reading
Stored procedures allow you to balance network loads – Part II
In part two of this series on SQL stored procedures, Ron Turull explores how it can help optimize client/server applications, among other things, without bogging down the server. Isn't that the reason you went to client/server in the first place?Continue Reading
SQL defined database: Enjoy the view
Paul Tuohy provides a simple example to show you how SQL defined views may be of benefit in an existing environment. The easiest way to start using views is with iSeries Navigator, which is what I will be using in the following examples. I will also...Continue Reading
Fast Guide to System i/iSeries book excerpts
Find IBM System i (AS400, iSeries) related book excerpts and chapter downloads in this guide. Topics range from iSeries books on Java programming, iSeries web development, RPG legacy applications and more.Continue Reading
Fast track to iSeries learning resources
Here's a fast reference to all of our learning resources on Search400.com. You can find information on autonomic computing, backup and recovery, career resources, and more.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
WebSphere for System i tutorial
IBM System i users looking for ways to develop System i applications using web services have some choices. There are a number of open source tools available, but those who prefer the maturity and stability of proprietary software can use WebSphere. ...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
PC/Windows connectivity: Top 10 expert Q&As
Shahar Mor, iSeries/i5 PC/Windows connectivity expert, has been answering Search400.com's member questions for more than five years. Shahar has seen many of the same issues and concerns asked again and again. Therefore, we've compiled the top 10 ...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 i5/OS: Top 10 Q&As
Ken Graap, iSeries i5/OS expert, has been answering Search400.com's member questions for over five years. Ken has seen many of the same issues and concerns asked over and over. Therefore, we've compiled the top 10 questions asked about iSeries i5/OS...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
The iSeries Pocket SQL Guide -- Chapter 4
SQL concepts & facilities will help you to master iSeries SQL database development. Download your free chapter today.Continue Reading
Know-IT-All Chapter Quiz: SQL concepts & facilities
Think you know all there is to know about SQL? We challenge you to test your skills by taking our latest quiz.Continue Reading
SQL Built-In Functions and Stored Procedures -- Chapter 2
As a member of Search400.com, you're entitled to a complimentary copy of Chapter 2 of "Stored Procedures and Built-In Functions" written by Mike Faust and published by MC Press. This chapter, Built-In Functions" will explore the BIFs included in ...Continue Reading
Know-IT-All Chapter Quiz: SQL Built-In Functions
Think you know all there is about built-in functions? We challenge you to test your skills by taking our latest quiz.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
Preparing for an iSeries upgrade
This guide describes how to prepare for an iSeries upgrade. Whether you're upgrading from V4R2 to V4R5 or to V5R4, the information in this guide may be useful to help you avoid some common upgrade-related issues.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 Readingauthorized 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
Disaster recovery essentials
Most industry experts agree that a good disaster recovery plan is essential to any IT shop. Critical to that plan is making sure your backups are clean and that you can restore that data. If a disaster struck, how would your shop fare? Not sure? ...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
Using password expiration intervals
I am trying to use the user profiles report to determine if any users have had their password expiration intervals set to something other than the system value. When I run the profiles report, all of the values are either a -1 or a 0. According to...Continue Reading
Quiz: Netiquette -- Are you an Internet savage?
How are your Internet manners? Take this quiz and find out if you're a Ms. or Mr. Manners of the Net or an Internet savage.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
seize
To seize is to take or wrest control of something that you did not previously control. In programming, for example, an operating system may seize or take control of some memory that is in use by an application because they have used it too long and...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
Speed up SQL subselects
Here you'll find an easy way to speed up your SQL subselects.Continue Reading
Is the system in a restricted state?
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
Locating the first day of the month in SQL
Here you'll find a simple way to locate the first day of the month in SQLContinue Reading
network PC (appliance)
A network PC (sometimes called an appliance) is a term used to denote a new kind of relatively low-cost PC designed for Internet access and specialized business use, but without the full capabilities ot today's personal computer and software.Continue Reading
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
Encrypt communication between iSeries and desktops
What do you do when you need to encrypt information flowing between iSeries servers and desktops? Here are a couple ideas.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
SQL for eServer i5 and iSeries -- Chapter 2
Learn how to use the SQL scripting tool included in iSeries Navigator.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
Getting truncated values on SQL Server
Access data on an SQL server from the iSeries
Audit the interactive SQL session
CHAR fields vs. VARCHAR