>I need to copy a dbf to a text file. COPY TO ...TYPE SDF works great except for one little problem, it does not zero fill numeric fields. I am creating a file for use on our main frame and it needs zero filled numerics.
>
>Does anybody know of an easy solution to this problem?
You might try converting the numeric fields to character before the COPY TO (or through an SQL-SELECT)
>
>Thanks.