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 statement:

   isql=> CONNECT TO 'MUSICDBE'; Return

Then use the following statement 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/iX 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/iX, 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/iX.

Creating DBEFileSets

Technical documentation

» Table of Contents

» Index