| Subject | RE: [firebird-support] Using External File as Table |
|---|---|
| Author | |
| Post date | 2018-08-29T08:13:02Z |
Hi
Beside that also:
file must have fixed record size .
So IP must be 15 chars long, all zeros in place
192.068.001.001 and not 192.68.1.1
Regards
Bogdan
From: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Sent: Wednesday, August 29, 2018 9:58 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Using External File as Table
Hi,
Change your table declaration to include separator e.g. line break.
(
IP_Address CHAR(15),
Myln char(1)
);
If you have windows style linebreak change myln to 2 chars.
External table is a fastest way, but you must define what do you mean in your scenario as "large".
Regards,
Karol Bieniaszewski