Subject | Re: [IBO] External File |
---|---|
Author | Aage Johansen |
Post date | 2005-06-22T19:51:50Z |
ahmetel wrote:
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.
> I've found description below from IBPhoenix Development website butIn "Using Firebird" I've seen something like:
> I couldnt success it.
>
> CREATE TABLE Foo [ EXTERNAL
> [ DELIMITED [ DELIMITOR 'symbol' ] [ SEPARATOR 'symbol' ] ]
> [ FILE ] 'pathname' ] ( ... )
>
> is this syntax wrong?
>
> ahmet,
>
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.