Page History
...
Here is a example sql query for creating the 1-to-1 Adaptermappings from the ontology and table access tables:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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)
...
Overview
Content Tools