Free Software from Kisco

August 2, 2002 Timothy Prickett Morgan

Hey, Ted:

Kisco Information Systems is currently giving away two utilities:

Smarttn is a green-screen desktop organizer that includes an adding machine, calendar, personal appointment log, note pad and phone list. Kisco used to sell this, but has decided to just give it away, no strings attached.

CPYSELF is an OS/400 command that provides for multiple field-level SQL-type selections. This is much more efficient than CPYF with selection, and it is easy to use. Kisco has even built this in to most of its applications.

It is Kisco’s plan to add more items in the future.

These utilities may be

Looking for Number Two

August 2, 2002 Timothy Prickett Morgan

Hey, Ted:

I have a file of sales reps and the amount of sales, in dollars, so far this year. I can easily find the top producer using SQL.

select repid, amt from sales2 where amt =       
    (select max(amt) from sales2)

How do I find the number-two producer?

— Roger

There are probably several ways to answer your question, Roger.

First, here’s the raw data that I’ll use to illustrate:

REPID        AMT 
JLM1      25,922 
NTP2     177,208 
LJS2      15,424 
CRC0     122,730 
HFH1      95,682 
JKS0      76,903 
JLM2      55,088 
JTL4      99,944 
MWS0      12,155 
BRS1      54,673

To find the number two producer:

select repid, 

Confirm File Deletions in Qshell

August 2, 2002 Timothy Prickett Morgan

Hey, Ted:

I accidentally deleted a file in Qshell. I know about the -i option for the rm command, but I forget to use it. Is there any way I can make the -i option the default setting?

— Lynn

Use an alias, Lynn. An alias is an alternate name for a command string.

Add the following line to the .profile file in your home directory.

alias rm='rm -i'

If you want to change the default for all users, edit /etc/profile instead.

When you run the rm command, Qshell will substitute rm -i for the rm you type. You will