SAP Knowledge Base Article - Preview

2658571 - DBISQL may mix N row(s) affected messages with login information from sp_displaylogin - SAP ASE

Symptom

  • Interactive SQL (DBISQL) in GUI mode may mix "N row(s) affected" messages with information about a login account in Results pane when executing sp_displaylogin.
  • For example, when running sp_displaylogin "sa", the following will appear in Results pane.

1 row(s) affected
......omitted....
1 row(s) affected
Loginame: sa
1 row(s) affected
1 row(s) affected
1 row(s) affected
1 row(s) affected
Fullname:
1 row(s) affected
1 row(s) affected
1 row(s) affected
1 row(s) affected
Default Database: master
1 row(s) affected
1 row(s) affected
1 row(s) affected
1 row(s) affected
Default Language:
1 row(s) affected
1 row(s) affected
1 row(s) affected
1 row(s) affected
Auto Login Script:
1 row(s) affected
1 row(s) affected
......omitted....
1 row(s) affected
1 row(s) affected
1 row(s) affected
1 row(s) affected
1 row(s) affected
Date of Last Password Change: Aug 25 2017  5:05PM
......omitted....


Read more...

Environment

  • SAP Adaptive Server Enterprise 16.0
  • Interactive SQL (DBISQL)
  • All platforms

Product

SAP Adaptive Server Enterprise 16.0

Keywords

dbisql, Interactive SQL, 1 row(s) affected , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.