- A SELECT statement on multiple views with UNION ALL and LEFT JOINs generates:
Error 257 Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query.
- The issue only happens with LEFT JOINs as with RIGHT JOIN no error has been seen.
- SAP Adaptive Server Entreprise (ASE) 15.7
- SAP Adaptive Server Entreprise (ASE) 16.0
Error: 257, view with union all, split, separate, query failing , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.