How to work with external tables

CREATE EXTERNAL TABLE ‘d:\\customers.bin’
USING
(
COMPRESS true
FORMAT ‘internal’
REMOTESOURCE ‘ODBC’
)
AS
SELECT *
FROM customers;

INSERT INTO customers
SELECT *
FROM EXTERNAL ‘d:\\customers.bin’
USING
(
COMPRESS true
FORMAT ‘internal’
REMOTESOURCE ‘ODBC’
);