On Thu, 17 Jan 2002 11:48:15 -0000, svvikki wrote:

>Have any of you done data pumping from Dbase to interbase.
>
>If so help me how to map the datas,overcoming foreign key,primary
>key,not null constaraints.

One way is using external tables. If after you use them, drop and recreate
to use the file again. After its creation, use stored procedures to normalize
the data to your data schema. Of course, you need to export to text files in
which all fields are delimited by its length (so, if the first field is a character field
with 31 chars of length, the 2nd field begins at the 32th byte and so on...). I really
forgot the technical name for it...
How to do? Most are explained on Interbase documentation (in PDF files).

>
>Another problem i have is in Dbase 5 fields but in IB 10 fields how
>to overcome this also.

What you call "dBase 5" fields? If I understood correctly, is datatypes
dB5 specific, don't? Well, I don't remember what these datatypes are,
so you have compare them with the ones on Interbase and what you
can use to accomplish the same thing.


[]s Fabricio
Systems Developer