SELECT DISTINCT * FROM Table INTO TEMP Temp1;

SELECT * INTO r_temp1.* FROM Temp1

DEFINE r_temp1 RECORD LIKE Table.*

DEFINE r_temp1 RECORD
               col1 LIKE Table1.ColumnA,
               col2 LIKE Table2.ColumnB,
               ...
               colN LIKE TableZ.ColumnZ
               END RECORD