On 29-8-2018 10:13, bog...@mordicom.si [firebird-support] wrote:
> 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
Not necessarily, padding with spaces up to the declared length works as
well.
Hello guys,
Thank you all for your responses.
Mark & Karol, thanks also for the explanation. Your suggestions have worked
for me and now when I query the table the results look correct.
Regarding the number of rows, there will be around 240,000 - 250,000
Cheers
Vaughan
On 29-8-2018 03:27, 'Vaughan Wickham' v...@zeb.com.au [firebird-support]
wrote:
> I need to add a large number of IP addresses to an existing table in a
> database.
>
> After doing some research, I came to the conclusion using an external
> file as a table would do the job.
>
> So I’ve
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