Hi Gaylen,

We have a similar application and we're using COPY TO SDF, FILETOSTR and STRTOFILE. It works quite well and easy to debug and support.

>I need to create an ascii file. The data for the ascii file is contained in a number of tables as follows.
>
>*Header line - info comes from policy master file table
>*next line is policy information for policy identified in header record - info comes from policy detail table
>*next line is location information for policy identified in header - info from policy location table
>In all there are about 7 different lines of information associated with the header line. Then another header record for another policy and all the associated detail and so on until all policies are reported.
>
>I have considered using "Text - Endtext" and "copy to xxxx sdf" to create the ascii file with my preference being "text-endtext".
>
>Before I start, I was wondering if anyone had any other suggestion that I should consider.
>
>Thanks in advance.
>
>Gaylen
>
>
>
>
>
>
>Each line in the file has a different format