FHG Archives - Page 34 of 144

Where’s The Module?

August 22, 2012 Susan Gantner

Note: The code accompanying this article is available for download here.

Over the years I have participated in many discussions about how to find all the programs that have a specific module bound into them. Since the DSPPGM command doesn’t support output to a file, it provides a challenge to find this information. The question always seems odd to me, because my philosophy is that if the code in a module is needed in more than one program, it goes into a service program. The service program is then referenced by (and shared by) all the programs that need

…

Admin Alert: Copying User Profiles Between Systems

August 22, 2012 Joe Hertvik

There are times when IBM i administrators may need to copy a user profile from one IBM i system to another, especially when promoting software from a development to a production system. This week, I’ll illustrate three different techniques for copying profiles between systems and talk about their strengths and weaknesses.

Three Ways To Copy User Profiles Between Systems

There are three different ways that I know of to copy a user profile between IBM i operating systems. These techniques are ranked here in terms of the most difficult way to the easiest way to copy a user profile.

Manually

…

Accessing Multiple DB2 Relational Databases In A Single Query

August 8, 2012 Michael Sansoterra

In my prior tip, I covered a new feature provided in the i7.1 technology refresh 4 update that allows a INSERT/SELECT statement to insert data into a local DB2 for i table from a query against a remote DB2 database. In this tip, I will cover a method that can be used to query multiple DB2 relational databases in a single statement.

Author’s Note: Incidentally, the remote DB2 database can be another member of the DB2 family besides DB2 for i. Check out my article on DB2 for Windows for more information.

As I mentioned in my last tip

…

Composing An XML Document From Relational Data, Part 1

August 8, 2012 Hey, Mike

My boss asked me if I know of a cheap or free tool that can automatically export a DB2 (for i) table to an XML file. I told him that I could write a Java program pretty easily that could accomplish this for a specific table, but I’m not aware of any way to “generically” do it for any table.

For example:

select *
  from deleteme

TheKey   SomeText
     1   Row Number 1
     2   Row Number 2

That code should produce output something like this:

<?xml version="1.0" encoding="UTF-8" ?>
<deleteme>
 <row>
   <TheKey>1</TheKey>
   <SomeText>Row Number 1</SomeText>
 </row>
 <row>
   <TheKey>2</TheKey>
   <SomeText>Row Number 2</SomeText>

…

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

August 8, 2012 Joe Hertvik

Last issue, I introduced a two-part article discussing techniques for deleting user profiles. Part one focused on prepping a user profile for deletion. In part two this week, I discuss how to determine whether the user is a critical user and what to do about it, and I demonstrate three techniques for deleting users. After reading both articles, you will have a good template for creating an IBM i user deletion procedure in your organization.

The Five Steps Of User Deletion

Last issue, I introduced a template that determined the best way to deal with terminated IBM i users

…

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

…

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

…

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

…

Previous Articles Next Articles

Search for: