HPlogo Up and Running with ALLBASE/SQL: HP 3000 and HP 9000 Computer Systems > Chapter 3 Setting Up a Database with ISQL

Adding DBEFiles to DBEFileSets
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

After creating DBEFiles, you must add them to a DBEFileSet before they can be used. In MUSICDBE, two choices are available:

  • SYSTEM, already created when you issued the START DBE statement.

  • ALBUMFS, which you created in an earlier step.

Use the following statements to add your DBEFiles to DBEFileSet ALBUMFS:

   isql=> ADD DBEFILE AlbumTables Return

   > TO DBEFILESET ALBUMFS; Return

   isql=> ADD DBEFILE AlbumIndex Return

   > TO DBEFILESET ALBUMFS; Return

   isql=> COMMIT WORK; Return

Don't forget to COMMIT WORK!



Creating DBEFiles for Table and Index Data
  		 


Adding a DBEFile to the SYSTEM DBEFileSet  
Feedback to webmaster