主页 / dba / 问题 / 65598
Accepted
user38759
Asked: 2014-05-22 07:21:26 +0800 CST

关于使用附加列（不在表中）创建视图

  • 772

我有以下定义的观点。

create view VIEW_IRS1 as Select 
MBR.PRSN_MBRSH_ID
, Atr.Ssn_Tx
, Names.First_Na
, Names.Middle_Na
, Names.Last_Na
, Reff.Ref_Cd_Desc_Tx Suffix_Na
,'FALSE' AS [Request Title II Monthly Income Verification]

From Hix.T_Enrt En 
Inner Join Hix.T_Prsn_Enrt Pe On En.Enrt_Id = Pe.Enrt_Id And En.Enrt_Status_Cd In (428,439, 430 ) And Pe.Active_In = 'Y' And (Pe.Retro_In Is Null Or Pe.Retro_In = 'N') 

Left Outer Join Hix.T_Aptc Ap On En.Enrt_Id = Ap.Enrt_Id

Left Outer Join Hix.T_Prsn_Addl_Attr Atr On Pe.Prsn_Mbrsh_Id = Atr.Prsn_Mbrsh_Id

Left Outer Join
(                   
    Select nAc.Prsn_mbrsh_Id,  First_Na , Middle_Na , Last_Na, Suffix_Cd From Hix.T_Prsn_Name Na, Hix.t_prsn_mbrsh_prsn_name_ac nAc
    where na.prsn_name_id = nAc.prsn_Name_Id
) Names On Pe.prsn_mbrsh_id = Names.prsn_mbrsh_id

Left Outer Join Hix.T_Ref_Data Reff On Names.Suffix_Cd = Reff.Ref_Data_Id

Left Outer Join Hix.T_Ref_Data Re On Atr.GENDER_CD = Reff.Ref_Data_Id

Left Outer Join Hix.T_PRSN_MBRSH MBR on MBR.PRSN_MBRSH_ID=Pe.PRSN_ENRT_ID;

我想创建一个新视图（而不是更改此视图），其中包含一个附加列名称“ABC”，其值应始终为 FALSE。我怎样才能做到这一点？

db2 view

1 个回答

  1. Best Answer

    你能不能只创建一个新视图

    SELECT *, 0 AS "ABC"
FROM VIEW_IRS1

    或者，如果您指的是文本“False”

    SELECT *, 'FALSE' AS "ABC"
FROM VIEW_IRS1

    或者编辑现有视图：

    SELECT 
    MBR.PRSN_MBRSH_ID
    , Atr.Ssn_Tx
    , Names.First_Na
    , Names.Middle_Na
    , Names.Last_Na
    , Reff.Ref_Cd_Desc_Tx Suffix_Na
    , 'FALSE' AS "My Really Long Name"
FROM 
    AllYourOtherTables
    • 2

相关问题