Syntax documentation SET Command Locate the document in its SAP Library structure

This SAP DB Loader command to create a Structure linkdatabase 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,
if it is blank, no delimiter is defined

LANGUAGE ' ENG|DEU'

Language in which the messages of the database instance and the SAP DB Loader appear
ENG: English, DEU: German

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
This value applies during a complete session or until it is overwritten by another SET MAXERRORCOUNT command

TRANSACTION SIZE <valTRANSACTION_SIZE>

Defines the number of data records after which a Structure linkCOMMIT is performed, when inserting data

Use

You can adjust predefined values of the control parameters of the SAP DB Loader to your requirements.

Note

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