Option |
Description/Default Value |
-d
|
Performs the syntax check of the data file. The
transactions are not committed to the database, and the errors are
logged into the .stat , .upr , and .err files. |
-l |
Provides more information on the errors. The error
messages are logged into the .stat file. |
-m |
Exports model data |
-b |
Batch size refers to the number of instructions
(items) to be processed in one batch for a database operation.
Default size is 1. |
-ds <dbservice> |
Specifies the service name to identify the entry in
the dbload.cfg file. |
-f <filename> |
Specifies the name of the data file. |
-dr |
Turns on the mode to return data, during editing of
items. |
-sf <filename> |
By default specifies the name of the status file.
.stat suffix is added to the data processing file name. |
-ef <filename> |
By default specifies the name of the error file.
.err suffix is added to the data processing file name. |
-uf <filename> |
By default specifies the name of the file to create
an unprocessed data file. .upr suffix is added to the data
processing file name. |
-c |
Ensures that the data is not committed to the
database. |
-t |
Target database for which data is exported. This
option is used to take care of the differences in data types between
Oracle and DB2. For example, <-t oracle> when used against a DB2
database creates an export file suitable for import into a Oracle
database. <-t db2> when used against an Oracle database creates an
export file suitable for import into a DB2 database. Default value
is oracle. |
-ea |
Specifies the failure mode to abort during editing
of items. Default value is Continue. |
-cx |
Turns off execution of all the custom functions
during processing. |
-p |
Turns off permissions check when processing the data
file. You should be an CES user with permission to edit to
execute this option. |
-rv |
Turns off required values validation when processing
the data file. |
-vc/-v |
Turn off valid values validation when processing the
data file. |
-ac |
Turns off all permissions, valid values, and required
values. Use this option with caution. |
-ee |
Turns on to evaluate expressions. |
-pc |
Turns off checking of primary keys during the data
file processing. During file processing, duplicate records can get
inserted into the database. This option can be used only when you
are sure about
the data in the file. |
-iu |
Performs an insert operation if the object does not
exist in the database, otherwise performs modify operation. |
-ki |
Retain information such as user information and time
stamp when importing data. Updates import information. |
-w |
Specify the number of parallel processes that should
occur during the import of data. Default value is 1. |
-cf |
Specifies the location of the dbload.cfg file. Use
this option if the configuration file is not present in the
current working directory in client installation or
<installed path>/<OS>/resources/sdm/exploreJS/admin/configs directory in server installation. |
-ug user1,user2... |
Assign permission on items for the specified users.
You need super user privileges to assign permission. |
-ur user1,user2... |
Revoke permission on items for the specified users.
You need super user privileges to revoke permission. |
-gg group1,group2... |
Assign permission on items for the set of groups
specified. You need super user privileges to assign permission. |
-gr group1,group2... |
Revoke permission on items for the set of groups
specified. You need super user privileges to revoke permission. |
-xp |
Exports item level permission. |
-xh |
Exports hidden properties. |
-xm |
Exports metadata when exporting model, unit of
measurement, UCF, auto sequence, logical data types. |