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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.