SAP Knowledge Base Article - Preview

2596431 - CREATE MATERIALIZED VIEW statement failed with SQLCODE=-1031 - SAP IQ 

Symptom







    

  • CREATE MATERIALIZED VIEW statement failed with SQLCODE=-1031

    

    (dba)> create materialized view mv_tableA as select col1, col2 from tableA
    Could not execute statement.
      Syntax error near 'tableA' -- Materialized view definition must not use
      the following construct: 'Remote object'
      SQLCODE=-1031, ODBC 3 State="HY000"
    

    Line 1, column 1
      create materialized view mv_tableA as select col1, col2 from tableA
    

    • 





            

         

           
              Read more...
           
        

      



Environment



   

    

  • SAP IQ 16.1
    • 

  • SAP IQ 16.0
    • 








Product



  SAP IQ 16.0 ; SAP IQ 16.1





Keywords



   
 KBA , BC-SYB-IQ , Sybase IQ , How To 




          
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.