1890204 - SQL error 16336 when accessing table - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1890204 - SQL error 16336 when accessing table - SAP ASE

Symptom

You are running a query that fails with error message:

[ASE Error SQL16336]A SELECT FOR UPDATE query cannot be used with DISTINCT, GROUP BY, HAVING, COMPUTE, UNION, aggregates, computed columns, subqueries or SELECT INTO.


Read more...

Environment

  • SAP Sybase Adaptive Server Enterprise (ASE) 15.7/SP110 and lower releases for Business Suite
  • SAP Sybase Adaptive Server Enterprise (ASE) 15.7/SP110 and lower releases

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7

Keywords

16336, query, select with for update, SQL16336, error 16336 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This 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.