Icon MigratorParams Table

Structure
CREATE TABLE "MigratorParams"
(
"MigratorName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Mode" VARCHAR(15) COLLATE "ANSI_CI",
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"Length" INTEGER,
"Precision" INTEGER,
"Scale" INTEGER,
"DefaultValue" VARCHAR(60) COLLATE "ANSI",
"OrdinalPos" INTEGER
)

CREATE INDEX "MigratorName" ON "MigratorParams"
("MigratorName")

CREATE INDEX "Name" ON "MigratorParams"
("Name")

Description
The migrator parameters are dynamic in ElevateDB and this table reflects the migrator parameters present in the current migrator. The migrator can be changed or modified using the SET MIGRATOR statement. You can find out more about migrating databases in the Migrating Databases topic.

The Mode column values are as follows:

ModeDescription
UnknownThe parameter type is unknown
InThe parameter is an input parameter
OutThe parameter is an output parameter
InOutThe parameter is both an input and output parameter

Related DDL Statements
StatementDescription
None
Image