|
Home > Archive > IQ Server > March 2006 > multiple result set in dbisql with -nogui option
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
multiple result set in dbisql with -nogui option
|
|
| Tina Tian 2006-03-21, 3:36 am |
| Hi,
My unix shell script is using dbisql -nogui sql-statement-file. Few select
statements are in this SQL file like
select f1, f2 from table1 where ....;
select f1,f2 from table1 where ....;
When I run this script it always gave me one result set -- the second one
only.
How to show the full result set? Is there any option setup similar to the
'show multiple result sets' in dbisql (open client) ?
Thanks,
Tina
| |
|
| look up 'DBISQLC provides the RESUME command to display each
successive result set. ' in the iq docs... something tells
me i never got this to work though?!?!? notice the doc says
'DBISQLC'...classic version.....might give it a try??
> Hi,
>
> My unix shell script is using dbisql -nogui
> sql-statement-file. Few select statements are in this SQL
> file like
>
> select f1, f2 from table1 where ....;
> select f1,f2 from table1 where ....;
>
> When I run this script it always gave me one result set --
> the second one only.
>
> How to show the full result set? Is there any option setup
> similar to the 'show multiple result sets' in dbisql
> (open client) ?
>
> Thanks,
> Tina
>
>
|
|
|
|
|