HP 3000 Manuals HP 3000 Manuals
Chapter 8 SQLMigrate Syntax Summary
Invocation
: RUN SQLMIG.PUB.SYS
SQLMigrate Commands
SQLMigrate Command Summary
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| ADD DBEFILE | Associates a DBEFILE with the SYSTEM DBEFileSet. |
| | |
| CREATE DBEFILE | Defines and creates a DBEFile of TYPE MIXED. |
| | |
| EXIT | Terminates SQLMigrate execution. |
| | |
| HELP | Displays SQLMigrate commands and descriptions. |
| | |
| MIGRATE | Modifies a DBEnvironment to make it compatible with a different |
| | release of HP SQL software. |
| | |
| PREVIEW | Checks for errors that might occur during the migration of the |
| | DBEnvironment which would cause the migration to fail. |
| | |
| QUIT | Terminates SQLMigrate execution.[REV BEG] |
| | |
| REPAIR | Checks for and repairs migration corruption that may have been |
| | caused by a previous release of ALLBASE/SQL.[REV END] |
| | |
| SET | Sets operational options. |
| | |
--------------------------------------------------------------------------------------------
Table 8-0. SQLMigrate Command Summary (cont.)
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| SHOW 'DBEName' | Displays the current version number of the specified |
| VERSION | DBEnvironment, and the release of HP SQL with which it is |
| | compatible. |
| | |
| SHOW VERSIONS | Displays the DBEnvironment versions and corresponding target |
| | releases of HP SQL supported by the current release of |
| | SQLMigrate. |
| | |
| : | Escapes temporarily to the operating system for the execution of |
| | a single operating system command. |
| | |
--------------------------------------------------------------------------------------------
ADD DBEFILE
ADD DBEFILE DBEFileName TO DBEFILESET SYSTEM;
CREATE DBEFILE
CREATE DBEFILE DBEFileName WITH PAGES = DBEFileSize, NAME
='SystemFileName';
EXIT
EXIT;
HELP
HELP;
MIGRATE
MIGRATE 'DBEnvironmentName' {FORWARD [TO 'Version']};
{BACKWARD TO 'Version' }
PREVIEW
PREVIEW 'DBEnvironmentName' {FORWARD [TO 'Version']};
{BACKWARD TO'Version' }
QUIT
QUIT;
REPAIR
REPAIR 'DBEnvironmentName';
SET
SET Option OptionValue;
SHOW 'DBEnvironmentName' VERSION
SHOW 'DBEnvironmentName' VERSION;
SHOW VERSIONS
SHOW VERSIONS;
:
>> : CommandName;