Table Name

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

If you want to use keywords as table names, you must place them in double quotation marks.

Syntax

<table_name> ::= [<schema_name>.]<identifier>

<schema_name> ::= <identifier>

<table_name>

Name of the table

see also: SQL Reference Manual, Table Name (table_name)

<schema_name>

Name of the schema

See the SQL Reference Manual, Schema Name (schema_name)

Examples

EXPORT TABLE hotel.room 
  DATA OUTSTREAM 'room_csv.data'

The application data of the table ROOM is to be exported.

IMPORT TABLE hotel.room
  
DATA INSTREAM 'room_csv.data'
    hno         1
    type        2
    free        3
    price       4

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

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

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.

Explanation

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

See also:

EXPORT TABLE Command

IMPORT TABLE Command

EXPORT COLUMNS Command

IMPORT COLUMNS Command

UPDATE COLUMNS Command

Selecting Data Records