Background documentationTable Name Locate this document in the navigation structure

 

The syntax rule table_name specifies the table name in Loader commands for exporting and importing data.

Structure

Syntax Syntax

  1. <table_name> ::=
  [<schema_name>.]<identifier>
End of the code.

You use the syntax rule table_name to specify the name(s) of the target table(s) in Loader commands for exporting or importing data.

Example

Example Example

EXPORT TABLE hotel.room

DATA OUTSTREAM 'room_csv.data'

End of the example.

The application data from table ROOM is exported.

Example Example

IMPORT TABLE hotel.room

DATA INSTREAM 'room_csv.data'

  hno      1

  type  2

  free  3

  price  4

End of the example.

The application data from file room_csv.data is imported into the specified columns of table ROOM.

Example Example

IMPORT TABLE hotel.room

IF POS 06–11 = 'double'

DATA INSTREAM 'room_csv.data'

  hno      01-05

  type  06-11

  free  12-15

  price  16-22

End of the example.

You only want to import those data records from the data stream room_csv.data into the target table ROOM in which double is specified as the room type.

More Information

EXPORT TABLE Command

IMPORT TABLE Command

EXPORT COLUMNS Command

IMPORT COLUMNS Command

UPDATE COLUMNS Command

Selecting Data Records

Loader Commands and SQL Statements

SQL Reference Manual, Table Name (table_name)