生活的内容不全是工作,工作只是生活的一部分;享受生活,热爱工作!
分类: Sybase
2014-02-21 16:31:20
用户一个数据库执行一条Update语句报内部错误,语句及错误如下:
update QTDC_TRANSACTION set a.COD_PRO_COD_CPT =b.COD_PRO_COD,a.COD_BRCH_OU_CPT = b.COD_BRCH_OU,a.ID_INTL_IP_CPT = b.ID_INTL_IP
from QTDC_TRANSACTION as a,VBO_AM_DTAL_TR_FN as b where a.NUM_JRN_NO =b.NUM_JRN_NO and a.NUM_AR_SEM_CPT = b.NUM_AR_SEM and a.NUM_AR_SEM_CPT <>''
Msg
21, Level 23, State 0:
SQL Anywhere Error -1006001: IQ Internal error. Please report this to Sybase IQ
support.
-- (dfjo_Hash.cxx 1631)
-- (dfjo_Hash.cxx 1631)
QTDC_TRANSACTION 是一张基表,VBO_AM_DTAL_TR_FN 是由9张表union all组成的View。
解决办法:set option public.DML_Options9=10,缺省值是0。