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: ibm, msf, ora, or pgr.
DATABASELINK This attribute is the database link.
HOST host[:port]

for the

Oracle

Server database server.
LOGGINGDIRECTORY

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

For each 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, C:\This\is\an\example should be C:\\This\\is\\an\\example.