ALTER TABLE UNLOAD PRIORITY Issue

[Former Member]

Hi Expert, I am trying to change the unload priority of table in BW on Hana, below is the statement I used to execute in Hana Studio:

ALTER TABLE "/BIC/B0006485000" UNLOAD PRIORITY 9

However SAP DBTECH JDBC return me the error of invalid table name line 1 col 13 (at pos 12).

I am pretty sure the table name is correct as it is PSA table.

Please help to identify what is wrong with the syntax.

[pfefferf · Accepted solution]

Hello,

the schema name is missing in your statement.

ALTER TABLE "SCHEMA"."/BIC/B0006485000" UNLOAD PRIORITY 9;

Please find out the schema name to which the table belongs and add it to the statement.

Regards,

Florian