Re: getting error on this view

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

yes will do, I only use strsql, actually want to know if you can enter
these statements in Navigator?


On Sun, Sep 15, 2013 at 10:10 AM, Vernon Hamberg
<vhamberg@xxxxxxxxxxxxxxx>wrote:

> 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%'
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.