Hi,

> Similar...but not identical - but if you can export your data in fixed
> format, you can define the output file inside the database as an external
> table.

I export the data in this format:

field1|field2|field3|field4|field5|

> You can either assign data types right off (if you have fields that
> are castable) or you can read it in as chars and select it into another
> table with castings, using DSQL or a stored procedure. I nearly always use
> the second route because it allows me to validate the incoming data at the
> same time.i

I'll look at that way of doing. Any pointers to documentation to define
the file as an external table?

> The datapump tool in IB_SQL (free at www.ibobjects.com) is
> great for this as you can do a very fine-grained conversion.
>

I'm afraid I can't use it as I work under Debian GNU/Linux and really
don't want to install a windos box.


Thanks for your help. I think I'm going to be a fervent firebird
supporter :-)

Raph

> Apart from that, there are numerous third-party tools around which can be
> used. (Third-party tools are the life-blood of Firebird!) Check out the
> Contributed Downloads page at the ibphoenix site - www.ibphoenix.com
>
> cheers,
> H.
>
> All for Open and Open for All
> Firebird Open SQL Database ? http://firebirdsql.org ?
> http://users.tpg.com.au/helebor/
> _______________________________________________________
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>