python driver not able to query a view ??

former_member715007 — Wed, 25 Nov 2020 10:00:20 GMT

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???

Re: python driver not able to query a view ??

AndreasForster — Wed, 06 Jan 2021 08:51:12 GMT

Hi antonio.a.ramos , This could be due to the view name containing lower case letters. (ItemStockByWarehouse) Putting quotes around the table name could fix this. Or it might be easiest, if you could create the view using only upper case.

topic Re: python driver not able to query a view ?? in Application Development and Automation Discussions

python driver not able to query a view ??

Re: python driver not able to query a view ??