Newsletters   Subscriptions  Forums  Store  Media Kit  About Us  Contact  Search   Home 
fhg
Volume 4, Number 4 -- February 11, 2004

The Better Way to Delete Physical Files


Hey, Ted:

You missed a possible link between two articles in the January 14 issue! The first article is "Why SQL, Why Now," and the second is "Deleting with a Generic File Name."

The missing link is that, if you use SQL (to define your database) and issue the command DROP TABLE, the indexes and logical files are deleted (dropped) also! So that's one of the many reasons why you should use SQL.

--Wim


Thanks for the advice, Wim. Several other readers wrote with similar comments.

SQL's DROP TABLE command will indeed drop a physical file and the logical files that reference it. However, the physical and logical files do not have to be defined through SQL; they can be defined with DDS. The drop will even delete logical files whose names are not generic with the physical file's name and logical files that are not in the library that contains the physical file.

There may be times when you don't want to drop a table (delete a physical file) if it has logical files. In such a case, add the word RESTRICT to the end of the command. 

drop table mylib/customer restrict

--Ted

Sponsored By
WORKSRIGHT SOFTWARE

Do you need area code information?
Do you need ZIP Code information?
Do you need ZIP+4 information?
Do you need city name information?
Do you need county information?
Do you need a nearest dealer locator system?

We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

Just call us and we'll arrange for 30 days FREE use of either
ZIP/CITY or PER/ZIP4.

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com
Editors: Howard Arner, Joe Hertvik, Ted Holt,
Shannon O'Donnell, Kevin Vandever
Managing Editor: Shannon Pastore
Contributing Editors: Raymond Everhart, G. Wayne Hawks,
Marc Logemann, David Morris
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.

THIS ISSUE
SPONSORED BY:

T.L. Ashford
Profound Logic Software
Client Server Development
WorksRight Sofware
Bug Busters Software Engineering


BACK ISSUES

TABLE OF
CONTENTS
What You Should Know About Activation Groups

Soft-Coded Report Distribution

Dealing with Divided Date Fields

The Better Way to Delete Physical Files

OS/400 Alert: SSL Certificates



Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, 50 Park Terrace East, Suite 8F, New York, NY 10034
Privacy Statement