Newsletters   Subscriptions   Forums   Media Kit   About Us   Contact   Search   Home 

MGO
OS/400 Edition
Volume 3, Number 77 -- November 14, 2003

   In This Issue

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

Sponsored By
ADVANCED SYSTEMS CONCEPTS


WHAT IF


Creating Queries, Reports and Downloads
was Easy, Fast and Convenient
for ALL Users?


- - - Make it happen with SEQUEL ! - - -

Get a Free Trial today.

Read More

Sponsored By
WORKSRIGHT SOFTWARE

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?

We can HELP! We have affordable AS/400 software and data to do all of the above. Call us for 30 days FREE.

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com

Case-Insensitive Sorting and Record Selection in SQL/400

Hey, Ted:

The Microsoft Access database management system, which I use in my work, is not sensitive to case when it selects records and sorts data. To find, for example, all the customers who live in a certain state, I can enter the state code in uppercase, lowercase, or mixed case, and Access finds the data.

READ MORE >

Locked Out of System Service Tools

Hey, Ted:

Somehow our QSECOFR password for the System Service Tools (SST) expired, and there were no other user profiles authorized to use the Start System Service Tools (STRSST) command. (QSRV was expired, too). I used CHGDSTPWD to reset the QSECOFR password to the default password. However, when I tried to sign on again with the default password, I got an error message that the service tool password couldn't be changed.

READ MORE >



Reader Feedback and Insights: Free Utility to Retrieve Command Source

Hey, Ted:

I've been using a freeware program for years, and it works well. It was written by Dave McKenzie and is available at iSeries Network.

READ MORE >


Editors: Howard Arner, Joe Hertvik, Ted Holt, David Morris,
Managing Editor: Shannon Pastore
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.


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:

Advanced Systems Concepts
WorksRight Software


BACK ISSUES

TABLE OF
CONTENTS

Case-Insensitive Sorting and Record Selection in SQL/400

Locked Out of System Service Tools

Reader Feedback and Insights: Free Utility to Retrieve Command Source



Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.