I don't understand this SQL0206N error - Can you help detect why and how to resolve it?
Posted on 2010-11-08
I don't know how to determine what is wrong with my view definition and why I am getting the following [IBM][DB2/AIX64] SQL0206N "RCATB_MRIS_OCHG.PERSON_IDN" is not valid in the context where it is used. SQLSTATE=42703
CREATE VIEW RCAVW_MRIS_OCHG_CCS (PERSON_IDN, BVS_INST_CD, DPC_NBR,
DOC_FORMATTED_NAME, DATE_OF_SERVICE, CDX_CD1, CDX_CD2, CDX_CD3,
CDX_CD4, CHG_CREATE_DT) AS
SELECT RCATB_MRIS_OCHG.PERSON_IDN, RCATB_MRIS_OCHG.FPI_INST_CD,
Table definition = RCATB_MRIS_OCHG.PERSON_IDN CHAR(11) not null with default
What do you think is my problem ? Table is not loaded yet, could this be the trouble maker? Or should I explicitly state the default string?