SAP Knowledge Base Article - Preview

2614034 - New Feature Request to enable comprehensive VIEW locking in SAP IQ


  • An EXCLUSIVE TABLE lock does not lock dependent VIEWs causing DDL like ALTER TABLE to later fail should a shared lock on a view exist
  • Requirement for an exclusive lock on a table to mean just that, that the table is exclusively locked and no other lock or dependant lock further down the locking hierarchy is permitted.



  • SAP IQ 15.4 all platforms
  • SAP IQ 16.0 all platforms
  • SAP IQ 16.1 all platforms


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


NFR, sybase, IQ16, tablelock, CR811230, CR#811230, 811230, CR819916, CR#819916, 819916, enhancement, viewlock, 'SQLCODE=-210',  'another user', 'has the row in', locked, 40001, state, ODBC, invalid, 'alter view', , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.