IMAGE/SQL: Issues and answers concerning SQL tables

Software

Papers & Training

Java

HP Partners

News & Events

Register for more info

2.4 How are dbefilesets used in ALLBASE/SQL?

Key points

• When the DBEnvironment is created, a special DBEFileset known as the SYSTEM DBEFileset is created.
  • Initially, the SYSTEM DBEFileset has a single DBEFile known as DBEFile0 in it.
  • The system catalog tables reside in the SYSTEM DBEFileset.
  • You can add additional DBEFiles to the SYSTEM DBEFileset.
  • You can also add additional tables to the SYSTEM DBEFileset, but it is better to put user tables into other DBEFileSets instead.

• To remove a DBEFile from a DBEFileset, use the REMOVE DBEFILE and DROP DBEFILE statements:

  isql => REMOVE DBEFILE parts1 FROM DBEFILESET partsfileset;
  
  isql => DROP DBEFILE;
  isql => commit work;
  

  The DBEFile must be empty.

• To delete the definition of a DBEFileSet, use the DROP DBEFILESET statement;

  isql => DROP DBEFILESET partsfileset;
  isql => commit work;
  

Page last updated on November 29, 1995