Symptom
- Error 456 is reported
- When a connection with 'set readonly on'
- Tries to set rowcount option as well:
set readonly on
go
set rowcount 10
goMsg 456, Level 16, State 1:
Server 'ASE', Line 1:
Failed to execute SET ROW COUNT, because this is a read-only connection.
Read-only connections can only execute SELECT statements.
Use 'set readonly off' to execute SET ROW COUNT.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP04
- SAP Adaptive Server Enterprise (ASE) 16.1
Product
SAP Adaptive Server Enterprise all versions
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
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