Skip to Content
0
Former Member
Aug 17, 2017 at 01:28 PM

Why does xsjs not allow table names with lower case?

93 Views Last edit Aug 17, 2017 at 01:31 PM 3 rev

so I have the following code to remove a table from HANA using XSJS.

var table "ZNAme";

var connection = $.db.getConnection();
var query;

try{
    query = 'DROP TABLE MYSCHEMA.' + table;
    var drop = connection.prepareStatement(query);
    drop.execute();

   }catch(e){
       $.response.setBody(e.message);
}

The problem is that when I run it it gives me an error saying it can't find the table "ZNAME". For some reason it changes all the chars to upper case. However I'm creating this table also using xsjs and it works fine. I'm able to create the table, add data to it and read the data from it. The only thing I can't do is remove it. It only works if all chars are in upper case. Can someone explain to me why this is going on?