HP 3000 Manuals

Up and Running with ALLBASE/SQL

Creating DBEFileSets 

Before you can create tables and load data into a database, you need to
provide physical file space.  Physical files are known as DBEFiles, and
they are grouped together in logical groupings called DBEFileSets.

After the last step, you exited from ISQL, so you must run ISQL again and
connect to the newly created DBEnvironment MUSICDBE. From the ISQL
prompt, issue the following commands:

     isql=> CONNECT TO 'MUSICDBE'; Return 

Then use the following command to create a new DBEFileSet--ALBUMFS:

     isql=> CREATE DBEFILESET AlbumFS; Return 

Do not forget the semicolon.


NOTE  ALLBASE/SQL upshifts the logical names of objects like ALBUMFS in
      the previous example.  Thus, even though you enter them in mixed
      case (as shown above), they will appear in the system catalog as
      all uppercase.  (We'll see an example later.)

      MPE XL also upshifts all physical file names.  Thus, the names of
      DBEFiles, log files, and DBECon files (including MUSICDBE in the
      previous example), all appear as uppercase in directory displays in
      MPE XL, regardless of whether you entered these names in upper,
      lower, or mixed case.  HP-UX does not upshift file names, so they
      appear in directory displays exactly as you enter them.  Rembember
      that in the CONNECT statement, the name of the DBEnvironment is
      case-sensitive in HP-UX, but it is not case-sensitive in MPE XL.

MPE/iX 5.0 Documentation