SAP Knowledge Base Article - Preview

1890204 - Archived : SQL error 16336 when accessing table - SAP ASE

Symptom

ARCHIVED : Refers to very old CR in obsolete ASE releases.

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 , Business Suite on Adaptive Server Enterprise , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.