RE:Tutorial español DB2/UDB
Hola me gustarñia hacer una sencilla query en DB2 pero la verdad es que no se como...quiero hacer un :
select count (distinct pha_cod, sal_org_cod, dib_can_cod, ntn_ngc_cod, cny_cod, fin_pdt_cod, mth_cod, cbu_cod) from fin_pdt, trn_ana_fac, pnl_fac, cus
where PNL_FAC.CUS_COD=TRN_ANA_FAC.CUS_COD and PNL_FAC.FIN_PDT_COD=TRN_ANA_FAC.FIN_PDT_COD
and PNL_FAC.MTH_COD=TRN_ANA_FAC.MTH_COD and PNL_FAC.SAL_AIE_COD=TRN_ANA_FAC.SAL_AIE_COD
and PNL_FAC.PHA_COD=TRN_ANA_FAC.PHA_COD and PNL_FAC.CBU_COD=TRN_ANA_FAC.CBU_COD
and PNL_FAC.TYP_UNT_COD=TRN_ANA_FAC.TYP_UNT_COD and PNL_FAC.SAL_NAT_COD=TRN_ANA_FAC.SAL_NAT_COD
and FIN_PDT.FIN_PDT_COD=PNL_FAC.FIN_PDT_COD and FIN_PDT.SAL_AIE_COD=PNL_FAC.SAL_AIE_COD
and PNL_FAC.CPK_COD=TRN_ANA_FAC.CPK_COD and trn_ana_fac.mth_cod = 200509
todos los campos que están en el distinct son campos claves en otra tabla que insert estos datos y tengo un error de duplicado de claves primarias, el error es:
Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO BMT_FPNL(PHA_COD,SAL_ORG_COD,DIB_CAN_COD,NTN_NGC_COD,RGN_NGC_COD,CNY_COD,FIN_PDT_COD,YEA_COD,MTH_COD,CBU_COD,INV_QTY_VLM,INV_QTY_WGH,INV_QTY,RVN,GED_PRX_TOT_SAL,FRT_PRX,TOT_SAL,CSH_RED,CLR_RED,DEL_RED,OTH_CND_RED,OTH_RED,OTH_SVC_RED,PMT_MKT_ATV_RED,PMT_SAL_ATV_RED,CLN_ASE_RED,INV_CND_GRW_RED,INV_PNY_RED,INV_PDN_VIE_RED,INV_SAL,CSH_RED_FI_ACL,CSH_RED_TTM_ACL,CLR_RED_ACL,CND_GRW_RED_ACL,DEL_RED_ACL,ITL_CPR_RED_ACL,LST_PRX_RED_ACL,MKT_RED_ACL,OTH_CND_RED_ACL,OTH_RED_ACL,OTH_SVC_RED_ACL,DFR_RED_AJU_CHG_CND,PDT_VIE_RED_ACL,PMT_MKT_ATV_RED_ACL,PMT_SAL_ATV_RED_ACL,CLN_ASE_RED_ACL,RED_GEN_ACL_RVR,RED_RVR,NET_SAL,CND_GRW_TS_ACL,DEL_TS_ACL,ITL_CPR_TS_ACL,LST_PRX_TS_ACL,MKT_TS_ACL,OTH_CND_TS_ACL,OTH_SVC_TS_ACL,OTH_TS_ACL,TRD_SPT_AJU_CHG_CND,PNY_TS_ACL,PDT_VIE_TS_ACL,PMT_MKT_ATV_TS_ACL,PMT_SAL_ATV_TS_ACL,CLN_ASE_TS_ACL,TRD_SPT_GEN_ACL_RVR,TRD_SP_RVR,NET_NET_SAL,MAT_COS,AR1_OMC,WRK_COS,OTH_DRC_COS,MNG_OVH_COS,AR1_DFTC,OTS_FRT_CUS_CST,AR1_DIFO,AR1_FTCO,AR1_OLC,OTH_WRH,OTS_INT_FRT_OUT_CST,DEL_CST,USL_FP,OTH_USL,VAN_SAL,ACA,ADV,CMN,OUT_REL_ADV,CPG,OTH_CSO_PMT,PMT_DSG,SPL_PRD,SPL_OTH,DRC_MKT,MKD,MKT_PDT_CST_FP,MKT_PRD_CST_OTH,MKT_STU,MKT_PRD_CST,OTH_MKT,PRD_DVT,TRD_MKT,SAL_FOR_CST) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO BMT_FPNL(PHA_COD,SAL_ORG_COD,DIB_CAN_COD,NTN_NGC_COD,RGN_NGC_COD,CNY_COD,FIN_PDT_COD,YEA_COD,MTH_COD,CBU_COD,INV_QTY_VLM,INV_QTY_WGH,INV_QTY,RVN,GED_PRX_TOT_SAL,FRT_PRX,TOT_SAL,CSH_RED,CLR_RED,DEL_RED,OTH_CND_RED,OTH_RED,OTH_SVC_RED,PMT_MKT_ATV_RED,PMT_SAL_ATV_RED,CLN_ASE_RED,INV_CND_GRW_RED,INV_PNY_RED,INV_PDN_VIE_RED,INV_SAL,CSH_RED_FI_ACL,CSH_RED_TTM_ACL,CLR_RED_ACL,CND_GRW_RED_ACL,DEL_RED_ACL,ITL_CPR_RED_ACL,LST_PRX_RED_ACL,MKT_RED_ACL,OTH_CND_RED_ACL,OTH_RED_ACL,OTH_SVC_RED_ACL,DFR_RED_AJU_CHG_CND,PDT_VIE_RED_ACL,PMT_MKT_ATV_RED_ACL,PMT_SAL_ATV_RED_ACL,CLN_ASE_RED_ACL,RED_GEN_ACL_RVR,RED_RVR,NET_SAL,CND_GRW_TS_ACL,DEL_TS_ACL,ITL_CPR_TS_ACL,LST_PRX_TS_ACL,MKT_TS_ACL,OTH_CND_TS_ACL,OTH_SVC_TS_ACL,OTH_TS_ACL,TRD_SPT_AJU_CHG_CND,PNY_TS_ACL,PDT_VIE_TS_ACL,PMT_MKT_ATV_TS_ACL,PMT_SAL_ATV_TS_ACL,CLN_ASE_TS_ACL,TRD_SPT_GEN_ACL_RVR,TRD_SP_RVR,NET_NET_SAL,MAT_COS,AR1_OMC,WRK_COS,OTH_DRC_COS,MNG_OVH_COS,AR1_DFTC,OTS_FRT_CUS_CST,AR1_DIFO,AR1_FTCO,AR1_OLC,OTH_WRH,OTS_INT_FRT_OUT_CST,DEL_CST,USL_FP,OTH_USL,VAN_SAL,ACA,ADV,CMN,OUT_REL_ADV,CPG,OTH_CSO_PMT,PMT_DSG,SPL_PRD,SPL_OTH,DRC_MKT,MKD,MKT_PDT_CST_FP,MKT_PRD_CST_OTH,MKT_STU,MKT_PRD_CST,OTH_MKT,PRD_DVT,TRD_MKT,SAL_FOR_CST) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> Thu Oct 06 17:57:24 2005
WRITER_1_*_1> WRT_8114
Row # [1] in bad file
Muchisimas gracias por vuestra ayuda,
Susana