• Creating an RPG-based Web Service Using WDSC, Part 1

  June 18, 2008 Shannon O'Donnell

  Unless you’ve been hiding under a rock for the last couple of years, you cannot help but to have heard about Web Services. According to the industry experts, whoever they are, Web Services will solve every problem you have ever had and ever will have in your quest to send and receive data from one computer to another over the Web. And while that may be a bit of an overstatement, it is true that Web Services really do make communicating with another computer system on the Web very easy. In this article I am going to show you how

  …

  Read more

• SQL May Be Catching Up with DDS

  June 18, 2008 Ted Holt

  As enthusiastic as I am about SQL, I am not ready to abandon the native DB2-for-i interfaces. There are a few things that DDS and native I/O op codes do that SQL doesn’t handle as well. However, in V6R1 IBM has eliminated one of the DDS advantages. A logical file can do three tasks: it can define a record format to be a set of fields, it can define a data set to be a set of records, and it can create an access path over the data. SQL needs two commands. CREATE VIEW handles the first two tasks, and

  …

  Read more

• Admin Alert: Redundancy is Good, Redundancy is Good, Re…

  June 18, 2008 Joe Hertvik

  The next time you order a Power i upgrade, pay special attention to the redundant components that are available. As the computing world moves toward more and more redundancy options, many 24×7 i5/OS shops are requiring absolute redundancy in almost everything available. This week, I’ll look at some of the redundancy options available for i5/OS machines and how they can help your shop. Basic Redundancy The math of redundancy is simple. If it costs 10 percent more to install redundant components, for example, how much will that save the company if it keeps a critical system running during a busy

  …

  Read more

• Keeping 5250 Alive

  June 11, 2008 Tom Van Looy

  Some time ago, we had problems with Client Access sessions being reset. It seemed that these connections were traveling over a VPN that got disconnected after being idle for a while. Because we were not in charge of the VPN, I used TCP keepalive as a workaround for this problem. Keepalive A TCP connection can set the SO_KEEPALIVE option with the setsockopts() system call. When the TCP connection is idle for a specified period of time, a keepalive packet will be sent to keep the connection open. (In practice, this keepalive packet is a request for acknowledgement of the previous

  …

  Read more

• Seeking Advice on REXX

  June 11, 2008 Hey Bruce

  I want to call from CL program a REXX program, where the REXX program returns a calculate of date (yymmdd). Do you have an example you could send me? Thanks in advance, –Larry Larry, REXX can’t directly return a value to CL the way other languages do. You’d have to have your REXX procedure write the data to a file or use the REXX External Data Queue. To use a file you’d have to first override STDOUT to a file of your choice, then use “SAY” to write the data. In your REXX procedure you could do this: 'OVRDBF FILE(STDOUT)

  …

  Read more

• Admin Alert: All About the System i Attention Light

  June 11, 2008 Joe Hertvik

  In this week’s article, I’m presenting a high-level overview of the Power i, System i, and the iSeries system attention indicator light, which is activated when the system detects a problem. While it may be mundane to concentrate on how the system alerts you when something goes wrong, this information can come in handy when that little amber light blinks on and you’re not sure what to do. Where Is the System Attention Light? You can generally find the system attention indicator light (SA light) on the System Unit panel near the green power light, although the location varies by

  …

  Read more

• Exploring the DB2 for i5/OS Extensions to the PHP Language

  June 4, 2008 Erwin Earley

  This is the fifth (and final) article in the PHP on i5/OS series. Previous articles in this series have looked at the structure of Zend Core in i5/OS, basic syntax of the PHP language, and the i5 Toolkit collection of APIs for accessing native i5/OS resources. This article will look at the extensions to the PHP language for accessing DB2 for i5/OS resources. The DB2 extensions can be broken down into a number of categories as follows: Server/Connection Result Commit/Rollback Fetch Field Information Key Information Statement Errors Column/Procedure Table Information This article will focus mainly on functions from the Server/Connection

  …

  Read more

• Use Parameter Markers in SQL Persistent Stored Modules

  June 4, 2008 Hey Mike

  I have read your articles about SQL stored procedures with great interest. A year ago I tried to use parameter markers in dynamic SQL stored procedures but couldn’t succeed. I ended up writing stored procedures in COBOL. Could you please provide an example of dynamic SQL stored procedures using parameter markers? –Venkat Parameter markers in SQL Persistent Stored Modules are very easy to implement. If you’re using embedded SQL in COBOL to prepare dynamic SQL statements, you’re probably already 99 percent there. Below is an example of an SQL stored procedure that uses dynamic SQL to create a cursor and

  …

  Read more

• Admin Alert: Quick Audits for i5/OS Backups

  June 4, 2008 Joe Hertvik

  In many shops, Sarbanes-Oxley and other regulations require iSeries, System i, and Power i administrators to audit their backup procedures and to keep records showing that regular backups are being administered and that their backups are working as advertised. To help with this effort, this week I’ll review a few common i5/OS commands and parameters that can make your backup auditing process easier to document. Two Alternatives for Auditing Backups When using an i5/OS or OS/400 SAVxxx command, it’s common to have the command produce a report detailing backup results by running the SAVxxx command like this: SAVLIB

  …

  Read more

• Use PCOMM Scripts to Dynamically Build a Spreadsheet, Part 2

  May 21, 2008 Michael Sansoterra

  In Part 1 of this series, I demonstrated that users of IBM‘s Personnel Communications can use VBScript to run a remote PC command right from the 5250 emulator window. I want to build on that short tutorial by demonstrating how to build an Excel spreadsheet right from the context of the current 5250 screen. First of all, if you haven’t read Part 1, please read it now as there are some pointers about script writing for the PCOMM emulator that developers should be aware of. It also instructs you how to get started in writing a script and

  …

  Read more

Previous Articles Next Articles