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.