Those are always nasty.
Clinton
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
>
>
