Subject | RE: [firebird-support] External files |
---|---|
Author | Zoe Lobi |
Post date | 2012-06-16T13:29:09Z |
Thanks HTH for your reply. I just finished re-reading Data Definition of IB6, Chapter 6, where I found that rows must have fixed-length and I was using a file where fields are separated by comma.
Anyway, because I cannot replace any comma with blanks as said on chapter 6 (there are near 2,800,000 rows), I have to write code to do this job.
But I think Firebird Team can revisit this paradigm which is very old. A suggestion, they can allow parameters in DDL so we have something like this :
CREATE TABLE table EXTERNAL external_file OPTIONS
In the OPTIONS, users can determine field separator, assume missing values as NULL, skip first line or not, etc. Maybe I am wrong but it's just a suggestion.
Thanks again.
[Non-text portions of this message have been removed]
Anyway, because I cannot replace any comma with blanks as said on chapter 6 (there are near 2,800,000 rows), I have to write code to do this job.
But I think Firebird Team can revisit this paradigm which is very old. A suggestion, they can allow parameters in DDL so we have something like this :
CREATE TABLE table EXTERNAL external_file OPTIONS
In the OPTIONS, users can determine field separator, assume missing values as NULL, skip first line or not, etc. Maybe I am wrong but it's just a suggestion.
Thanks again.
[Non-text portions of this message have been removed]