If you worked for me you would be fired on the spot for referencing work areas by the number or letter. It makes code unreadable and unmaintable.

Also, there's no reason to use macro substitution in the FROM clause.

... SELECT DISTINCT scode, lcode, sec FROM (alias6) ...

>Or even faster
>

>SELECT 38
>ZAP
>alias38 = ALIAS()
>
>SELECT 6
>alias6 = ALIAS()
>
>
>INSERT INTO (alias38) (scode, lcode, sec) 
SELECT DISTINCT scode, lcode, sec FROM &alias6 
GROUP BY scode, lcode, sec
>