Good day,
When setting up access definition to archive views for DB2 LUW, we are getting the following error in the access definition "view error" in the Type field. Any idea what could cause this error. The views are created with a substring function.
CREATE VIEW AUDH.vCR_AP_EV ( CR_AP_EV_ID, CR_AP_NO, PD_TP_ID, EV_TP_ID, SRC_STM_ID, RANK, EFF_DTTM, OUTC_CODE, OUTC_DSC, OBJ_CR_AP_EV_ID, XML_REQ, XML_RESP, EXEC_ID, USR_ID, CNL_ID, SLTN_CMPT_VRSN_NBR, EV_OPRN ) AS SELECT CR_AP_EV_ID, CAST (SUBSTR(CR_AP_NO,1,length(CR_AP_NO)) AS VARCHAR(255)) as CR_AP_NO, PD_TP_ID, EV_TP_ID, SRC_STM_ID, RANK, EFF_DTTM, OUTC_CODE, OUTC_DSC, OBJ_CR_AP_EV_ID, XML_REQ, XML_RESP, EXEC_ID, USR_ID, CNL_ID, SLTN_CMPT_VRSN_NBR, EV_OPRN FROM AUDH.CR_AP_EV
DB20000I The SQL command completed successfully.
------------------------------
David Mogashoa
------------------------------
#InfoSphereOptim#Optim