Loader exports the data from databases into data streams or imports data from data streams into databases. The data can be transformed during this process. A range of syntax elements is available for describing the data stream. These syntax elements can be used in the export and import commands.
You can specify the data carrier type as well as the name of the data stream. You can also transfer formats and, if necessary, include other information to describe the data stream in more detail.
You enter the keyword OUTSTREAM to specify that the data is to be exported from a SAP MaxDB database to a data stream.
You enter the keyword INSTREAM to specify that the data is to be imported from a data stream to a SAP MaxDB database.
Syntax
<outstream_columnformat_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' [<column_dataformat_spec>] [<start_spec>] <instream_columnformat_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' [<column_dataformat_spec>] [<start_spec>] <outstream_tableformat_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' [<table_dataformat_spec>] <instream_columnformat_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' [<table_dataformat_spec>]
It may be necessary to specify the format of the data stream (keywords CSV, DDL, FWV [BINARY], PAGES, RECORDS).
Syntax
<outstream_csv_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' [CSV [<csv_format_spec> ...]] [<start_spec>] <instream_csv_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' [CSV [<csv_format_spec> ...]] [<start_spec>] <outstream_ddl_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' DDL <instream_ddl_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' DDL <outstream_fwv_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' FWV [<fwv_format_spec> ...] [<start_spec>] <instream_fwv_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' FWV [<fwv_format_spec> ...] [<start_spec>] <outstream_pages_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' PAGES <instream_pages_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' PAGES <outstream_records_spec> ::= OUTSTREAM [<mediumtype_spec>] '<stream_name>' RECORDS [<records_format_spec> ...] <instream_records_spec> ::= INSTREAM [<mediumtype_spec>] '<stream_name>' RECORDS [<records_format_spec> ...]
<mediumtype_spec> |
|
<stream_name> |
Name and path of the data stream |
CSV |
CSV (Comma Separated Values) is a format for CHAR data in which a data line must at least be long enough to represent the data. The assignment of a data field of the data stream to a column in the table is defined by the position specification. |
FWV |
FWV (Fixed Width Values) is a format for plain text values in which a data line in the data stream corresponds to a data record. The assignment between data fields in the data stream and table columns is defined by the position specification. |
FWV BINARY |
FWV BINARY (Fixed Width Values BINARY) is a format for binary values in which all data fields have the same fixed length. The assignment between the data fields in the data stream and the table columns is defined by the position specification. Unlike the FWV format, a data record does not end with an additional line break. |
PAGES |
Format that specifies that the application data is stored in pages |
RECORDS |
Database format |
DDL |
DDL (Data Definition Language) is a format that can be specified for a data stream with database catalog data |
<column_dataformat_spec> <table_dataformat_spec> <csv_format_spec> <fwv_format_spec> <records_format_spec> |
|
<start_spec> |
Syntax
End of the code. Export: the area defined by start_spec is exported from a table. Import: the area defined by start_spec is imported from the data stream. You can specify the starting point of the area (START <unsigend_integer> [MAXROWS] or START <unsigend_integer> [MAXRECORDS]) or the upper and lower limits for the area (START <unsigend_integer> <unsigend_integer>). |
For more information see CSV, FWV, FWV BINARY, PAGES, RECORDS. If you are handlingLOB values, you need to adhere to syntax rules outstream_lob_spec and instream_lob_spec.
The commands for exporting and importing uses the keywords CATALOG, DATA, CONFIGURATION and PACKAGE to differentiate the type of data that is exported or imported.
Data streams for the database catalog information of the application data (keyword CATALOG)
Syntax
<catalog_outstream_spec> ::= CATALOG <outstream_ddl_spec> <catalog_instream_spec> ::= CATALOG <instream_ddl_spec>
Data streams for the application data (keyword DATA)
Syntax
<data_outstream_column_spec> ::= DATA <outstream_columnformat_spec> [<export_lobcolumn_spec> ...] <data_outstream_part_spec> ::= DATA <outstream_tableformat_spec> <data_outstream_table_spec> ::= <data_outstream_part_spec> | <data_outstream_column_spec> <data_instream_column_spec> ::= DATA <instream_tableformat_spec> <data_instream_columns_spec> ::= DATA <instream_columnformat_spec> [<import_column_spec> ... <import_lobcolumn_spec> ...] [<usage_spec>] <data_instream_part_spec> ::= DATA <instream_tableformat_spec> <data_instream_table_spec> ::= <data_instream_part_spec> | <data_instream_columns_spec>
The application data of selected tables can be excluded from the export or import (keyword CONFIGURATION)
Syntax
<configuration_spec> ::= CONFIGURATION <instream_csv_spec>
Data stream with the entries from the TRANSFORMATIONMODEL system table (keyword PACKAGE)
Syntax
<package_spec> ::= PACKAGE <outstream_csv_spec>
Example
IMPORT TABLE hotel.room
DATA INSTREAM 'room_csv.data'
The application data (DATA) stored in the room_csv.data data stream (INSTREAM) is imported (IMPORT) to the ROOM table in the HOTEL schema. The data carrier type for the room_csv.data data stream is a file (FILE, default value). The format of the data stream is CSV (default value).