Subject Re: [IBO] External File
Author Aage Johansen
ahmetel wrote:
> I've found description below from IBPhoenix Development website but
> I couldnt success it.
>
> CREATE TABLE Foo [ EXTERNAL
> [ DELIMITED [ DELIMITOR 'symbol' ] [ SEPARATOR 'symbol' ] ]
> [ FILE ] 'pathname' ] ( ... )
>
> is this syntax wrong?
>
> ahmet,
>

In "Using Firebird" I've seen something like:
CREATE TABLE EXT_TBL EXTERNAL FILE filespec
(columndef [,columndef,...],
linedelimiter1 CHAR(1)[, linedelimiter2 CHAR(1)]);
(give or take a little...)
The linedelimiters are used for CR/LF or LF.


--
Aage J.