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. |
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
.