Midrange Guru

OS/400 Edition
Volume 2, Number 91 -- December 6, 2002

In This Issue

You Have Questions. The Gurus at Guild Companies Have Answers.

Sponsored By

WORKSRIGHT SOFTWARE

CASS Certification

What is it? Why do you need it?

CASS stands for "Coding Accuracy Support System." This test, developed by the U.S. Postal Service, determines whether ZIP Code software can accurately assign ZIP Codes to mailing addresses. WorksRight offers CASS-certified software intended to improve the accuracy of carrier route, 5-digit ZIP, ZIP+4, and delivery point codes.

For more information or a 30-day free trial, visit www.worksright.com or call 601-856-8337.

Get Rid of Old IFS Files, Take Two

Hey, Ted:

I have worked with Unix for 18 years. Here is a Qshell command that will remove any file that is more than seven-days old. (It also checks subdirectories).

-- Mike

Hey, Ted:

I have heard that SQL's LIKE predicate cannot take advantage of indexes. Can I use indexes to speed up a query that uses LIKE?

-- Jim

In the article, "Overlooking the Obvious," which published in the November 8 issue of Midrange Guru, you asked the question, "does anybody have a use for a one-row, one-column table?"

-- Scott

READ MORE >

Subscription Information: To unsubscribe, change your email address, or sign up for any of Guild Companies' free e-newsletters, visit http://www.itjungle.com/sub/subscribe.html

THIS ISSUE SPONSORED BY:
ASC WorksRight Software

BACK ISSUES

TABLE OF CONTENTS
Get Rid of Old IFS Files, Take Two Performance of the SQL LIKE Predicate Reader Feedback and Insights: One-Row Table Still Needed

Editors
Howard Arner
Joe Hertvik
Ted Holt
David Morris

Managing Editor
Mari Barrett

Publisher and
Advertising Director
Jenny Thomas

Advertising Sales Representative
Kim Reed

Contact the Editors
Do you have a gripe, inside dope or an opinion?
Email the editors:
editors@itjungle.com