×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
A Client just upgraded to V7 over the weekend. (Test partition)
Any clue as to what might be wrong? It works well at V5R4.
select e0fcrp, e0djd1, ma.maporf,
coalesce(sf.sfsftl, ni.bdbdr1) as DEPOLREF,
fafamr, a.nananm, fafadl,
e2recd, e2sxcd, e2sdsq, e2ctco,
b.nananm, e3amcd, e3e3a2, e0cvac, c.nananm, E5BRNC,
d.t8t8un, g0djd1, g0djq1, e.t8t8un, t7djd1, t7etim,
ma.mamjcd,
case when lh.lhc8cd is null then e2c1cd else ' ' end as Bus_dis,
case when lh.lhc8cd is not null then e2c1cd else ' ' end as LOB,
case when ma.mamapc not in('DECC', 'GECC', 'DEM', 'DE') then 'EE'
else ' ' end as Eastern_Eurp,
case when ma.mamapc in('DECC', 'DEM') and
coalesce(sf.sfsftl, ni.bdbdr1) like 'W%' then 'BDJ' else ' ' end
as BDJ, dec(1900+int(e0fcrp/100),4,0) as AC_year,
ma.mauwyr + 1900 as Uw_year,
dec(1900+int(fafadl/10000),4,0) as Loss_year,
dec(1900+int(fafada/10000),4,0) as Adv_year
from zumadf00 ma cross join zse0df00 cross join zse2df00,
zse3df00 cross join zse5df00 cross join zkfadf00,
zkg0df00 cross join
zse1df00
left join zkt7df00 on g0fano = t7fano
and g0fbcd = t7fbcd
and g0f3cd = t7f3cd
left join znnadf00 a on ma.mapnsn = a.nanacd
left join znnadf00 b on fafacc = b.nanacd
left join znnadf00 c on E5G0PY = c.nanacd
left join zkt8df00 d on g0t8id = d.t8t8id
left join zkt8df00 e on t7t8id = e.t8t8id
left join
(select sfmanu, sfmase, max(sfsftl) as sfsftl
from zusfdf00, zumadf00 ma1
where sfmanu = ma1.mamanu
and sfmase = ma1.mamase
and ma1.mamapc not in(select lhc8h1 from zhlhdf00 where lhg8cd = 'KP'
group by sfmanu, sfmase) sf on ma.mamanu = sf.sfmanu
and ma.mamase = sf.sfmase
left join
(select nimanu, nimase, bdbdr1
from zunidf00, zubddf00, zumadf00 ma2
where nimanu = ma2.mamanu
and nimase = ma2.mamase
and ma2.mamapc in(select lhc8h1 from zhlhdf00 where lhg8cd = 'KP')
and ninacd = bdnacd
and niissq = bdissq
and ninitp = '3') ni on ma.mamanu = ni.nimanu
and ma.mamase = ni.nimase
left join zhlhdf00 lh on ma.mamapc = lh.lhc8h1 and lh.lhg8cd = 'KP'
Error is:
Vendor Code: -338
Message: [SQL0338] JOIN predicate or MERGE ON clause not valid
Any help is much appreciated.
Regards
Praveen
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.