Maxim Ness
Active Member
Hello experts,
I am straggling to create a view with subselect in it. When executed the query itself runs fine, but when I attempt to create a view I get an error. Version of iSeries is V5R1. Any suggestions are welcome. Thank you! Here’s the example:
CREATE VIEW V_VZA_DIM_ASSET (
ORGANIZATION_ID,
ORGANIZATION_NAME
)
AS
SELECT
FACO ORGANIZATION_ID,
(SELECT c.CCNAME FROM F0010 c WHERE c.CCCO = a.FACO) as ORGANIZATION_NAME
FROM
F1201 a, F1217 e where a.FANUMB = e.WRNUMB
I am straggling to create a view with subselect in it. When executed the query itself runs fine, but when I attempt to create a view I get an error. Version of iSeries is V5R1. Any suggestions are welcome. Thank you! Here’s the example:
CREATE VIEW V_VZA_DIM_ASSET (
ORGANIZATION_ID,
ORGANIZATION_NAME
)
AS
SELECT
FACO ORGANIZATION_ID,
(SELECT c.CCNAME FROM F0010 c WHERE c.CCCO = a.FACO) as ORGANIZATION_NAME
FROM
F1201 a, F1217 e where a.FANUMB = e.WRNUMB