SAP Knowledge Base Article - Preview

1940771 - How to modify column datatype in SAP IQ


  • How to change a column datatype in SAP IQ?
  • Using below query fails with error:
    Could not execute statement.
    ALTER TABLE MODIFY <column> <datatype> is not supported.

    (db_alter.cxx 438)
    SQLCODE=-1013024, ODBC 3 State="HY000
  • For example:
    alter table mytable
    modify column3 numeric(22,2);



  • SAP IQ 15.x
  • SAP IQ 16.0
  • SAP IQ 16.1


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


update data type , 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.