FHG Volume: 14 Archives - Page 3 of 9

Restoring Passwords & Private Authorities When Using RSTUSRPRF

September 17, 2014 Hey, Joe

Restoring Passwords & Private Authorities When Using RSTUSRPRF

Thanks for your nice article on copying user profiles between IBM i systems. I wanted to add that I copied a profile between systems and got this system message.

CPC3713 - &2 &1 restored without password or group linkage

I fixed it by adding the Security Data parameter to the Restore User Profile (RSTUSRPRF) command. I’m running IBM i 6.1.

–Avraham

Here’s what happened with Avraham’s system and how it affects user profile restores.

When moving user profiles between systems, IBM has two scenarios for restoring passwords and private authorities for

…

Admin Alert: Importing IBM i Spooled Files Into Excel

September 10, 2014 Joe Hertvik

For a recent audit, I had to export IBM i spooled file data into Excel spreadsheets to send to our auditors. If you have a similar need for spooled file to Excel conversion, here’s my drill for importing spool file data into an Excel 2010 spreadsheet.

One Goal, Two Paths

You can export spooled file data to an Excel file in two ways: by using a commercial product or by using System i Navigator and the Text Import Wizard from Microsoft Excel 2010.

If you have a third-party product that exports spooled files to Excel format, then by all means

…

DB2 for i 7.2 Features and Fun: Part 3

September 10, 2014 Michael Sansoterra

In the second tip of this series, I explored three new features introduced in DB2 for i 7.2: KEEP IN MEMORY clause; AUTONOMOUS PROCEDURE; and the CHECK CONSTRAINT VIOLATION clause. This tip aims to keep the momentum going by exploring a handful of remaining miscellaneous features, in no particular order.

TABLE_NAME And TABLE_SCHEMA Scalar Functions

These two new functions exist in the SYSIBM schema and are used to lookup base information about an alias. Say an alias is defined on a DB2 remote system table on a system named WASHINGTON:

CREATE ALIAS DATALIB.WASHINGTON_TRANSACTIONS FOR
WASHINGTON.ADVWORKS.TRANSACTIONHISTORY;

The following VALUES statement will

…

The Nearly Forgotten DSPLY Operation

September 10, 2014 Paul Tuohy

I am sometimes asked strange questions at conferences. A recent example is: “Which operation code do you use most in RPG?” After overcoming my initial reaction of wondering what the questioner was smoking (and where I could get some), I gave the question some thought. And the answer is: The DSPLY operation.

Now, before you start to wonder what I am smoking (and where you can get some), let me explain. Firstly, the DSPLY operation will never see its way into production code, I only use it in test programs (more in a minute). Secondly, and what a lot of

…

Automatically Detecting And Re-Enabling Disabled NetServer Profiles

August 27, 2014 Hey, Joe

I have a few people that no matter what I do, always manage to disable their i5/OS NetServer (NetServer) user profile when they are opening an IBM i file share. Is there anything I can do to automatically re-enable their profiles when this happens?

–Matt

The first thing I’d do is check to see if there’s a reason your users are automatically disabling their NetServer profile when they try to open an IBM i file share as a Windows network drive. The most common situation I’ve found for auto-disabling NetServer profiles is when a user’s Windows network password doesn’t match

…

Use SQL To Read IFS Directories

August 27, 2014 Ted Holt

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

The Integrated File System (IFS) is marvelous, and without it this system I love so well would be history. Nevertheless, managing the files in the IFS is challenging. Recently I found myself wishing that I could use SQL to query an IFS directory. Since IBM had not provided me with that interface, I decided to build it myself. Here you are.

I didn’t start from scratch. Thanks to Bob Cozzi and Scott Klement, whose code I’ve appropriated over the years, I’ve written programs that access the IFS. Throwing

…

Creating A GUID In DB2 For i

August 27, 2014 Michael Sansoterra

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

Normally, modesty would forbid me from saying this, but I love Four Hundred Guru. I was looking for a way to create a globally unique identifier (GUID) also known as a universally unique identifier (UUID) so that I could write some DB2 code compatible with SQL Server. Unfortunately DB2 doesn’t have a GUID/UUID function so I had to search the web to find an alternative. What did I stumble upon? A good ol’ FHG article showing how to create a GUID/UUID in RPG that could easily be

…

The Geezer’s Guide to Free-Form RPG, Part 5: File Definitions

August 13, 2014 Jon Paris

While the changes in data definition introduced by the new free-form RPG support are great, I have to admit that it was probably the free-form file specifications that raised the biggest cheer from me. Let me tell you why.

I have always hated F-specs. Those nasty little single column codes drove me crazy. I could never remember what went where. I know I’m not the only one. All of the programmers we have taught RPG to over the last few years have also had similar problems coming to grips with with F-specs.

I am reminded of this almost every time

…

Do It Now!

August 13, 2014 Hey, Ted

In our RPG programs we protect input operations (CHAIN, READ, etc.) with an error-handling routine that notifies users of record locks. That is, the RecLock subroutine sends a break message to the locking user and displays a window with lock information to the requesting user. This logic is not working in one of our programs, and we can’t determine why. Can you help?

–Kent

I’m glad Kent wrote with this problem. It gives me an opportunity to write about a topic that has been on my mind for some time.

But first, here’s a trivia question for you to think

…

Admin Alert: More On Porting User Profiles Between IBM i Partitions

August 13, 2014 Joe Hertvik

After receiving reader email about my recent tip on how to port IBM i user profiles from one partition to another, I found there were two items that deserved more explanation and correction: 1) Restoring user profiles for multiple users; and 2) related parameters and objects that a restored profile needs. Here are some corrections and additional information that fill in the gaps that were missing from my previous article.

Correcting How To Use RSTAUT For Multiple Restored User Profiles

Reader David Miller asked me to clarify what I meant when I said the following about restoring private authorities for

…

Previous Articles Next Articles

Search for: