Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training





Sybase » Transact-SQL » Tips Tricks » IQ

Returning Multiple Result Sets in Sybase IQ

     


Sybase IQ : Displaying multiple result sets





In console mode (from a UNIX or Linux server) the dbisql utility does not display multiple result sets, by default. Below are the undocumented directives to issue at the top of your SQL batch.








set option isql_print_result_set=ALL
go
set option isql_show_multiple_result_sets=On
go








Sybase : Related Topics

Sybase : Transact-SQL : Self-Joins in SQL

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.