HP 3000 Manuals HP 3000 Manuals
SET SQLDBE
Defines the SQL DBEnvironment to be used by other IMAGE/SQL utility
commands.
Syntax
SE[T] SQLDBE DBEnvironment [,MAINT=DBE_MaintWord]
Parameters
DBEnvironment is the name of the DBEnvironment with which you want to
work.
DBE_MaintWord is the maintenance word for the DBEnvironment. This
parameter can be omitted if you are an SQL database
administrator (DBA).
Prerequisites
DBECreator status or DBEnvironment maintenance word specified as part of
the command.
Description
Use the SET SQLDBE command to indicate the name of the SQL DBEnvironment
with which you want to work. This name remains in effect until you exit
the program or issue a new SET SQLDBE command. Note that because the
IMAGE/SQL utility supports standard MPE XL user, group, and account
security rules, to issue this command for a DBEnvironment in a different
group and account, be sure you have the correct capabilities.
To work with another DBEnvironment associated with the same TurboIMAGE/XL
database, issue another SET SQLDBE command specifying the new
DBEnvironment.
[REV BEG]
If the DBEnvironment does not exist, IMAGE/SQL displays this message:
DBE does not exist, do you want to create one? [Y/N] :
If you reply 'Y', a DBEnvironment and DBE files are automatically created
for you. The files created are:
-------------------------------------------------------------------------------------------
| |
| File Created File Name |
| |
-------------------------------------------------------------------------------------------
| |
| DBE CON file DBEnvironment-name |
| |
| DBE FILE DBEnvironment-nameFL |
| |
| LOG FILE DBEnvironment-nameLG |
| |
| ATCINFO file DBEnvironment-nameCR |
| |
-------------------------------------------------------------------------------------------
[REV END]
[REV
BEG]
For example, if you issue the command
SET SQLDBE MYDBE
and the DBEnvironment MYDBE does not exist, these files are created:
MYDBE, MYDBEFL, MYDBELG, and MYDBECR.
The default size of DBE FILE and LOG FILE is 1000 pages.[REV END]
Example
In the following example, the PARTSDBE DBEnvironment is specified and is
in effect until you exit the IMAGE/SQL utility or issue another SET
SQLDBE command.
_____________________________________
| |
| >>SET SQLDBE PARTSDBE |
| >> |
_____________________________________