Vince Ieraci wrote:

>
> Just new to FB, trying to create an external table so I can import
> data (which will be exported from db2) into text files.
>
> CREATE TABLE EXT_TBL EXTERNAL FILE
> '/home/vince/FireBirdData/account_names.txt'
> (
> Account_Code CHAR(4) NOT NULL PRIMARY KEY,

You cannot define a primary key (neither any explicitly defined index)
for an external table. Also, the NOT NULL clause is pointless as well,
as external tables don't support NULL values anyway.


Dmitry