#DateForumTypeThreadPost
703 Jul 2016 @ 05:29 PDTAsterReplyINSERT undocumented syntaxMy question was not described clearly. Aster SQL mentions syntax INSERT INTO table query; my question is related to syntax: INSERT INTO table (query); Do exist any other undocumented syntaxes?...
624 Jun 2016 @ 08:16 PDTAsterReplyHow to list all seqeunces?Could you provide an example use this name to get next value and grant access to sequence to other user?
524 Jun 2016 @ 08:15 PDTAsterTopicINSERT undocumented syntaxHi, I have noticed that INSERT with bracketed query is supported what is not documented in Aster SQL reference: - INSERT INTO table (query) Should I treat this as a bug or another syntax not inc...
422 Jun 2016 @ 01:20 PDTAsterTopicHow to list all seqeunces?There is not system view to list all sequences. I found some information inside nc_all_columns but Aster provides GRANT on sequence without simple way to identify their names.
317 Jun 2016 @ 10:36 PDTAsterReplyHow 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 acce...
217 Jun 2016 @ 10:11 PDTAsterReplyHow 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 ...
117 Jun 2016 @ 09:20 PDTAsterTopicHow 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)...