--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> 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.

Of course !
Thank you.