FHG Volume: 12 Archives - Page 4 of 9

Is An RPGOA-like Standard For HTML5 On The Horizon?

July 25, 2012 Alex Roytman

There is a lot of talk lately about HTML5. But do most people understand what HTML5 really is? One way to define it is to say it’s the next version of HTML; basically an update to HTML4.

But is it more than that? Perhaps it’s not just an update, but a new thing altogether, a new way to build Web and mobile applications.

To me, HTML5 signifies a different paradigm, where Web applications are built as true applications, not just as Web pages.

More Than Just HTML

The enhancements being adopted and proposed into the HTML5 standard encompass HTML, CSS,

…

Copy Data From A Remote DB2 Database Using DB2 For i 7.1

July 25, 2012 Michael Sansoterra

IBM DB2 for i 7.1 introduced the ability to query a remote DB2 for i database directly without having to invoke an explicit CONNECT statement. Querying a remote table with one SQL statement is great, but lacks one important feature: requests for remote data are usually combined with requests for local data.

However, DB2 for i does not allow references to tables from multiple relational databases in a single statement, until now that is. The i7.1 technology refresh 4 update allows an INSERT/SELECT statement to reference tables from different DB2 relational databases. (Even if you’re not at i7.1 you can

…

Admin Alert: The Right Way To Delete User Profiles, Part 1

July 25, 2012 Joe Hertvik

To most people, deleting user profiles on an IBM i partition is an easy process that doesn’t warrant much thought. However, your user deletion process can be complicated by several different items, including compliance requirements and special handling needed for user profiles that are critical to system functioning. This issue and next, let’s look at some dos and don’ts for profile deletion and outline a procedure for deleting user profiles.

A Common Procedure For Anyone Who Leaves Your Organization

IMHO, the best way to deal with terminated users is to perform the following five steps:

Know and follow organization specific

…

Admin Alert: Making Run the Same Run the Same On IBM i Access 7.1 On Windows 7

July 11, 2012 Joe Hertvik

One of my clients is working on a new build for their Windows 7 computers. They are deploying IBM i Access for Windows 7.1 (IBM i Access) on Windows 7 for the first time, and I’ve been evaluating using the product on that platform. Here are some issues and observations I’ve seen with the Personal Communications (Pcom) product that comes with version 7.1.

Run The Same May Not Run The Same In IBM i 7.1

Like IBM i Access for Windows’ predecessors such as Client Access Express for Windows, iSeries Access for Windows, etc., IBM i Access ships with a

…

RPG Subprocedure Error-Handling with APIs

July 11, 2012 Ted Holt

In the May 2, 2012, edition of this august publication, I shared how Brian Rusch’s shop uses an API to forward escape messages up the call stack in CL programs. The Resend Escape Message (QMHRSNEM) API works just as well in RPG subprocedures. Here’s how it’s easily done.

First, you need a prototype for QMHRSNEM, and you must define the first two parameters.

D ResendEscapeMsg...
D                 pr                  extpgm('QMHRSNEM')
D   MessageKey                   4a   const
D   ErrorCode                   10i 0 const

You can define the remaining parameters if you want, but make sure you mark them OPTIONS(*NOPASS). If you like, place the prototype in

…

DB2 For i XMLTABLE, Part 2: Using Namespaces And IFS XML Files

July 11, 2012 Michael Sansoterra

In Part 1 of this series, I introduced the DB2 for i developer’s newest friend, the XML “slicer and dicer” table function: XMLTABLE. XMLTABLE is powerful because it can read an XML document and convert its content to a tabular format that can participate in a query with relational data.

The developer has to specify the mapping between the XML data and the intended tabular format by using XPath expressions that instruct XMLTABLE how to map the data from XML into rows and columns. In this article, I’d like to cover two additional topics: parsing XML documents containing namespaces, and

…

Admin Alert: Finding TCP/IP Interface History And More On The NetServer GO Nets Installation Library

June 27, 2012 Joe Hertvik

For this week’s column, here’s some interesting information I found about discovering the history of your TCP/IP interfaces and how to retrieve the QUSRTOOL library for installing the IBM i NetServer GO NETS menu discussed in last week’s column.

Displaying The History Of Your IBM i TCP/IP Interfaces

If you’re on i 6.1 or above, here’s an easy way to determine when and how your TCP/IP interfaces were last started or stopped. You can do this by looking at the job log history of the TCP/IP control job, QTCPWRK (formerly named QTCPIP in V5R4Mx and below).

Whenever TCP/IP

…

Another Way To Skin A Generic Cat

June 27, 2012 Hey, Ted

I am writing in response to your recent article, Add Powerful Generic Processing to Your Applications, regarding generic processing. I have another, simpler technique that you should share with my fellow readers of Four Hundred Guru.

–D

D’s technique is to use the Remove Link (RMVLNK) command. Here’s the example he (she?) gave me:

RMVLNK OBJLNK('/qsys.lib/dug*.devd')

This command deletes device descriptions with names that begin with DUG. Notice that RMVLNK requires objects to be specified in the IFS naming convention.

You may use RMVLNK or its two aliases, DEL and ERASE, for objects other than libraries. For libraries,

…

Protect Your Intellectual Property: Obfuscate DB2 For i Source Code

June 27, 2012 Michael Sansoterra

Every “old timer” IBM i developer knows about the compiler option to include or exclude source statements within an OPM or ILE program. The CL compilers even have an option to allow CL source to be retrieved from the Retrieve CL Source (RTVCLSRC) command.

While high-level language programmers can decide whether or not to include source statements with their objects, DB2 SQL developers had no such option because anyone could use a tool like iNavigator to retrieve the SQL source. Thanks to the IBM i 7.1 technology refresh 4 update, SQL developers now have the option to obfuscate their

…

Admin Alert: Of Course, Everything I Know About NetServer Could Change

June 13, 2012 Joe Hertvik

In my last column, I explained why people lose IBM i NetServer access, discussing some common ways to restore NetServer access to a user profile. Little did I realize that I had barely scratched the surface of this topic. Thanks to alert reader Tony Cusack, I learned some new NetServer tricks I didn’t even know existed. Here’s what Tony taught me and how it can help you better manage your NetServer configuration.

In Our Last Episode. . .

Last time, I provided the following information on managing IBM i NetServer user profile access.