SAP Knowledge Base Article - Preview

2801747 - Interactive SQL (DBISQL) behavior changed - SAP IQ 16.1

Symptom

Trying to set either option ISQL_PRINT_RESULT_SET='ALL' or ISQL_SHOW_MULTIPLE_RESULT_SETS receives errors.  For example:

set option ISQL_SHOW_MULTIPLE_RESULT_SETS='on'
go
Msg 155, Level 15, State 0:
SQL Anywhere Error -200: Invalid option 'ISQL_SHOW_MULTIPLE_RESULT_SETS' -- no PUBLIC setting exists

set temporary option ISQL_Show_Multiple_Result_Sets = 'On';
go

Msg 13687, Level 16, State 0:
SQL Anywhere Error -203: Cannot set a temporary option for user 'DBA'


Read more...

Environment

  • SAP IQ 16.1

Product

SAP IQ 16.1 ; SAP SQL Anywhere 17.0

Keywords

.isqlPreferences17_64 , .isqlPreferences16_64 , printResultSetToConsole , SybaseIQ.showMultipleResultSets , , KBA , BC-SYB-IQ , Sybase IQ , How To

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.