SAP Knowledge Base Article - Preview

3077154 - The number of inserted rows of "SELECT INTO" is not displayed - SAP ASE

Symptom

When "SELECT INTO" and "INSERT" are executed at the same time, the number of inserted "SELECT INTO" is not displayed.

ex: select * into test1 from test2
      go
      insert test2 values(5)
      go

      Results (Text)
      ---------------------------
      1 row(s) inserted
      Execution time: 0.205 seconds
      Execution time: 0.036 seconds

This issue reproduces when DBISQL is in text mode.
The result of "SELECT INTO" and "INSERT" should be output as shown below.

1 row(s) inserted
1 row(s) inserted


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Interactive SQL (DBISQL) 11.0.1
  • Interactive SQL (DBISQL) 16.0 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

DBISQL, interactive sql, ase, 15.7, 16.0, insert, select into, update, delete, select, results, text, row count, rowcount , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.