SET Command 
This SAP DB Loader
command to
create a
database session
allows you to define many properties of a database session.
Syntax
bool_spec>
| SET CODETYPE <standard_code_spec>
| SET <code_page_spec>
| SET COMPRESSED '/<s>/<d>/'
| SET DATE <standard_date_mask>
| SET LANGUAGE 'ENG|DEU'
| SET MAXERRORCOUNT <valMAXERRORCOUNT>
| SET <null_spec>
| SET <number_spec>
| SET TIME <standard_time_mask>
| SET TIMESTAMP <standard_timestamp_mask>
| SET TRANSACTION SIZE
<valTRANSACTION_SIZE>
|
COMPRESSED ' /<s>/<d>/' |
Characters used in the COMPRESSED format to separate or select data; current value can be changed for individual commands <s> Character used to separate data fields, default value: comma, value must be exactly one character long, and cannot be blank <d> Character used to select data, default value: double
quotation marks, value can be exactly one character long or blank, |
|
LANGUAGE ' ENG|DEU' |
Language in which
the messages of the database instance and the SAP DB Loader appear |
|
MAXERRORCOUNT <valMAXERRORCOUNT> |
Definition of how
many errors the SAP DB Loader accepts during the processing of an individual
command before processing of the command is terminated |
|
TRANSACTION SIZE <valTRANSACTION_SIZE> |
Defines the number
of data records after which a |
You can adjust predefined values of the control parameters of the SAP DB Loader to your requirements.

The new values are only valid for the current database session and must be restored if they are needed in subsequent sessions.