Friday, 16 August 2013

Not allowing to make a VIEW on a Logical View

Not allowing to make a VIEW on a Logical View

I am trying to make a VIEW and get the error message below. This seems
strange. I thought you can make a VIEW on LOGICAL FILE?
Logical file OEORH1 in ASTDTA not valid for CREATE VIEW.
CREATE VIEW astccdta.acwocmpk AS (
SELECT
ALL T01.OHORD#, T01.OHORDT, T01.OHORDD, T01.OHSLR#,
T01.OHTTN$, '' as WWDTA
FROM ASTDTA.OEORH1 T01,
ASTCCDTA.OETRA99 T02
WHERE T01.OHORD# = T02.OTORD#
AND( T02.OTTRNC = 'WOC')
UNION
SELECT
ALL T01.OHORD#, T01.OHSLR#, T01.OHORDT, T01.OHORDD,
T01.OHTTN$,
SUBSTR(RFDTA,1,20) AS WWDTA
FROM ASTCCDTA.WOCREPS T01,
ASTCCDTA.REPREF1 T02
WHERE T01.OHSLR# = T02.RFSLC)

No comments:

Post a Comment