11-25-2020 10:00 AM
hello i´m using the python driver to query my hana db.
from hdbcli import dbapi
...
dbapi.connect(address='xxx', port=30015, user='SYSTEM', password='xxx#')
this query
Query="SELECT * FROM MYDB.OATC"
returns rows
but querying a view
Query="SELECT top 1000 * from MYDB.ItemStockByWarehouse WHERE WhsCode =1"
returns this error
hdbcli.dbapi.ProgrammingError: (259, 'invalid table name: Could not find table/view ITEMSTOCKBYWAREHOUSE in schema MYDB
is there any issues with views and python driver???
01-06-2021 8:51 AM