Newsletters Subscriptions Media Kit About Us Contact Search Home

MGO
OS/400 Edition
Volume 3, Number 18 -- March 14, 2003

   In This Issue

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

Sponsored By
ADVANCED SYSTEMS CONCEPTS

Monitor Critical Events
Before your operation goes down!
- iSeries message queues -
- iSeries subsystems -
- Windows Servers -
- TCP/IP devices/services -
- Runaway jobs -

OpCenter Message Alert is the easiest, most versatile way to save your system, and your job! Built on graphical console technology, Message Alert can be configured and monitored remotely, or devices can be paged/emailed in the event of pending disaster. Why continue living in the dark when OpCenter is ready to assist you? Read More

Sponsored By
KISCO INFORMATION SYSTEMS

SafeNet/400. . . The MARKET LEADER in
iSeries & AS/400 Network Protection. . .

Since 1996, SafeNet/400 has been protecting systems around the world.

  • Request logging and audit trail
  • Time of day/day of week control
  • Object level protection. . .

And many, many more features are standard. SafeNet/400 is the best value in the network security market. Come see for yourself. Sign up for a FREE, NO RISK 30-Day Trial:

www.kisco.com/safenet

Using SQL to Find Duplicate Records

Hey, Ted:

I want to use SQL to find duplicate records in a customer ship-to file. The following statement tells me the customer-number/shipment-number combinations for which there is more than one record.

READ MORE >

Responsive Rooms with a View

Hey, Howard:

I've enjoyed your tips on the great things you can do with SQL views. I'm a big fan of views as well, for all of the reasons you listed, and have encouraged others to use them for many years. However, I'd like to add a word of caution.

READ MORE >



Reader Feedback and Insights: Results of System/36 Tips Poll

In "Your System/36 Information is Very Helpful," faithful reader Doug suggested that we run System/36 tips on a regular basis. I asked what you readers thought.

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
Kisco Information Systems


BACK ISSUES

TABLE OF
CONTENTS

Using SQL to Find Duplicate Records

Responsive Rooms with a View

Reader Feedback and Insights: Results of System/36 Tips Poll



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