Nice it looks like a very elegant solution. Why do you have to look at it at such a level?
Rahul On 7/9/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > just a thought but I would find and hurt the man who created these > tables... > > > On Jul 5, 2005, at 1:29 PM, Ashish Kulkarni wrote: > > > Hi > > Thanks, it worked, i am using DB2 on AS400 as database > > for this query > > > > Ashish > > > > --- Larry Meadors <[EMAIL PROTECTED]> wrote: > > > > > >> Any fields with # in them need to be escaped with ## > >> > >> A.PCVER# AS PCVER, > >> > >> - should be - > >> > >> A.PCVER## AS PCVER, > >> > >> > >> ..and... > >> > >> WHERE A.Pcpord = "VALUE# > >> > >> - should be - > >> > >> WHERE A.Pcpord = #VALUE# > >> > >> What db is this? That is a freaky looking join with > >> all the > >> (((((((((((((((( in there. > >> > >> Larry > >> > >> > >> On 7/5/05, Ashish Kulkarni > >> <[EMAIL PROTECTED]> wrote: > >> > >>> Hi > >>> I am not sure why i am getting the above error, is > >>> there a way to debug it. > >>> I am going to paste my xml file definiation here, > >>> I am sure this SQL statement works > >>> the error i am getting is as below > >>> Caused by: > >>> > >> com.ibatis.sqlmap.client.SqlMapException: > >> > >>> Unrecognized parameter mapping field: ' F.P813NAME > >>> > >> AS > >> > >>> P813NAME' in AS BP2FAX, F.P813NAME AS P813NAME, > >>> F.P813PHON AS P813PHON, G.P830DESC AS P830DESC, > >>> A.PCSHPV AS PCSHPV, A.PCFRGT AS PCFRGT, A.PCORIG > >>> > >> AS > >> > >>> PCORIG, A.PCCURR AS PCCURR, A.PCEXCG AS PCEXCG, > >>> A.PCBUYR AS PCBUYR, A.PCBLOR AS PCBLOR, A.PCSRCE > >>> > >> AS > >> > >>> PCSRCE, A.PCVALU AS PCVALU, A.PCAKDT AS PCAKDT, > >>> A.PCVNDT AS PCVNDT, A.PCFXDT AS PCFXDT, A.PCINDT > >>> > >> AS > >> > >>> PCINDT, A.PCSPN1 AS PCSPN1, A.PCSPN2 AS PCSPN2, > >>> A.PCSPN3 AS PCSPN3, A.PCENDU AS PCENDU, A.PCUSF1 > >>> > >> AS > >> > >>> PCUSF1, A.PCUSF2 AS PCUSF2, A.PCUSF3 AS PCUSF3, > >>> A.PCSTAT AS PCSTAT, A.PCCANC AS PCCANC, A.PCVER > >>> > >>> > >>> my sql statement is as below > >>> > >>> SELECT A.PCPORD AS PCPORD , > >>> A.PCVALU AS PCVALU , > >>> A.PCPTYP AS PCPTYP , > >>> A.PCODAT AS PCODAT , > >>> A.PCVNDR AS PCVNDR , > >>> A.PCINVV AS PCINVV, > >>> A.PCSHPT AS PCSHPT, > >>> A.PCBILT AS PCBILT, > >>> A.PCCONF AS PCCONF, > >>> A.PCROUT AS PCROUT, > >>> A.PCASTA AS PCASTA, > >>> A.PCAPVU AS PCAPVU, > >>> A.PCAPVD AS PCAPVD, > >>> A.PCAPVT AS PCAPVT, > >>> A.PCPAYT AS PCPAYT, > >>> A.PCDISC AS PCDISC, > >>> C.P2FAX# AS BP2FAX, > >>> F.P813NAME AS P813NAME, > >>> F.P813PHON AS P813PHON, > >>> G.P830DESC AS P830DESC, > >>> A.PCSHPV AS PCSHPV, > >>> A.PCFRGT AS PCFRGT, > >>> A.PCORIG AS PCORIG, > >>> A.PCCURR AS PCCURR, > >>> A.PCEXCG AS PCEXCG, > >>> A.PCBUYR AS PCBUYR, > >>> A.PCBLOR AS PCBLOR, > >>> A.PCSRCE AS PCSRCE, > >>> A.PCVALU AS PCVALU, > >>> A.PCAKDT AS PCAKDT, > >>> A.PCVNDT AS PCVNDT, > >>> A.PCFXDT AS PCFXDT, > >>> A.PCINDT AS PCINDT, > >>> A.PCSPN1 AS PCSPN1, > >>> A.PCSPN2 AS PCSPN2, > >>> A.PCSPN3 AS PCSPN3, > >>> A.PCENDU AS PCENDU, > >>> A.PCUSF1 AS PCUSF1, > >>> A.PCUSF2 AS PCUSF2, > >>> A.PCUSF3 AS PCUSF3, > >>> A.PCSTAT AS PCSTAT, > >>> A.PCCANC AS PCCANC, > >>> A.PCVER# AS PCVER, > >>> A.PCINCO AS PCINCO, > >>> A.PCDATE AS PCDATE, > >>> A.PCTIME AS PCTIME, > >>> A.PCUSER AS PCUSER, > >>> H.P1NAME AS VP1NAME , > >>> H.P1ADR1 AS VP1ADR1 , > >>> H.P1ADR2 AS VP1ADR2 , > >>> H.P1ADR3 AS VP1ADR3 , > >>> H.P1COUN AS VP1COUN , > >>> H.P1PROV AS VP1PROV , > >>> H.P1CITY AS VP1CITY , > >>> H.P1STE AS VP1STE , > >>> H.P1CTRY AS VP1CTRY , > >>> H.P1ZIP AS VP1ZIP , > >>> H.P1TEL# AS VP1TEL , > >>> H.P1FAX# AS VP1FAX , > >>> H.P1MAIL AS VP1MAIL , > >>> H.P1CONT AS VP1CONT , > >>> A.PCSHPT AS PCSHPT, > >>> B.P2NAME AS SNAME, > >>> B.P2ADR1 AS SP2ADR1, > >>> B.P2ADR2 AS SP2ADR2, > >>> B.P2CITY AS SP2CITY, > >>> B.P2STE AS SP2STE , > >>> B.P2ZIP AS SP2ZIP , > >>> B.P2ATTN AS SP2ATTN, > >>> B.P2PHON AS SP2PHON, > >>> B.P2FAX# AS SP2FAX, > >>> C.P2NAME AS BNAME, > >>> C.P2ADR1 AS BP2ADR1, > >>> C.P2ADR2 AS BP2ADR2, > >>> C.P2CITY AS BP2CITY, > >>> C.P2STE AS BP2STE , > >>> C.P2ZIP AS BP2ZIP , > >>> C.P2ATTN AS BP2ATTN, > >>> C.P2PHON AS BP2PHON, > >>> D.P832DESC AS P832DESC, > >>> E.P834DESC AS P834DESC, > >>> J.PDLINE AS PDLINE , > >>> J.PDITEM AS PDITEM , > >>> K.M0DESC AS M0DESC , > >>> J.PDPUME AS PDPUME , > >>> J.PDREQ AS PDREQ , > >>> J.PDRQRD AS PDRQRD , > >>> J.PDRQST AS PDRQST, > >>> J.PDSETP AS PDSETP , > >>> J.PDQTYP AS PDQTYP , > >>> J.PDPRCE AS PDPRCE, > >>> I.SENAME AS SENAME, > >>> L.C803CNAM AS C803NAM, > >>> L.C803GSDS AS C803GSDS, > >>> M.P804DESC AS P804DESC, > >>> N.P039PORD AS P039PORD, > >>> N.P039POLN AS P039POLN, > >>> N.P039DSLN AS P039DSLN, > >>> N.P039QTY AS P039QTY , > >>> N.P039SHIP AS P039SHIP, > >>> N.P039DELV AS P039DELV, > >>> N.P039REQ AS P039REQ , > >>> N.P039COMM AS P039COMM, > >>> P.P2NAME AS PBNAME, > >>> P.P2ADR1 AS PBP2ADR1, > >>> P.P2ADR2 AS PBP2ADR2, > >>> P.P2CITY AS PBP2CITY, > >>> P.P2STE AS PBP2STE , > >>> P.P2ZIP AS PBP2ZIP , > >>> P.P2ATTN AS PBP2ATTN, > >>> P.P2PHON AS PBP2PHON, > >>> P.P2FAX# AS PBP2FAX, > >>> Q.P2NAME AS QBNAME, > >>> Q.P2ADR1 AS QBP2ADR1, > >>> Q.P2ADR2 AS QBP2ADR2, > >>> Q.P2CITY AS QBP2CITY, > >>> Q.P2STE AS QBP2STE , > >>> Q.P2ZIP AS QBP2ZIP , > >>> Q.P2ATTN AS QBP2ATTN, > >>> Q.P2PHON AS QBP2PHON, > >>> Q.P2FAX# AS QBP2FAX, > >>> R.SENAME AS RSENAME, > >>> S.SENAME AS SSENAME > >>> FROM > >>> > >>> > >>> > >>> (((((((((((((((( Pu1012 A left join pu1002 B on > >>> > >>> A.PcShpt = B.P2code ) Left join > >>> > >> Pu1002 C > >> > >>> on > >>> A.PcBilt = C.P2code ) Left Join > >>> > >> Pu1832 D > >> > >>> on > >>> A.PcShpv = D.P832Code ) Left join > >>> > >> Pu1834 E > >> > >>> on > >>> A.PcFRGT = E.P834Code ) Left join > >>> > >> PU1813 F > >> > >>> on > >>> A.PCBUYR = F.P813Code) Left join > >>> > >> PU1830 G > >> > >>> on > >>> A.PCPAYT = G.P830Code) Left join > >>> > >> PU1001 H > >> > >>> on > >>> A.PCVNDR = H.P1VNDR) Left join > >>> > >> SE1001 I > >> > >>> on > >>> A.PCAPVU = I.SEUSID) Left join > >>> > >> CF1803C L > >> > >>> on > >>> A.PCCOMP = L.C803COMP) Left join > >>> > >> PU1804 M > >> > >>> on > >>> A.PCptyp = M.p804code) Left join > >>> > >> pu1013 J > >> > >>> on > >>> A.pcpord = J.pdpord) Left join > >>> > >> pu1039 N > >> > >>> on > >>> J.pdpord = N.p039pord and > >>> > >>> J.pdline = N.p039poln) LEFT JOIN > >>> > >> PU1002 P > >> > >>> ON > >>> J.PDSHIP = P.P2CODE) LEFT JOIN > >>> > >> PU1002 Q > >> > >>> ON > >>> N.P039SHIP = Q.P2CODE) LEFT JOIN > >>> > >> SE1001 R > >> > >>> ON > >>> N.P039REQ = R.SEUSID) LEFT JOIN > >>> > >> SE1001 S > >> > >>> ON > >>> J.PDRQST = S.SEUSID), > >>> > >>> > >>> > >>> RS1002 K > >>> > >>> > >>> > >>> WHERE A.Pcpord = "VALUE# > >>> > >>> And A.Pcpord = J.pdpord > >>> > >>> AND J.PDITEM = K.M0CODE > >>> > >>> Order by PDLINE > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> __________________________________ > >>> Discover Yahoo! > >>> Use Yahoo! to plan a weekend, have fun online and > >>> > >> more. Check it out! > >> > >>> http://discover.yahoo.com/ > >>> > >>> > >> > >> > > > > > > > > > > __________________________________ > > Yahoo! Mail > > Stay connected, organized, and protected. Take the tour: > > http://tour.mail.yahoo.com/mailtour.html > > > > > > -- Rahul Singh CEO, Anant [EMAIL PROTECTED]
