Home
Migrating and upgradingYou can upgrade to the 2.0.0.0 version of HCL OneDB™ or migrate from other database servers to HCL OneDB™. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the HCL OneDB™ database server can affect upgrading from a previous release.
HCL OneDB™ Migration GuideThe HCL OneDB™ Migration Guide describes how to move data manually between databases, servers, and computers.
Data migration utilities
The dbschema utilityThe dbschema utility displays the SQL statements (the schema) that are necessary to replicate database objects.
Syntax of the dbschema commandThe dbschema command displays the SQL statements (the schema) that are necessary to replicate a specified database object. The command also shows the distributions that the UPDATE STATISTICS statement creates.
Sequence creationThe dbschema -seq sequence command generates information about sequence creation.

Sequence creation

The dbschema -seq sequence command generates information about sequence creation.

The following syntax diagram fragment shows sequence creation.


Element	Purpose	Key Considerations
-seq *sequence*	Displays the CREATE SEQUENCE statement defining *sequence*	None.
-seq all	Displays all CREATE SEQUENCE statements for the database	None.

Running dbschema with option -seq sequitur might produce this output:

CREATE SEQUENCE sequitur INCREMENT 10 START 100 NOCACHE CYCLE

For more information about the CREATE SEQUENCE statement, see the HCL OneDB™ Guide to SQL: Syntax.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.