CREATE OR REPLACE VIEW SD_HOSPITAL.VW_XM_PC0000
 (
 PCID00, PCMC00, WBSM00, PYSM00, ZQDW00, ZQCS00, SM0000, YXBZ00, HSZQCD

 )
 AS 
SELECT
  PCID00,(PCMC00||BZ0000) AS PCMC00,WBSM00,PYSM00,DECODE(('*'||ZQCD00||ZQDW00),'*','',('*'||ZQCD00||ZQDW00)) AS ZQDW00,ZQCS00,SM0000,YXBZ00,HSZQCD
FROM BM_PC0000 where yxbz00='Y'
/