SAP Knowledge Base Article - Preview

2540337 - INSERT VALUES returns error when using multiple rows - SAP IQ


Running an INSERT VALUES statement with multiple rows being inserted at once returns the following error:

create table test (col1 varchar(10), col2 int);
insert into test values ('data',1), ('moredata',2);
Could not execute statement.
Remote server does not have the ability to support this statement
SQLCODE=-706, ODBC 3 State="HY000"
Line 1, column 1



  •  SAP IQ 15.4


SAP Sybase IQ 15.4


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.