1. Are We There Yet? Find Out with the RPGLE Progress Bar

Eliminate user frustration by giving them feedback about long-running jobs. By Mike Faust If you've ever created an interactive application that processes a lot of data, and as a result runs for a long time, you've probably had

2. Getting the Message Using an SQL UDTF

Use an SQL user-defined table function (UDTF) to access messages in a message file. By Mike Faust If you've ever needed to retrieve information from a message file, you're probably already aware of the Retrieve Message (QMHRTVM)

3. Use Long, Descriptive Names in RPG Fields, Data Structures, and Prototypes

What do you do when 15 characters just aren't enough? By Mike Faust If you're like me, you've become so used to abbreviating names for fields, data structures, prototypes, and subprocedures to stay within the 15-character limi

4. Emulate Object-Oriented Programming in ILE RPG, Part II

Now, we'll take the concept to the next level by using prototyped subprocedures. By Mike Faust In a previous article, we explored how nested data structures can help to emulate the way object-oriented programming languages access info

5. Emulate Object-Oriented Programming in ILE RPG

What do you get when you combine nested data structures with prototyped subprocedures? By Mike Faust According to Wikipedia, although the concepts behind object-oriented (OO) programming have been around since the 1960s, they weren'

6. Implementing Enterprise Search Within Your ERP Application

Use Google's Search Appliance "OneBox" modules to integrate enterprise search functionality with your ERP. By Mike Faust The concept behind enterprise search functionality is fairly simple. As the name suggests, the goal o

7. TechTip: Access XML Web Services with JavaScript

Try this practical, working example to see how you can combine AJAX with XML Web services to create truly powerful applications using JavaScript. In a previous TechTip, I introduced you to the JavaScript objects used to access XML Web service

8. TechTip: Accessing XML Data Sources from JavaScript

Utilize JavaScript for programming business applications. The JavaScript language has become a popular scripting language because it gives programmers the ability to enhance a static Web browser interface. One of the few shortcomings of JavaSc

9. Instigating Change Within IT

Use these practical approaches to introduce new development technologies into your IT organization.

10. Integrate Open-Source Applications with Your System i

Use open-source software to free your mind and your budget.

11. Open-Source Technologies for Change Management Systems

Change management is no longer a luxury; it's a necessity. Fortunately, the required software is free.

12. Tech Tip: Have You Checked Your Level?

Prevent level checks from taking down mission-critical applications.

13. Tech Tip: Pass the Parameters

Learn why parameter-passing styles matter.

14. Introduction to Business Process Execution Language (BPEL)

What does this extension to XML Web services mean for your business?

15. Integrating to Enterprise Resource Planning (ERP)

Find out what SOA/XML Web services mean to ERP systems integration.

16. V5R4 SQL Enhancements

New functions and functionality show IBM's continued commitment to the evolution of SQL on the iSeries.

17. TechTip: Use SQL Columnar Functions for Statistics, Summing, and Counting

Have FUN with aggregate FUNctions.

18. Living the Active (Server Pages) Lifestyle?

If you're not using Active Server Pages, you don't know what you're missing.

19. TechTip: V5R3 System Values

Find out what's new and what's been changed.

20. TechTip: PREPARE to DECLARE

Use DECLARE and PREPARE to improve SQL performance.

21. TechTip: Pardon Me, but Do You Have the Time?

Learn about the time synchronization enhancements in V5R3.

22. TechTip: Improving Free-Format Readability

Use this utility to get control of your free-format code.

23. An Introduction to ILE Activation Groups

How you make use of this powerful ILE feature can greatly impact the performance and flow of your ILE programs.

24. TechTip: V5R3's New SQL BIFs, Part 3

The remaining functions deal with dates, strings, and a couple of miscellaneous topics.

25. TechTip: V5R3's New SQL BIFs, Part 2

Secure your data with the new data encryption functions.

26. TechTip: V5R3's New SQL BIFs, Part 1

In the first of this three-part series, we explore data partitioning functions.

27. Putting the i(Series) in TCP/IP

Make the most of this protocol on the iSeries.

28. TechTip: Native OLE DB vs. ODBC

Here's a side-by-side comparison of these database access options.

29. Charting a New Course with OWC and ASP

Use Office Web Components and Active Server Pages to display a chart in a Web page.

30. Do You See UCCnet?

This initiative will impact retail suppliers sooner than you may think.

31. TechTip: SQL GetMiles Function

Use an SQL user-defined function to calculate the distance between ZIP codes.

32. TechTip: Perform SQL Updates Using Multiple Files

Update data in one file using values or criteria from another.

33. TechTip: SQL Current-Date-to-Numeric-Date Comparisons

Select numeric date field values based on the current date in SQL.

34. ASP.NET to iSeries Socket Server

Create a client/server socket-based application that allows an Active Server Page .NET application to communicate with the iSeries.

35. Making the Most of Excel Web Query

Getting iSeries data into a spreadsheet is easier than you think.

36. TechTip: DATE-ing Advice for Query/400

Are you looking for an easier way to deal with those pesky date values?

37. TechTip: Elapsed Time Function

If you're creating an application that has to calculate elapsed time based on a start and end time, you know what a challenging task this can be. Even with many of the date and time RPG op codes, this can often involve incorporating some ugly code

38. TechTip: DSPQRYREF

One big drawback to using Query/400 is that it's often difficult to keep track of the files used within your queries. Figuring out what files queries use often involves going into each individual query, which can be a big issue if you update a fil

39. Electronic Data Interchange via the Internet

Initiatives from some big names are driving big changes in EDI.

40. The Land of the /free

Use free-format ILE RPG to liberate your applications.

41. TechTip: Connect to the iSeries DB2 Database from an Active Server Page

Using the iSeries DB2 database from an Active Server Page (ASP) can really expand your application development possibilities. The problem is that setting the whole thing up can get a bit confusing. Let me take you step by step through what you n

42. Strike Up the Band(width)

Maximize your data line use.

43. What's New with DB2 in V5R2

SQL enhancements and compatibility highlight what's coming in DB2 UDB for iSeries.

44. Using SQL Server 2000 Analysis Services & the iSeries--Part II

Read data from an OLAP database.

45. SQL Server 2000 Analysis Services & the iSeries--Part I

Add a new dimension to your database.

46. The Good OLE (DB) Days

Use ADO and OLE DB to create a Web-based Query tool for the iSeries.

47. Query Manager Made Simple

Create reports in no time using Query Manager.

48. The ABCs of AFP

Using AFP to liven up your reports is child's play.

49. Ladies and Gentlemen, Start Up Your AS/400s

Modifying your startup program can be a lifesaver.

50. Getting Control of Host Servers

Host servers are made easy using the new WRKHOSTSVR command.