I have a file that has two dates that are stored in eight-digit numeric fields in YYYYMMDD format. Using Query/400, I wish to find the difference in days between the two dates. However, one of the date fields may contain values of zero. When I view the resulting data from the query on my display, Query/400 fills the difference field with plus signs if a date is zero. But when I direct the query’s output to a disk file, the query ends abnormally. Is there a way to replace the zero date with some other value, such as the current

Recently, I did a Web services project to integrate a legacy iSeries system with a new GUI and a new Web-based interface. When programming the system, I needed to write a stored procedure to take incoming data and store it in the both the legacy program’s data tables and our “new” database. This new database was still on the iSeries, and was just new in the sense that it has more and varied fields and capabilities that the previous system. I found an interesting iSeries feature and would like to take the opportunity to present the potential problem with it

While working in multi-partition System i5 environments, many people open several PC5250 sessions at one time. But because PC5250 default Window titles aren’t very descriptive (Session A, Session B, etc), it isn’t always easy for users to determine which open session they want to ALT-tab to. Similar session names also make it harder to choose which session to open from the Windows taskbar. Fortunately, PC5250 has a solution for creating more distinctive PC5250 Window title descriptions.

Window title bar descriptions are single line descriptions of a Windows application that are found in the top region of an open application window.