Symptom
We sometimes need to get the multiple result set using dbisql in case of batch program,
We can get the multiple result using "SybaseIQ.showMultipleResultSets" option in ".isqlPreferences11" file.
[batch.sql]
begin
select @@version;
select @@servername;
end
>> dbisql -c dsn=XXX -nogui batch.sql > batch.log
/home/iqmpx>> cat batch.sql
@@version
--------------------------------------------------------------------------------------------------------------------------------
Sybase IQ/15.4.0.3014/120310/P/ESD 1/RS6000MP/AIX 6.1.0/64bit/2012-03-10 11:48:24
(1 rows)
@@servername
--------------------------------------------------------------------------------------------------------------------------------
mpx154_R
(1 rows)
Read more...
Environment
SAP IQ15.2, IQ15.4
Product
Keywords
Multiple Results Sets, showMultipleResultSets, isqlPreferences11, .isqlPreferences12_64, SybaseIQ.showMultipleResultSets, SAP IQ, IQ, multiple result sets , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To
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.