You may wish to go to the DB2 List for these types of questions. To join, if you have not done so is FREE and at IDUG.ORG
Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Ron Thomas > Sent: Tuesday, June 10, 2014 11:34 AM > To: [email protected] > Subject: Db2 query > > Hello. > > We have below 2 queries , could some one let me know which would be best way > to > join these 2 queries ? > > 1. > SELECT > A.LECY_IEM_NBR, > C.STRE_NBR, > COALESCE((E.PRICE_DEST_ID),0) > FROM P12MITM.IEM_LEGACY_XREF A, > P12AMITM.IEM B, > P12SPRICE.PRICING_ACT E > LEFT OUTER JOIN P12SPRICE.PRTCE_DEST C > ON E.PRICE_DEST_ID = C.PRICE_DEST_ID > AND E.PRICE_DEST_TYPE = 7 > WHERE A.ITEM_NBR = B.ITEM_NBR > AND B.MDS_FAM_ID = E.ITEM_SOURCE_ID > > 2. > > SELECT CLC_VALUE > INTO :CALC-VALUE > FROM P12SPRICE.PRICING_ACT A > WHERE A.ITEM_SOURCE_ID = :ITEM-DATA.MDS-FAM-ID > AND A.PRICE_DEST_ID = 7 > AND PRICE_TYPE_CODE = 2 > AND COST_TYPE_CODE = 0 > AND PRICING_REASON_CD = 10 > AND PRICE_ACTN_STAT_CD = 210 > AND EFFECTIVE_DATE <= CURRENT DATE > AND EXPIRATION_DATE > CURRENT DATE > > Thanks. > Rajeev V > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send email to > [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
