Batch UPSERT in xsjs using $.hdb api

[former_member609457]

I have written UPSERT query in xsjs and I am trying to do batch operation .

var connection = $.hdb.getConnection();
var query = "UPSERT \"TABLE_NAME\"( "COL_1","COL_2","COL_3") VALUES ( ?,?,?) where \"COL_3\"='1234'";
var data = [['A',100,'1234'],['B',200,'1234']];
var count = connection.executeUpdate(query , data);

I am not getting any syntax error but the values are not updating either. I am getting below value in count

count = [-301,-301];

can anyone tell me how to do batch operation in this case?