All Forums Aster
zszmigiero 7 posts Joined 05/15
17 Jun 2016
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?

zszmigiero 7 posts Joined 05/15
17 Jun 2016

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?

zszmigiero 7 posts Joined 05/15
17 Jun 2016

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?

You must sign in to leave a comment.