Hi all,

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,
Account_Name CHAR(30),
Claimable CHAR(1),
Tax_Code CHAR(1),
GST_Code CHAR(1),
NEWLINE CHAR(1)
);

The table seems to get created fine, but when I try to commit,
it gets rejected. The message is:

*** IBPP::SQLException ***
Context: Transaction::Commit

SQL Message : -607
This operation is not defined for system tables.

Engine Code : 335544351
Engine Message :
unsuccessful metadata update
Operation not supported for EXTERNAL FILE table EXT_TBL

The message "not defined for system tables" is saying something, but
what ?

If it's relevant, I'm running the script from FlameRobin query window.