When XYZ performs the select statements, the "new" tables will be in XYZ's default tablespace....

Make sure you use some never non-true evaluation such as where 1=2 (don't need to truncate otherwise, but you can if you're wanting to use where empcode=0 or something like that).

Otherwise, as pointed out where 1=2 will suffice.

[Edited by stecal on 05-20-2002 at 02:11 PM]