Page History
...
select '\\' || ta.c_table_cd || ont.c_fullname as key,
'\\' || ta.c_table_cd || ont.c_fullname as local_key
from ONT_TABLE1 ont
join table_access ta on substr(ont.c_fullname,1,length(ta.c_fullname)) = ta.c_fullname
where ont.c_visualattributes not in ('FH','FI','LH','LI')
UNION
select '\\' || ta.c_table_cd || ont.c_fullname as key,
'\\' || ta.c_table_cd || ont.c_fullname as local_key
from ONT_TABLE2 ont
join table_access ta on substr(ont.c_fullname,1,length(ta.c_fullname)) = ta.c_fullname
where ont.c_visualattributes not in ('FH','FI','LH','LI')
UNION
select '\\' || ta.c_table_cd || ont.c_fullname as key,
'\\' || ta.c_table_cd || ont.c_fullname as local_key
from ONT_TABLE3 ont
join table_access ta on substr(ont.c_fullname,1,length(ta.c_fullname)) = ta.c_fullname
where ont.c_visualattributes not in ('FH','FI','LH','LI')
etc.. (continued for each ontology table)
NOTE: If your local concepts are the same, but your local TABLE_ACCESS table uses different C_TABLE_CD values, then you will need to edit the prepended C_TABLE_CD values for column 2
...