Using the create table command

The create table command creates a proxy table and a remote table at the same time with the following syntax:

create table table_name (column_list) [ [ external {table | file}] at “pathname” ]]

The remote location is specified with the at pathname clause. create table allows external object type table and file. The datatype of each column is passed to the remote server without conversion except with server class db2.