How to get info from system tables using pyodbc?

Aster
Enthusiast

How to get info from system tables using pyodbc?

I tried to get data from nc_all_users using pyodbc where only cursors are available for tetch data. Unfortunatelly AsterDB returned error:

('HY000', '[HY000] [AsterData][nCluster] (34) ERROR: declare cursor statement may not reference system tables.  (34) (SQLFetch)')

Any idea how to get data from system tables using Python?

2 REPLIES
Enthusiast

Re: How to get info from system tables using pyodbc?

This same problem with jdbc driver - SELECT  is internally conversed to cursor and access to system tables is forbidden. Does it mean that ASTER do not provide programatic interface to manage user, databases, schemas?

Enthusiast

Re: How to get info from system tables using pyodbc?

The ODBC driver provides possibility to use SQL without cursor and works ok in this case, but pyodbc and Teradata JDBC driver base on cursors only what leads to meaningful limitations of these access vectors. Is it possible to use cursors on system tables or does Teradata plan to add direct access to data in new version of JDBC or Python Teradata driver will also support Aster?