Yes, FlameRobin which I use needs the SET TERM^^ ; and SET TERM ; ^^ to make your statement work.  That too has the same result now as the SP route you had suggested.

I do see that we have come a full circle and have the need to provide fixed column names.  But all is not lost, I think I can use the output in the front end app to have an efficient cross tab created without knowing what cCode are created.

Thanks a lot.

Kind regards

Bhavbhuti