Re: ASCII ex-import

In <DBIuLA.2Fr_at_genesis.westend.com> fiechtl_at_genesis.westend.com (Reinhard Fiechtl) writes:
>
>Hi everybody,
>
>Are there any tools to export data from a database to an ascii file.
>It should be possible to to select single rows to ex- and import.
>
>We are developing a db and we have to change the structure in some
>parts. But there is data in the db So, such a tool would be very
>useful for us.

If you're just trying to change the structure of a table I'm not sure why you'd need to export to an ascii file. Just create new tables the way you want them and insert data into them directly from the old tables. But if you must create ascii files try something like the following..

SET PAGESIZE 0
SET HEADING OFF
SET FEEDBACK OFF
SPOOL filename.dat

SELECT col_a || chr(9) || col_b || chr(9) || col_c FROM table
WHERE filter_criteria = whatever
;
SPOOL OFF Hope this helps.

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!