At 05:26 PM 10/24/2002 -0500, Yolland, George wrote:

>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 your table looks like this:

T1 f1 integer, f2 integer, f3 timestamp

define your external table as

T1_ext f1 char (9), f2 char (9), f3 char (25).

Don't use varchar.

Regards,


Ann