sqldbcopy - Copy database file between data areas using SQL code

sqldbcopy [-H] -P propertiesFile [-D directivesFile]

sqldbcopy executes SQL code that upgrades one Lawson database file from one data area to another.

At a command prompt, specify the information above.

Program Option Description
-H Print detailed usage.
-P Input file name and path for setting properties.
-D Directives file defining which Lawson files or data locations to include or exclude in the data copy

Properties File

Consider the following options:

Attribute Description
SRCSCHEMA This attribute is the source schema. It overrides the value set in the cap file when OVERRIDE is TRUE.
DSTSCHEMA This attribute is the destination schema. It overrides the value set in the cap file when OVERRIDE is TRUE.
SRCDATAAREA This attribute is the source data area.
DSTDATAAREA This attribute is the destination data area.
DBTYPE This attribute is the database type: msf, ora, or ibm.
DATABASELINK This attribute is the database link.
HOST host[:port] for the Oracle or Microsoft SQL Server database server.
LOGGINGDIRECTORY

This attribute is the directory name and path where message and log files are written to.

For each Lawson file that failed in the copy, warnings and errors are logged in a message file LawsonFile.msg.

For each run, results are logged in sqldbcopy.log.timestamp.

DIRECTIVESFILE This attribute is the input file name and path. This value is overridden when the -D option is specified at the command line.
FIELDDATFILE This attribute is the input file name and path for initializing destination file fields.
DEGREEOFPARALLELISM This attribute refers to the degree of parallelism.
RECREATETABLE

This attribute is set to TRUE if you want to drop and recreate the table before the copy. The default value is FALSE.

If the value is set to TRUE, indexes are created only at the end of the copying process.

DONOTEXECUTE This attribute is for not executing in the database. This attribute can have a value of either TRUE or FALSE.
OVERRIDE This attribute allows the values for srcschema and dstschema to override the actual schema values in the source and destination database configuration cap files. it can have a value of either true or false.
TRACE This attribute prints SQL commands to LOGGINGDIRECTORY/sqldbcopy.sql. This attribute can have a value of TRUE or FALSE. The default value is FALSE.
Note: Property values that include back slashes must be escaped with a back slash. For example, $This\is\an\example should be $This\\is\\an\\example.

Directives File

This attribute is an input file name and path of directives defining which Lawson files or data locations should be copied. The directives or entries in the input file are defined as follows:

A [AllFiles] <Y | N>

D <Include | Exclude> DatLocation

F <Include | Exclude> LawsonFileName

Note: The A directive is mandatory and specifies whether all Lawson files in the data area are to be processed.