Search400: iSeries news and advice

System i admins await upcoming IBM i OS features

Mark Fontecchio, News Writer — Fri, 30 Oct 2009 13:08:33 EST

XML support for DB2, better solid-state disk management and better spool file support are some of the features in the new System i operating system that pros are anxious to test.

Enhancing RPG with external SQL stored procedures

Andrew Borts, Contributor — Fri, 30 Oct 2009 09:35:31 EST

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

Steve Pitcher — Tue, 27 Oct 2009 12:02:28 EST

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 security of S3 cloud storage, with no guarantee from Amazon of data security.

IBM's System i and System p merger: Users weigh in

Mark Fontecchio, News Writer — Fri, 23 Oct 2009 11:08:53 EDT

IBM merged the System i and p platforms more than a year ago, which brought concerns about System i's future viability. System i users weigh in with mixed opinions on the results.

Developing a security incident response system for System i

Rich Loeber, Contributor — Tue, 13 Oct 2009 12:30:56 EDT

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

Steve Pitcher — Wed, 07 Oct 2009 11:18:29 EDT

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.

Introduction to SQLRPGLE on IBM i: Making a report

Joe Pluta — Wed, 30 Sep 2009 15:08:20 EDT

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.

Implementing a browser interface in COBOL: Displaying database fields

Rich Loeber — Fri, 18 Sep 2009 13:42:15 EDT

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.

Taking advantage of CL advancements, starting with V5R3

Andrew Borts — Tue, 15 Sep 2009 14:34:21 EDT

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.

Tracking remote access users on System i

Rich Loeber, Contributor — Wed, 02 Sep 2009 09:42:42 EDT

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.