<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SQL Query via hdbcli Python module does not return info about command execution in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/sql-query-via-hdbcli-python-module-does-not-return-info-about-command/m-p/12315946#M1990976</link>
    <description>&lt;P&gt;If I run an SQL Query Command in Python using hdbcli Python module, I get the result set of the select statement,&lt;/P&gt;
  &lt;P&gt;but, I do not get an info about the statement itself like "(15 rows selected) * Ok" &lt;/P&gt;
  &lt;P&gt;Especially for insert this info is important, in order to know how many lines have been inserted.&lt;/P&gt;
  &lt;P&gt;The statement works fine but does not return any info like "(15 rows selected) * Ok" &lt;/P&gt; 
  &lt;PRE&gt;&lt;CODE&gt;sql = 'SELECT * FROM T1'
cursor = conn.cursor()
cursor.execute(sql)
for row in cursor:
    print(row)&lt;/CODE&gt;&lt;/PRE&gt;</description>
    <pubDate>Fri, 18 Dec 2020 14:33:08 GMT</pubDate>
    <dc:creator>nilsbuer</dc:creator>
    <dc:date>2020-12-18T14:33:08Z</dc:date>
    <item>
      <title>SQL Query via hdbcli Python module does not return info about command execution</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/sql-query-via-hdbcli-python-module-does-not-return-info-about-command/m-p/12315946#M1990976</link>
      <description>&lt;P&gt;If I run an SQL Query Command in Python using hdbcli Python module, I get the result set of the select statement,&lt;/P&gt;
  &lt;P&gt;but, I do not get an info about the statement itself like "(15 rows selected) * Ok" &lt;/P&gt;
  &lt;P&gt;Especially for insert this info is important, in order to know how many lines have been inserted.&lt;/P&gt;
  &lt;P&gt;The statement works fine but does not return any info like "(15 rows selected) * Ok" &lt;/P&gt; 
  &lt;PRE&gt;&lt;CODE&gt;sql = 'SELECT * FROM T1'
cursor = conn.cursor()
cursor.execute(sql)
for row in cursor:
    print(row)&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Fri, 18 Dec 2020 14:33:08 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/sql-query-via-hdbcli-python-module-does-not-return-info-about-command/m-p/12315946#M1990976</guid>
      <dc:creator>nilsbuer</dc:creator>
      <dc:date>2020-12-18T14:33:08Z</dc:date>
    </item>
  </channel>
</rss>

