Previous Topic Next topic Print topic


X131: Attempt to drop location in use.

SQLWizard Notes:

If you open a location, or query the tables in a location (by looking at the location through the Catalog Browser, for example), the SQL Engine considers the location to be in use. If you receive the error when you try to drop a location:

  1. Exit from SQLWizard (or the application that is returning the error).
  2. If your default location is the location you want to drop, you must open Options and change the default location to a different location.
  3. Restart SQLWizard.
  4. Drop the location using the Location menu's Drop option.
Previous Topic Next topic Print topic