DB2 行转列与列转行

列转行

SELECT EB5_CDSPEC||'-'||EB5_SITE||EB5_SER,EB5_CDBEAD, Q.COMP, Q.CODE_COMP,Q.COMP_WEGHT,EB4_CDRAW RAW_CODE,EB4_WRKDES WRK_DES,EB4_BATWEG BATWEG FROM (
    SELECT *  KTGE.GEB5050 
) S,
TABLE (VALUES  ('BEAD_WIRE', S.EB5_CDWIRE,S.EB5_WEGHT),
      ('BEAD_COATING', S.EB5_CDCOAT ||'-'|| S.EB5_SERCOT , S.EB5_WEGCOT),
      ('APEX1', S.EB5_RCPAP1||'-'||S.EB5_SERAP1,S.EB5_WEGAP1),
      ('APEX2', S.EB5_RCPAP2||'-'||S.EB5_SERAP2,S.EB5_WEGAP2),
      ('BEAD_WRAP1', S.EB5_CDWR1||'-'||S.EB5_SERWR1,S.EB5_WEGWR1),
      ('BEAD_WRAP2', S.EB5_CDWR2||'-'||S.EB5_SERWR2,S.EB5_WEGWR2),
      ('FLIPPER', S.EB5_CDFLP||'-'||S.EB5_SERFLP,S.EB5_WEGFLP)
)
AS Q(COMP, CODE_COMP,COMP_WEGHT)
LEFT JOIN KTGE.GEB2040 A
 ON CODE_COMP=EB4_CDRCPE||'-'||EB4_SITE||EB4_CDRCPS||EB4_SER