HP 3000 Manuals

How Do I Create a DBEnvironment? [ Getting Started with HP IMAGE/SQL ] MPE/iX 5.0 Documentation


Getting Started with HP IMAGE/SQL

How Do I Create a DBEnvironment? 

You use the SQL START DBE NEW statement to create a DBEnvironment:

     START DBE 'DBEnvironmentName' NEW

Once the DBEnvironment exists, you can create databases within it.

The START DBE NEW statement lets you supply options to specify many of
the run-time characteristics of the DBEnvironment.  The simple form of
the statement shown above uses default values for these options.  The
defaults are described in detail in the ALLBASE/SQL Database 
Administration Guide chapter entitled "DBEnvironment Configuration and
Security."

When you create a DBEnvironment, you are granted the broadest kind of
authority--permission in an IMAGE/SQL DBEnvironment--to create and remove
objects.  This authority is known as DBA (database administrator)
authority.



MPE/iX 5.0 Documentation