Reader Feedback and Insights: Odds and Ends Always Popular

September 4, 2002 Timothy Prickett Morgan

Dear Readers:

I thought I’d share a few of the many comments that I’ve received about the Odds and Ends column that I periodically publish in Midrange Guru.

— Ted

I love your Odds and Ends column. Please publish it more often–at least once a week. That is how I learn some programming tricks. Even if you don’t get questions from programmers, I am sure that you have enough tricks (by tricks, I mean smart way of doing things) that could help readers of Midrange Guru.

— Manouchehr

Your Odds and Ends column is wonderful. I have wondered

Starting the Host Database Server Daemon After an OS/400 V5R1 Upgrade

September 4, 2002 Timothy Prickett Morgan

Hey, Joe:

We just upgraded our V4R5 AS/400 to OS/400 V5R1, and we have a problem. After the upgrade, the host database server daemon (as-database) won’t start when we issue the Start Host Server (STRHOSTSVR) command with the *ALL option. This is affecting some of our remote access applications, including some WebSphere applications.

What’s going on here, and how do I get this host server running again?

— Jake

I ran into this problem on a recent OS/400 V5R1 upgrade, and it’s an easy fix once you know what’s going on. As you already know, issuing the STRHOSTSVR command in

Parameterized RUNSQLSTM with Two or More Substitutions

September 4, 2002 Timothy Prickett Morgan

Hey, Ted:

In the June 21 issue of Midrange Guru, you shared a Qshell sed command to create a source member that can be used under the Run SQL Statement (RUNSQLSTM) command.

Your example replaced one token. However, I need to make multiple changes using one sed command. For example, this is the pattern source member:

 Insert into MyFile                
     ( Select distinct a.LOGNBR       
       from File1 a, File2 b    
       Where a.ORGLOGNBR = 'LLLLLLL'  
         and b.LOGNBR    = 'LLLLLLL'  
         and b.SEQNBR    =  NNNN      
         and a.CNTL = b.CNTL )        

I want to change LLLLLLL and NNNN together with one sed command. Otherwise