Symptom
- When using the table name in the "set" clause of the update statement, the following warning message happened.
update A_tab
set A_tab.col2='AA'
from A_tab a,B_tab b
where a.col1=b.col1
go
Warning : Ambiguous table to update; Using the table specified in the update clause.
(1 row affected) - Is there a method to suppress the warning message 11733 from ASE perspective?
11733
Warning : Ambiguous table to update; Using the table specified in the update clause.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview