SET SQLDBE

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/iX 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.

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:

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 size of MYDBEFL is 5000 pages, and that of MYDBELG is 10000 pages.

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

   >>