Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase isql (Interactive SQL)

5 posts in General Discussion Last posting was on 2011-07-28 21:45:36.0Z
Raj Posted on 2011-07-25 12:24:36.0Z
Sender: 539f.4e2d5fb3.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Sybase isql (Interactive SQL)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e2d6084.540e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Jul 2011 05:24:36 -0700
X-Trace: forums-1-dub 1311596676 10.22.241.41 (25 Jul 2011 05:24:36 -0700)
X-Original-Trace: 25 Jul 2011 05:24:36 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30371
Article PK: 72550

How to limit the row selection in
Sybase isql (Interactive SQL). I was using
Sybase isql (Interactive SQL) and I was getting only one row
as output ir-respect of lot of row in selection criteria.
Please help on this.


Rob V [ Sybase ] Posted on 2011-07-25 12:47:13.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase isql (Interactive SQL)
References: <4e2d6084.540e.1681692777@sybase.com>
In-Reply-To: <4e2d6084.540e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e2d65d1$1@forums-1-dub>
Date: 25 Jul 2011 05:47:13 -0700
X-Trace: forums-1-dub 1311598033 10.22.241.152 (25 Jul 2011 05:47:13 -0700)
X-Original-Trace: 25 Jul 2011 05:47:13 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30372
Article PK: 72551


On 25-Jul-2011 14:24, Raj wrote:
> How to limit the row selection in
> Sybase isql (Interactive SQL). I was using
> Sybase isql (Interactive SQL) and I was getting only one row
> as output ir-respect of lot of row in selection criteria.
> Please help on this.

Without further details as to what you have precisely tried, perhaps you
should use a "where" clause in your queries, or use "select top" or "set
rowcount" ?

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Raj Posted on 2011-07-28 10:18:07.0Z
Sender: 539f.4e2d5fb3.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase isql (Interactive SQL)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e31375f.730b.1681692777@sybase.com>
References: <4e2d65d1$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Jul 2011 03:18:07 -0700
X-Trace: forums-1-dub 1311848287 10.22.241.41 (28 Jul 2011 03:18:07 -0700)
X-Original-Trace: 28 Jul 2011 03:18:07 -0700, 10.22.241.41
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30383
Article PK: 72562

Thanks Rob. but we did not do any limit setting in session,
and output was unexpected.

> On 25-Jul-2011 14:24, Raj wrote:
> > How to limit the row selection in
> > Sybase isql (Interactive SQL). I was using
> > Sybase isql (Interactive SQL) and I was getting only one
> > row as output ir-respect of lot of row in selection
> > criteria. Please help on this.
>
> Without further details as to what you have precisely
> tried, perhaps you should use a "where" clause in your
> queries, or use "select top" or "set rowcount" ?
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------
>


Rob V [ Sybase ] Posted on 2011-07-28 11:00:43.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase isql (Interactive SQL)
References: <4e2d65d1$1@forums-1-dub> <4e31375f.730b.1681692777@sybase.com>
In-Reply-To: <4e31375f.730b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e31415b@forums-1-dub>
Date: 28 Jul 2011 04:00:43 -0700
X-Trace: forums-1-dub 1311850843 10.22.241.152 (28 Jul 2011 04:00:43 -0700)
X-Original-Trace: 28 Jul 2011 04:00:43 -0700, vip152.sybase.com
Lines: 62
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30385
Article PK: 72564

You'll need to post a more precise example of what query you're running
, what the result is and why you expected something different.
Right now there is just not enough information to make any sensisble
comments.

Rob V.

-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------

On 28-Jul-2011 12:18, Raj wrote:
> Thanks Rob. but we did not do any limit setting in session,
> and output was unexpected.
>
>> On 25-Jul-2011 14:24, Raj wrote:
>>> How to limit the row selection in
>>> Sybase isql (Interactive SQL). I was using
>>> Sybase isql (Interactive SQL) and I was getting only one
>>> row as output ir-respect of lot of row in selection
>>> criteria. Please help on this.
>> Without further details as to what you have precisely
>> tried, perhaps you should use a "where" clause in your
>> queries, or use "select top" or "set rowcount" ?
>>
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Sybase Professional DBA for ASE
>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>> 15.0.1/12.5 // TeamSybase
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
>> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
>> Reference Guide" "The Complete Sybase Replication Server
>> Quick Reference Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>>


"Mark A. Parsons" <iron_horse Posted on 2011-07-28 21:45:36.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase isql (Interactive SQL)
References: <4e2d6084.540e.1681692777@sybase.com>
In-Reply-To: <4e2d6084.540e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e31d880$1@forums-1-dub>
Date: 28 Jul 2011 14:45:36 -0700
X-Trace: forums-1-dub 1311889536 10.22.241.152 (28 Jul 2011 14:45:36 -0700)
X-Original-Trace: 28 Jul 2011 14:45:36 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30400
Article PK: 72579

Same general comment as Rob's ... not enough details.

If you submit the same query via the command line 'isql' tool, do you get more than 1 row?

Have you checked your InteractiveSQL options?

NOTE: I don't use InteractiveSQL, but from a quick glance at its options it looks like there's a way to limit the
number of rows displayed in the output window:

Tools > Options > Adaptive Server Enterprise (left column) > Results (tab) > Display > Maximum number of rows to display

My version of InteractiveSQL (11.0.1, came with my ASE 15.0.3 install) shows a default of 'Maximum number of rows to
display' = 500 ... what does your's show?

On 07/25/2011 08:24, Raj wrote:
> How to limit the row selection in
> Sybase isql (Interactive SQL). I was using
> Sybase isql (Interactive SQL) and I was getting only one row
> as output ir-respect of lot of row in selection criteria.
> Please help on this.