Subject RE: [firebird-support] External files
Author Zoe Lobi
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]