Ange, et all,

This real close but maybe I should have said is a fixed length ASCII record.
Creating the external table as described below seems to put out the data in
a binary format. If I had a better grip on how to read this it would
probably work but would not be our preference.

Our preference is delimited then fixed length ASCII record.

Any suggestions would be appreciated.

Thanks, George

-----Original Message-----
George Yolland wrote:
<<
I have become involved in a project in which we have to extract some data
out of an application based on Interbase v 5.1 (at least that the version I
am told). We need to move the data to an IBM AS/400 environment so we'd
either like a fixed length record or delimited, mostlikely csv, record.
...

>>

Do you just want to have data in fixed length records? You might insert
the data into an 'external table'.
Create external table, then select data and insert into that table - and
you should have what you want.

Regards,
Aage J.