- iSeries Application development tools
- iSeries CL programming
- iSeries COBOL programming
- RPG iSeries programming
- Visual basic on iSeries
- iSeries ILE programming
- iSeries Java programming
- iSeries programming commands
Email Alerts
-
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 find a way to do something on your iSeries, TAATOOLs might have the answers you seek.Tip
-
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 procedural and object-oriented langauges into the same space.Tip
-
EGL Rich UI on IBM i: Do you Dojo?
Taking advantage of the Rich UI features of EGL architecture on the AS/400 can save you time and complexity. Rich internet applications can be difficult to write, even with Java and Webspher. EGL eliminates the need for programmers to learn JavaScript, XML or REST and Java or PHP. Using Dojo can make everything even easier with Rich UI to take away some of the usual programming work.Tip
-
Running PHP open source applications: NOBODY needs authority
User NOBODY needs to be granted authority in the IFS folder containing an open source PHP application on the AS/400 in order to run the script. Learn how to change this authority on the IBM i, and successfully run an open source PHP application on your system.Tip
-
Zend Web software teams up with IBM System i
IBM will pre-load Zend's PHP software stack on IBM System i operating system shipments, as IBM looks encourage open source on the platform.Article | 05 Feb 2009
-
The best technologies and tools for System i programmers in 2009
Best bets for AS/400 programmers and shops to save time and money in 2009. Rational Developer for i makes RPG more productive than ever. And new Web technologies including Eclipse and open source solutions like Groovy deliver efficiency in IBM i shops.Tip
-
AS/400 lessons from the past, present, and future: A holiday tale
An AS/400 admin with any experience has surely learned lessons about best practices. Andrew Borts shares some lessons from his past, the present, and speculates about what he needs to know in his future work on the IBM i.Tip
-
Documenting nested program structures on the AS/400
Documenting nested program structures on AS/400 is a complex task and is sometimes overlooked or not updated. The XPGMSTR command automates documentation in a structured and reliable way, eliminating the human-error (or lazyness) involved in the usual nested program structure documentation mishaps.Tip
-
Learn the i: iSeries DevCon coming up in Orlando
If you are looking for opportunities to learn something new about the AS/400, a trip to Florida in October may be in order. Prepare yourself for the release of V6R1 and learn other new skills to put to use on your System i.News | 25 Sep 2008
-
Application modernization in the i world
Modernizing one of the most efficient interfaces ever designed may be a bit tricky. On the AS/400, application modernization means making the best use out of your existing application programs and especially your application programmers. Joe Pluta shares the three options for modernization on the i: refacing, replacing, and rewriting.Tip
- VIEW MORE ON : iSeries Application development tools
-
Taking advantage of CL advancements, starting with V5R3
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 that ease and shorten programming commands.Tip
-
Checking in on 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 mistakes. The necessary commands include DSPAUTLOBJ AUTL, DSPOBJD OBJ, and OUTPUT(*OUTFILE).Tip
-
Running PHP open source applications: NOBODY needs authority
User NOBODY needs to be granted authority in the IFS folder containing an open source PHP application on the AS/400 in order to run the script. Learn how to change this authority on the IBM i, and successfully run an open source PHP application on your system.Tip
-
Simplify the process of converting a spool file from iSeries into an Excel spreadsheet
To simplify and accelerate the process of converting a spool file from iSeries into an Excel spreadsheet, eliminate the creation of the spool file and instead create a CVS text file, which can easily be loaded into Excel.Ask the Expert
-
CL program for daily backups
IBM makes the program source code for daily backups available on the IBM i with a simple command.Ask the Expert
-
An automated CL method of moving a query from AS/400 to Excel
If a daily task of your AS/400 is to print a report from a query a CL program can be written to automate the task and make it easy to open the results in Excel. This CL program copies an existing query to QTEMP and runs the query. Then it converts the EBCDIC physical file that was just created in QTEMP to an ASCII comma separated variable (csv) file, and changes the file type to .csv, and stores the file in an existing Integrated File System (IFS) directory. This directory can then be mapped Excel can open the .csv file.Tip
-
Changing user password expiration
On the AS/400, if you set QPWDEXPITV to 60 days but want specific users to be exempted, you can specify them and set PWDEXPITV to *NOMAX.Ask the Expert
-
Eight steps for creating program documentation using AS/400 utilities
To make a programmer's work easy and efficient, program documentation should be completed up front. This tip presents eight strategic steps for AS/400 documentation, with helpful screenshots.Tip
-
DAYSPAST CLLE program for AS/400: Compares object creation date with today's date
A CLLE program for AS/400 to determine the number of days that have passed since an object was created.Tip
-
Executing a CL command on AS/400
ISeries backup and recovery expert Ken Graap explains how to use FTP, the QUOTE command and the RCMD command to execute a CL command on AS/400.Ask the Expert
- VIEW MORE ON : iSeries CL programming
-
Implementing a browser interface in COBOL: Displaying database fields
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 page.Tip
-
Implementing a browser interface in COBOL: Creating your graphic Web page
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 field is filled in, and how a PERFORM of the Write-Out routine will work.Tip
-
Implementing a browser interface in COBOL: Getting started
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.Tip
-
Allow access to data from a stored procedure result set using COBOL or RPG
For COBOL and RPG programs to process the data after the stored procedure call completes, you need to direct the SQL stored procedure to place the result set in a global temporary table. COBOL and RPG cannot access embedded SQL as of V6R1.Ask the Expert
-
Eight steps for creating program documentation using AS/400 utilities
To make a programmer's work easy and efficient, program documentation should be completed up front. This tip presents eight strategic steps for AS/400 documentation, with helpful screenshots.Tip
-
Coloring source lines with COBOL and using a shortcut from within PDM
Search400.com reader Yoni Tehan was inspired by our tip Using SQL on System i to color source code and inline comments and translated the SQL to COBOL+CL to share with fellow AS/400 users.Tip
-
An iSeries-like COBOL for Windows
Ask the Expert
-
Getting data from a compressed file in an IFS folder into a COBOL file
Ask the Expert
-
Slow system performance
Ask the Expert
-
New option within the WRKSYSACT command
Ask the Expert
- VIEW MORE ON : iSeries COBOL programming
-
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.Tip
-
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 procedural and object-oriented langauges into the same space.Tip
-
Allow access to data from a stored procedure result set using COBOL or RPG
For COBOL and RPG programs to process the data after the stored procedure call completes, you need to direct the SQL stored procedure to place the result set in a global temporary table. COBOL and RPG cannot access embedded SQL as of V6R1.Ask the Expert
-
EGL Rich UI on IBM i: Do you Dojo?
Taking advantage of the Rich UI features of EGL architecture on the AS/400 can save you time and complexity. Rich internet applications can be difficult to write, even with Java and Webspher. EGL eliminates the need for programmers to learn JavaScript, XML or REST and Java or PHP. Using Dojo can make everything even easier with Rich UI to take away some of the usual programming work.Tip
-
Programming for the Web on the IBM i, what is possible
The AS/400 has many options for Web enablement, despite the green-screen image. Learn what Web languages are available and get resources to use as you embark on your Web journey, such as RPG, Net Dev, Java, PHP, Tomcat and others.Tip
-
Documenting nested program structures on the AS/400
Documenting nested program structures on AS/400 is a complex task and is sometimes overlooked or not updated. The XPGMSTR command automates documentation in a structured and reliable way, eliminating the human-error (or lazyness) involved in the usual nested program structure documentation mishaps.Tip
-
How to: Sort arrays using RPGIV
RPGIV allows you to sort arrays by creating records that contain elements that are in turn treated as a separate array. This allows you to sort the elements of the record in different ways depending on your needs. In this example, you can sort by SUM or by ACCOUNT number.News | 12 Nov 2008
-
How to use an embedded SQL statement and display the result in a subfile
Are you looking for a way to load a file based on several search criteria and then display the file in a subfile? John Blenkinsop provides the needed RPG code to get it done on the AS/400.News | 04 Sep 2008
-
Eight steps for creating program documentation using AS/400 utilities
To make a programmer's work easy and efficient, program documentation should be completed up front. This tip presents eight strategic steps for AS/400 documentation, with helpful screenshots.Tip
-
Application modernization for the iSeries: Why bother?
Application modernization on the AS/400 allows companies and IT staff the benefit of keeping vital and reliable legacy applications while increasing front-end functionality.Tip
- VIEW MORE ON : RPG iSeries programming
-
Security error message in VB
Ask the Expert
-
Calling a CL program from a VB program
Ask the Expert
-
Develop a VB application that will display an image
Ask the Expert
-
When should I use OVRDTA and PUTOVR in a designing a Display Screen?
Ask the Expert
-
Quick Takes: Virtual, visual and verification
Article | 17 May 2001
-
OVRDTA and PUTOVR in a designing a Display Screen
Ask the Expert
-
How to use an embedded SQL statement and display the result in a subfile
Are you looking for a way to load a file based on several search criteria and then display the file in a subfile? John Blenkinsop provides the needed RPG code to get it done on the AS/400.News | 04 Sep 2008
-
Eight steps for creating program documentation using AS/400 utilities
To make a programmer's work easy and efficient, program documentation should be completed up front. This tip presents eight strategic steps for AS/400 documentation, with helpful screenshots.Tip
-
Searching fields for values
In AS/400, if you need to find database fields that contain a specific value, in ILE RBG the field to use is D1FIND. The trick is that you have to add code to turn all search terms into uppercase, or the program won't recognize the search term if it's in lowercase.Ask the Expert
-
Searching part of a name or address in AS/400
In ILE RPG code can be written to conduct the search on part of a name or address using the field D#SFLN.Ask the Expert
-
Passing parameters in an ILE RPG module
iSeries application development expert John Blenkinsop explains about passing parameters in an ILE RPG module.Ask the Expert
-
How to use the binder language to manage service programs -- Part 3: Examples and pitfalls
In Part 1, Ron Turull discussed service program signatures and defined the differences between current and previous signature levels. In Part 2, he discussed the very simple binder language and how you use it to create service program signatures. In this final installment, he takes a look at some specific examples, along with some pitfalls you need to be aware of.Tip
-
How to use the binder language to manage service programs -- Part 2: Understanding the binder langua
In his previous tip Ron Turull discussed service program signatures and defined the differences between current and previous signature levels. In this installment, he discusses the simple binder language and how you use it to create service program signatures.Tip
-
How to use the binder language to manage service programs -- Part 1: Service program signatures
Learning to use the ILE binder language is essential to managing all but the simplest service programs on your iSeries. Before you can do that, however, you should understand the role of service program signatures. Ron Turull explains how you can use the service program signatures to your benefit.Tip
-
Display attributes made simple
What do you do when a legacy application you're maintaining is out of indicators and you want to control the display attributes? Steve Croy has the solution -- a very simple service program -- right here. He has created a prototyped procedure that makes it simple to manipulate the value of the display attribute in the P-type field.Tip
-
Solving difficult problems with recursion -- Part II
In Part I of this series, Ron Turull discussed what recursion is and how it works. Now he looks at how to implement it programmatically.Tip
- VIEW MORE ON : iSeries ILE programming
-
Groovy programming on IBM i
Groovy programs, based on the Java language and bytecodes, can run on IBM i. The built-in AIX support, PASE, allows AS/400 shops to take advantage of the new Web programming language that boasts brevity among its advantages. With a short learning curve for those with Java experience, Groovy makes modern programming features available to IBM i.Tip
-
EGL Rich UI on IBM i: Do you Dojo?
Taking advantage of the Rich UI features of EGL architecture on the AS/400 can save you time and complexity. Rich internet applications can be difficult to write, even with Java and Webspher. EGL eliminates the need for programmers to learn JavaScript, XML or REST and Java or PHP. Using Dojo can make everything even easier with Rich UI to take away some of the usual programming work.Tip
-
Programming for the Web on the IBM i, what is possible
The AS/400 has many options for Web enablement, despite the green-screen image. Learn what Web languages are available and get resources to use as you embark on your Web journey, such as RPG, Net Dev, Java, PHP, Tomcat and others.Tip
-
Database performance comparisons on IBM i
Testing performance of RLA in the IBM Java Toolbox against JDBC and native I/O for the AS/400 revealed that RPG on System i is the most efficient language, and DB2 is taken for granted. Joe Pluta built some benchmarks to compare different aspects of database performance to one another and he provides the results of his testing. Although MySQL is popular and provides an option for prepackaged applications with less stringent database requirements, it won't likely replace DB2 anytime soon.Tip
-
Database drivers on the i: MySQL vs. IBM Toolbox
Which reads data from i faster: MySQL or IBM Toolbox drivers? Joe Pluta put the drivers to the test in both an AS/400 and a Windows environment. The conclusion: MySQL over its own database performs roughly as well as IBM's Java Toolbox over DB2 data, with the caveat that they both can handle hundreds ot thousands of records well, but you may not want to push then into the millions.Tip
-
How to: Output SQL script to a text file from an AS/400
Transferring data from SQL queries directly to a .txt file in a Windows environment is the desired outcome of one AS/400 user. Inserting the output of a SELECT statement into a physical file and then using CPYTOIMPF to transfer to a .txt file is a long-way of accomplishing this task. Java or .NET may provide a more automated method.News | 04 Dec 2008
-
Application modernization for the iSeries: Why bother?
Application modernization on the AS/400 allows companies and IT staff the benefit of keeping vital and reliable legacy applications while increasing front-end functionality.Tip
-
JDBCODBC functionality -- Java to Excel for complex workbooks
Java to Excel with the AS400 may be attractive, but if you have complex VBA macros in Excel, the JDBCODBC bridge will not work well for you. A better option may be using the Groovy COM interface.Ask the Expert
-
Accessing AS/400 data using Excel ODBC drivers
There are a couple of options for accessing AS/400 data, from the old way using Client Access ODBC drivers, to Java, to a new application from Groovy.Ask the Expert
-
SQL Server Database and Java
DB2/400 and DB2 UDB expert Kent Milligan explains how to access SQL Server Database with Java.Ask the Expert
- VIEW MORE ON : iSeries Java programming
-
Taking advantage of CL advancements, starting with V5R3
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 that ease and shorten programming commands.Tip
-
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 find a way to do something on your iSeries, TAATOOLs might have the answers you seek.Tip
-
Date calculation commands for AS/400
If you need to periodically calculate dates on your AS/400 relative to a given date to determine reporting limits such as month end, month begin, this tip contains a helpful service program.Tip
-
Monitoring escape messages and using RCVMSG for diagnostic messages
When an error occurs on an IBM command, the diagnostic messages are sent first, then an escape message, which you can monitor. On AS/400 you see the escape message, and then you use the RCVMSG command to get the last diagnostic message sent to your program. Expert John Blenkinsop provides the code needed to monitor the diagnostic messages after receiving an escape message.Ask the Expert
-
iSeries application display subfiles with other program windows
In iSeries, the display file for programs may need to be set to DFRWRT(*NO) to display other program windows when using multiple programs jointly. DFRWRT(*YES) tells the workstation controller to 'Defer writing the display formats until you receive a READ'. The program sends display formats using WRITE, and the workstation controller stores them, and does not send the display formats to the screen device until your program sends a READ operation or an EXFMT.Ask the Expert
-
Creating a user profile from a file
iSeries i5/OS expert Ken Graap helps a user with creating a user profile from a file.Ask the Expert
-
WRKOBJPDM (Work with Objects using PDM)
iSeries users say WRKOBJPDM (Work with Objects using PDM) is a must-use command.Article | 01 Aug 2006
-
WRKOBJLCK (Work with Object Locks)
Learn why the WRKOBJLCK (Work with Object Locks) command is a favorite in the iSeries (AS/400) community.Article | 01 Aug 2006
-
WRKACTJOB (Work with Active Jobs)
WRKACTJOB (Work with Active Jobs)Article | 01 Aug 2006
-
WRKSYSACT (Work with System Activity)
iSeries users say that the WRKSYSACT (Work with System Activity) command tops their list of favorite iSeries (AS/400) commands.Article | 01 Aug 2006
- VIEW MORE ON : iSeries programming commands