Is there a SET command one can use to turn on Qualified column names in a Hold file?

I have a complex Join and I extract columns with the same names in several tables - I'd like to have the column names in the Hold file qualified with the segment or table name.

Thanks.

I'd use a TAG option to pull the fields and then an ASNAMES ON to give each column a unique name for example

PRINT
T1.ID AS 'T1.ID'
T2.ID AS 'T2.ID'
ON TABLE SET ASNAMES ON
...
Of course with out testing not sure if the '.' carries you forward.

Leah,

Thank you, I'm doing that now (the dot does get carried and behaves as a normal character in the column name). I was hoping that this could be automated.

Cheers,

Still looking for a solution seven years hence...

did you try SET QUALTITLES = ON
i haven't tried it. alas.
but it says:
"Uses qualified column titles in report output when duplicate fieldnames exist in a master file. A qualified column title distinguishes between identical field names by including the segment name.
SET QUALTITLES = {ON|OFF} where
ON uses qualified column titles when duplicate field names exist and FIELDNAME is set to NEW (sic!, which is the default, allows 66char names)
OFF disables the qualified col titles. this value is the default."

quote:

distinguishes between identical field names by including the segment name

I just did a quick test and it did not name the columns differently - probably because the HOLD file is a single segment file...

I believe QUALTITLES only work for column titles in a report, and do not get passed through to a hold file.