This Loader command for creating a database session allows you to define many properties of a database session. You can adjust predefined values of the control parameters of the Loader to suit your own requirements.
The new values are only valid for the current database session and must be restored if they are needed in subsequent sessions.
See also:
Syntax
<set_command> ::=
SET BACKUPTOOL <TSM|NETWORKER|BACKINT>
| SET <bool_spec>
| SET CODETYPE <standard_code_spec>
| SET <code_page_spec>
| SET COMPRESSED '/<s>/<d>/'
| SET DATE <standard_date_mask>
| SET <isolation_level_spec>
| SET MAXERRORCOUNT <valMAXERRORCOUNT>
| SET <null_spec>
| SET <number_spec>
| SET TIME <standard_time_mask>
| SET TIMESTAMP <standard_timestamp_mask>
| SET TRANSACTION SIZE
<valTRANSACTION_SIZE>
<bool_spec>
::= BOOLEAN '<valVALUE_FOR_TRUE>/<valVALUE_FOR_FALSE>'
<standard_code_spec> ::= ASCII | UCS2 | UTF8
<code_page_spec> ::= CODEPAGE [<valCODEPAGE_NAME>]
<standard_date_mask> ::= EUR | INTERNAL| ISO| JIS | USA
<isolation_level_spec> ::= ISOLATION LEVEL
<valISOLATION_LEVEL>
<null_spec> ::= NULL '<valLITERAL>'
<number_spec> ::= DECIMAL '/[<t>]/<d>/'
<standard_time_mask> ::= EUR | INTERNAL| ISO| JIS | USA
<standard_timestamp_mask> ::= EUR | INTERNAL| ISO| JIS | USA
TSM NETWORKER BACKINT |
TSM backup tool (IBM/Tivoli) NetWorker backup tool (Legato) Backup tools that support Backint for MaxDB and Backint for Oracle |
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, |
valMAXERRORCOUNT |
Number of errors that the Loader accepts before the command is cancelled. |
valTRANSACTION_SIZE |
Number of data records before a COMMIT is carried out. |
valVALUE_FOR_TRUE/ |
Defines the
character string for values that are true |
valCODEPAGE_NAME |
Name of code
page If you specify an empty value, the code page is reset to the default value. |
valISOLATION_LEVEL |
Value of the
isolation level to be set |
valLITERAL |
Null value representation; maximum length of 20 characters The Loader default value is ? (a question mark and 19 blank characters). |
t |
Defines the
character for structuring thousands |
d |
Defines the
character used to separate integers from decimal places |
You can define the following information using the SET command:
You use the syntax rule SET BACKUPTOOL <TSM|NETWORKER|BACKINT> to define which external backup tool is to be used.
See also:
You use the syntax rule SET <bool_spec> to define the character string that is used to represent BOOLEAN values that are either unloaded from the database instance or are to be loaded to a database instance in data streams.
The Loader default value is TRUE/FALSE. The character strings can contain a maximum of 10 characters.
You can change the current value for individual commands by using the syntax element <bool_spec> <stream_format_spec>.
In the code specification standard_code_spec, you define the default value for interpreting data streams that contain plain text values. The default value in the Loader is ASCII.
When you load or unload data, you can transform it between various code types. If you load/unload ASCII data into an ASCII database or UCS2 data into a UNICODE database, the data does not have to be converted.
When you load/unload LONG data, you determine the default values by using the syntax rule longfile_code_spec.
You can change the current value for individual commands by using the syntax element <code_spec> <stream_format_spec>.
See also:
If you want to use a particular code page for converting CHAR data from ASCII to UCS2, you can specify the page using the SET command SET <code_page_spec>.
To make user-defined code pages accessible to the Loader for conversions, you first have to load these code pages into the system table CODEPAGE. To do so, proceed as follows:
...
1. In the directory <dependent_path>/env, create a file with the name <valCODEPAGE_NAME>.txt. This file has to be formatted in the same was as the files that are provided by the Unicode consortium at ftp://ftp.unicode.org/Public/MAPPINGS/.
File ISO-8859-8.txt
...
# Format: Three tab-separated columns
# Column #1 is the
ISO/IEC 8859-8 code (in hex as 0xXX)
# Column #2 is the
Unicode (in hex as 0xXXXX)
# Column #3 the Unicode
name (follows a comment sign, '#')
…
0x00
0x00 0x0000 #
NULL
0x01 0x0001 #
START OF HEADING
0x02 0x0002 #
START OF TEXT
0x03 0x0003 #
END OF TEXT
0x04 0x0004 #
END OF TRANSMISSION
0x05 0x0005 #
ENQUIRY
0x06 0x0006 #
ACKNOWLEDGE
0x07 0x0007 #
BELL
0x08 0x0008 #
BACKSPACE
0x09 0x0009 #
HORIZONTAL TABULATION
0x0A 0x000A #
LINE FEED
2.
Load the code page
into the system table CODEPAGE.
To do this, use the SET command. When processing the SET command SET CODEPAGE <valCODEPAGE_NAME>, the Loader first tries to find the specified code
page in the system table CODEPAGE. If the table does not contain the code
page, the SAP DB Loader tries to find the corresponding file <valCODEPAGE_NAME>.txt. If this file exists, it is read, and the
conversion table is entered in the system table CODEPAGE.
If the file is not found, and if the code page is not contained in the system
table, the Loader stops processing the SET command and displays an error
message.
If the SET command is processed successfully, the user-defined code page is available in the system table CODEPAGE.
The Loader reads the required conversion table from the system table CODEPAGE. All subsequent conversions of the CHAR data from ASCII to UCS2 are performed using this conversion table.
You use the syntax rule SET COMPRESSED '/<s>/<d>/' to define the characters that are to be used in the COMPRESSED format for the following purposes.
· To separate data: s
· To select data: d
The current value can also be changed in individual commands.
You use the standard date definition standard_date_mask to specify the format for plain text values in which DATE columns are entered and displayed.
You can change the current value for individual commands by using the syntax element <date_spec> <stream_format_spec>.
See also:
You use the syntax rule SET ISOLATION LEVEL <valISOLATION_LEVEL> to define the value of the isolation level (permitted values: 0,1,10,15,2,20,3,30). If you do not set an isolation level, isolation level 3 is assumed implicitly.
This setting applies to the entire Loader session provided that the isolation level is not changed by another SET ISOLATION LEVEL command.
You can use the USE USER command to set the isolation level for a user and override the value set by the SET command.
The current value can also be changed in individual DATAEXTRACT commands.
You use the syntax rule SET MAXERRORCOUNT <valMAXERRORCOUNT> to define how many errors the Loader should accept when a specific command is executed before it cancels processing of the command.
This value applies throughout a database session or until it is overwritten by another SET MAXERRORCOUNT command.
You use the syntax rule SET <null_spec> to specify the character string used to represent null values that have been loaded from the database instance in data streams.
You can change the current value for individual commands by using the syntax element <null_spec> <stream_format_spec>.
You use the syntax rule SET <number_spec> to specify which characters are to be used in decimal numbers to group thousands and separate integers from decimal places.
If no digit or character is specified for t or d, the Loader uses the default.
If you use this data format definition in the SET command, you also specify the number format for all subsequent commands. In a single Loader session, this applies until a new SET command is executed.
SET DECIMAL '/
/,/'
Specifies the following
number format: 1 999 987,98
SET DECIMAL
'///'
Specifies the following
number format (Loader default): 1999987.98
The current value can also be changed in individual commands.
You use the standard_time_mask to specify the format for plain text values in which TIME columns are entered and displayed.
You can change the current value for individual commands by using the syntax element <time_spec> <stream_format_spec>.
See also:
You use the standard_timestamp_mask to specify the format for plain text values in which TIMESTAMP columns are entered and displayed.
You can change the current value for individual commands by using the syntax element <timestamp_spec> <stream_format_spec>.
See also:
You use the syntax rule SET TRANSACTION SIZE <valTRANSACTION_SIZE> to define the number of data records that are inserted before a COMMIT is carried out.