The Options section lists certain global settings that
determine the way the tool processes the file. Including the Options
section in the data file allows you to set different default values for the
different sets of transactions.
Note: The Options section of the data file is not mandatory to run the tool
successfully.
Item |
Explanation |
statusFile
|
Specifies the name of the status file. The default
file name is the name of the data file with the file extension
.stat appended to it. |
errorFile
|
Specifies the name of the error file. The default
file name is the name of the data file with the file extension
.err appended to it. |
uprFile
|
Specifies the name of the unprocessed records file.
The default file name is the name of the data file with the file
extension *.upr appended to it. |
commit
|
Specifies whether to commit or undo database changes
performed in the data transactions.
When the option is set to True , the data import tool
authorizes all database changes, otherwise, the tool does not make
changes to the database. The commit option is True
by default. You can use this option to test your file for errors
without actually making any database changes. You can check the
validity of the database transactions and the syntax of your data
file. |
errorHandle
|
Specifies whether to abort or continue after
encountering an error when processing an instruction. The default is
Continue . |
customFuncExec
|
Specifies whether to turn on execution of all custom
functions during processing. The default is True . |
disableAllChecks
|
Disables all checking. This switch turns off the
checking for valid values, primary keys uniqueness, permission, and
required values. It overrides the permissionCheck option
and the
validValuesCheck option. The default is False . |
permissionsCheck
|
Specifies permission checking. The default is
True . |
validValuesCheck
|
Specifies valid values checking. When valid values
checking is True , the tool confirms that any inserted or
updated values match the enumerated or range values defined for the
particular
class property. The tool reports an error if a given value does not
correspond to the values defined for the particular class property.
The default is True . |
keepImportInfo
|
Retains information such as signature and time stamp
when importing data |
requiredValuesCheck
|
Turns off required values validation when processing
the data file. |
insertorupdate
|
Performs an insert operation if the object does not
exist in the database, otherwise performs modify operation. Default
is False . |