Subject | Re: [IBO] ib_export and *.sch file |
---|---|
Author | Pirtea Calin |
Post date | 2001-08-28T20:37:55Z |
""Jason Wharton"" <jwharton@...> wrote in message
news:08ac01c12ffc$48e229d0$a9c90118@CX170673E...
I mean i tried it on several servers using diferent regional settings.
The fields are separated with (') and the field names with (") also the
datetime is forced to YYYY/MM/DD
and the time to HH:MM:SS. AFAIK it works on ib6 fb094 fb1 and should work
the same on linux and windows
but i don't know for linux. Do you think it is ok this way ? I also thought
about making the files split in case they got too big
but didn't do that yet (this week if i have time). Any sugestions. You are
also right that it is ok only for small tables but if one
uses a program to fetch line by line (or for what it's worth 100lines) and
execute them separatly it works for as long the file can grow (i think 2Gb
on reiserfs but not sure either).
Any sugestions ?
--
Regards,
Pirtea Calin.
SoftScape - Software Development
pcalin@...
news:08ac01c12ffc$48e229d0$a9c90118@CX170673E...
> I suppose that could be a useful addition although it certainly isn't veryquotes
> efficient and would only be useful for smaller tables. Will it handle
> correctly?Yes and maybe !?!
>
I mean i tried it on several servers using diferent regional settings.
The fields are separated with (') and the field names with (") also the
datetime is forced to YYYY/MM/DD
and the time to HH:MM:SS. AFAIK it works on ib6 fb094 fb1 and should work
the same on linux and windows
but i don't know for linux. Do you think it is ok this way ? I also thought
about making the files split in case they got too big
but didn't do that yet (this week if i have time). Any sugestions. You are
also right that it is ok only for small tables but if one
uses a program to fetch line by line (or for what it's worth 100lines) and
execute them separatly it works for as long the file can grow (i think 2Gb
on reiserfs but not sure either).
Any sugestions ?
--
Regards,
Pirtea Calin.
SoftScape - Software Development
pcalin@...