Re: getting error on this view

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

You are missing an AND near the end, in the final WHERE clause.

Try running this in STRSQL - it should put the cursor on the position 
where it thinks the error is. That is, on WHICH OEINDLID might be the 
problem.

HTH
Vern

On 9/15/2013 8:51 AM, Hoteltravelfundotcom wrote:
> I am getting this error: " Column qualifier or table OEINDLID
> undefined. "  can u see what is wrong here? I am new to VIEWS i have
> done only 1 view previously.
>
>
> CREATE VIEW astccdta.acsusage
> AS
> SELECT ICPRTMIA.IARCC9, OEINDLID.IDDOCD, OEINDLID.IDCOM#,
> ADRESSAD.ADSFX#, OEINDLID.IDPRT#, OEINDLID.IDGRC#, OEINDLID.IDENT#,
> OEINDLID.IDSFX#, OEINDLID.IDPRLC, OEINDLID.IDNTU$, OEINDLID.IDSHP#,
> ADRESSAD.ADFNM, ADRESSAD.ADLNM, OEINHDIH.IHVIAC, ADRESSAD.ADSTTC,
> OEINDLID.IDINV#, (
> SELECT
>      SUM (T01.IDNTU$)
> FROM
>      ASTDTA.OEINDLID T01
> WHERE
>      T01.IDCOM# = '001' AND
>      T01.IDDOCD = OEINDLID.IDDOCD AND
>      T01.IDINV# = OEINDLID.IDINV# AND
>      T01.IDPRLC LIKE 'F%'
>
> )
>   FROM   (ASTDTA.OEINDLID
> INNER JOIN ASTDTA.ICPRTMIA ON OEINDLID.IDPRT#=ICPRTMIA.IAPRT#)
> INNER JOIN (ASTDTA.ADRESSAD
> INNER JOIN ASTTRN.OEINHDIH ON ADRESSAD.ADENT#=OEINHDIH.IHENT#)
> ON OEINDLID.IDIDC#=OEINHDIH.IHIDC#
>   WHERE  ICPRTMIA.IARCC9='ACS'
> OEINDLID.IDCOM#='001'
> AND OEINDLID.IDPRT# LIKE 'ACS%'