>Yes, I just gave the basic command structure, but you might need to use the NAME clause, as you say. Also, as you say, you'll lose most DBC properties with COPY TO. It's for quick & simple tasks...
>
>Another little gotcha with it I've had is trying to shuffle tables between DBCs with the same name and different paths. There's confusion over which dbc is the one in the DATA clause. I've had to resort to renaming one DBC to get the job done...so there are some caveats about COPY TO DATA, no doubt about it...

Bruce --

I have 6.0 but haven't been able to do much with it yet...wonder if the COPY TO command hs been improved in this respect?

Bill