>I have an additional requirement that I did not include in my first message.
>
>That is that I need to end up with an ASCII file with data that is delimited with a tilde (~) for both numeric and character data ie; abc~123~def. The data cannot have leading or trailing blanks.
>
>I hope, trust and pray that there is a way to do this programatically.
>
You git the answer before: COPY TO ... DELIMITED WITH ~ and then, if you want, clean the file contents using CHRTRAN().