Symptom
When trying to recompile a view, an error below happened.
[IQ message log]
I. 02/20 23:19:19. 0000007175 Txn 1530934 0 1530934
I. 02/20 23:19:19. 0000007175 Cmt 1530935
I. 02/20 23:19:19. 0000007175 PostCmt 0
I. 02/20 23:19:19. 0000007175 Txn 1530936 0 1530936
I. 02/20 23:19:19. 0000007175 Rbck
I. 02/20 23:19:19. 0000007175 PostRbck
[Trace log - srvlog]
I. 02/20 23:19:19. <,9,PREPARE,alter view "DBA"."VW_JERRY" recompile
I. 02/20 23:19:19. >,9,PREPARE,262168
I. 02/20 23:19:19. <,9,EXEC,262168
I. 02/20 23:19:19. E,9,-1037,Cannot drop or modify object 'VW_JERRY' because at least one other object ( VIEW 'VW_DEPENDENT') depends upon it
Read more...
Environment
- SAP Sybase IQ 15.x
- SAP IQ 16.0
Product
Keywords
SAP IQ, IQ, alter view, recompile, 42000, -1037, Cannot drop or modify object , KBA , BC-SYB-IQ , Sybase IQ , 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.