Subject Re: [firebird-support] external
Author Martijn Tonies

> I am working with table with external file with an
> idea that it will boost firebird performance.

You cannot use External File tables like regular tables.
External Files are plain text files. Firebird cannot
create constraints on it - just as the error message is
telling you.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions

> When I tried to create a Table having with external
> file it has thrown errror when table has PK. Refer
> below isql snippet ,
> SQL> create table ONE external
> 'c:\ExternalTables\one.txt' (ID INTEGER NOT NULL);
> SQL> commit;
> SQL> create table TWO external
> 'c:\ExternalTables\two.txt' (ID INTEGER NOT NULL
> Statement failed, SQLCODE = -607
> unsuccessful metadata update
> -Operation not supported for EXTERNAL FILE table TWO
> SQL> create table TWO external
> 'c:\ExternalTables\two.txt' (ID INTEGER NOT NULL );
> SQL> commit;
> SQL> exit;
> Table One which has no PK has got created
> successfully, but table with PK has thrown error. Same
> table without PK has got created sucessfully.
> Note : In firbird.conf I have set below configuration
> to enable external table creation,
> ExternalFileAccess=FULL
> UdfAccess=FULL
> ExternalTablesDirs=C:\ExternalTables
> Is there is any issue in my set up/configuration. Or
> is this the expected behaviour when we use external
> file? If so and if possible could you explain why?