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 Central error

8 posts in General Discussion Last posting was on 2011-02-10 15:52:20.0Z
res Posted on 2011-02-09 04:43:20.0Z
Sender: 5529.4d5214cb.1804289383@sybase.com
From: res
Newsgroups: sybase.public.ase.general
Subject: Sybase Central error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d521b68.575c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Feb 2011 20:43:20 -0800
X-Trace: forums-1-dub 1297226600 10.22.241.41 (8 Feb 2011 20:43:20 -0800)
X-Original-Trace: 8 Feb 2011 20:43:20 -0800, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29939
Article PK: 79168

Hi all
while trying to select users in a database from sybase
central (ASE 12.5.2)i'm getting a message like 'The order-by
position number 'n' is out of range of the number of items
in the select list'. however this err. doesn't appear for
scjava version.

is this due to any indexing issues? please assist to find
out which table index is creating thie err.?


Thanks
res


Rob V [ Sybase ] Posted on 2011-02-09 08:08:05.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@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.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
References: <4d521b68.575c.1681692777@sybase.com>
In-Reply-To: <4d521b68.575c.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: <4d524b65$1@forums-1-dub>
Date: 9 Feb 2011 00:08:05 -0800
X-Trace: forums-1-dub 1297238885 10.22.241.152 (9 Feb 2011 00:08:05 -0800)
X-Original-Trace: 9 Feb 2011 00:08:05 -0800, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29941
Article PK: 79172


On 09-Feb-2011 05:43, res wrote:
> Hi all
> while trying to select users in a database from sybase
> central (ASE 12.5.2)i'm getting a message like 'The order-by
> position number 'n' is out of range of the number of items
> in the select list'. however this err. doesn't appear for
> scjava version.
>
> is this due to any indexing issues? please assist to find
> out which table index is creating thie err.?
>
>
> Thanks
> res

This error has nothing to do with indexing. It comes from queries with
an order-by clause using positional specifiers, such as this one:

select name, id, crdate
from sysobjects
order by 3, 1, 2 -- using positional specifiers rather than column names


If you'd specify 'order by 4,1,2' instead, you get the error you mention
since there are only 3 columns in the result set.
I'm guessing the Java version suppresses the error or something.

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
-----------------------------------------------------------------


J Posted on 2011-02-09 15:57:54.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
Reply-To: J@bogusemailAddress.com
Message-ID: <4d52b957.517968515@forums.sybase.com>
References: <4d521b68.575c.1681692777@sybase.com> <4d524b65$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Feb 2011 07:57:54 -0800
X-Trace: forums-1-dub 1297267074 10.22.241.152 (9 Feb 2011 07:57:54 -0800)
X-Original-Trace: 9 Feb 2011 07:57:54 -0800, vip152.sybase.com
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29943
Article PK: 79170

On 9 Feb 2011 00:08:05 -0800, "Rob V [ Sybase ]"
<robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:

Rob, I tried a later version of the DBISQL with later Sybase Centrail
and the warnings are fine there.

Jay

>On 09-Feb-2011 05:43, res wrote:
>> Hi all
>> while trying to select users in a database from sybase
>> central (ASE 12.5.2)i'm getting a message like 'The order-by
>> position number 'n' is out of range of the number of items
>> in the select list'. however this err. doesn't appear for
>> scjava version.
>>
>> is this due to any indexing issues? please assist to find
>> out which table index is creating thie err.?
>>
>>
>> Thanks
>> res
>
>This error has nothing to do with indexing. It comes from queries with
>an order-by clause using positional specifiers, such as this one:
>
>select name, id, crdate
>from sysobjects
>order by 3, 1, 2 -- using positional specifiers rather than column names
>
>
>If you'd specify 'order by 4,1,2' instead, you get the error you mention
>since there are only 3 columns in the result set.
>I'm guessing the Java version suppresses the error or something.
>
>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-02-09 17:03:57.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@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.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
References: <4d521b68.575c.1681692777@sybase.com> <4d524b65$1@forums-1-dub> <4d52b957.517968515@forums.sybase.com>
In-Reply-To: <4d52b957.517968515@forums.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: <4d52c8fd$1@forums-1-dub>
Date: 9 Feb 2011 09:03:57 -0800
X-Trace: forums-1-dub 1297271037 10.22.241.152 (9 Feb 2011 09:03:57 -0800)
X-Original-Trace: 9 Feb 2011 09:03:57 -0800, vip152.sybase.com
Lines: 110
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29947
Article PK: 79178

Can you post the actual query and the ASE version?

R.

On 09-Feb-2011 16:57, J wrote:
> On 9 Feb 2011 00:08:05 -0800, "Rob V [ Sybase ]"
> <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
>
> Rob, I tried a later version of the DBISQL with later Sybase Centrail
> and the warnings are fine there.
>
> Jay
>
>> On 09-Feb-2011 05:43, res wrote:
>>> Hi all
>>> while trying to select users in a database from sybase
>>> central (ASE 12.5.2)i'm getting a message like 'The order-by
>>> position number 'n' is out of range of the number of items
>>> in the select list'. however this err. doesn't appear for
>>> scjava version.
>>>
>>> is this due to any indexing issues? please assist to find
>>> out which table index is creating thie err.?
>>>
>>>
>>> Thanks
>>> res
>> This error has nothing to do with indexing. It comes from queries with
>> an order-by clause using positional specifiers, such as this one:
>>
>> select name, id, crdate
> >from sysobjects
>> order by 3, 1, 2 -- using positional specifiers rather than column names
>>
>>
>> If you'd specify 'order by 4,1,2' instead, you get the error you mention
>> since there are only 3 columns in the result set.
>> I'm guessing the Java version suppresses the error or something.
>>
>> 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
>> -----------------------------------------------------------------
>>

--
Dear Sybase user,

I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.

Kind regards,

Rob Verschoor

If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html

See the
ASE reference manual / System Administration Guide / Transact-SQL user's guide
This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .

For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .

... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).


To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .

For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .

The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .

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
-----------------------------------------------------------------


J Posted on 2011-02-09 19:54:33.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
Reply-To: J@bogusemailAddress.com
Message-ID: <4d52ef17.531728093@forums.sybase.com>
References: <4d521b68.575c.1681692777@sybase.com> <4d524b65$1@forums-1-dub> <4d52b957.517968515@forums.sybase.com> <4d52c8fd$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Feb 2011 11:54:33 -0800
X-Trace: forums-1-dub 1297281273 10.22.241.152 (9 Feb 2011 11:54:33 -0800)
X-Original-Trace: 9 Feb 2011 11:54:33 -0800, vip152.sybase.com
Lines: 131
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29948
Article PK: 79180

On 9 Feb 2011 09:03:57 -0800, "Rob V [ Sybase ]"
<robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:

DBISQL Version - Interactive SQL Version 11.0.1, build 2430

create table xx (c1 int, c2 int)
insert xx values (1,1)
insert xx values (2,2)
select * from xx order by 3,2,1

Error:

Could not execute statement.
The order-by position number '3' is out of range of the number of
items in the select-list.
Sybase error code=7757
Severity Level=16, State=1, Transaction State=1

Jay

>Can you post the actual query and the ASE version?
>
>R.
>
>
>
>
>On 09-Feb-2011 16:57, J wrote:
>> On 9 Feb 2011 00:08:05 -0800, "Rob V [ Sybase ]"
>> <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
>>
>> Rob, I tried a later version of the DBISQL with later Sybase Centrail
>> and the warnings are fine there.
>>
>> Jay
>>
>>> On 09-Feb-2011 05:43, res wrote:
>>>> Hi all
>>>> while trying to select users in a database from sybase
>>>> central (ASE 12.5.2)i'm getting a message like 'The order-by
>>>> position number 'n' is out of range of the number of items
>>>> in the select list'. however this err. doesn't appear for
>>>> scjava version.
>>>>
>>>> is this due to any indexing issues? please assist to find
>>>> out which table index is creating thie err.?
>>>>
>>>>
>>>> Thanks
>>>> res
>>> This error has nothing to do with indexing. It comes from queries with
>>> an order-by clause using positional specifiers, such as this one:
>>>
>>> select name, id, crdate
>> >from sysobjects
>>> order by 3, 1, 2 -- using positional specifiers rather than column names
>>>
>>>
>>> If you'd specify 'order by 4,1,2' instead, you get the error you mention
>>> since there are only 3 columns in the result set.
>>> I'm guessing the Java version suppresses the error or something.
>>>
>>> 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
>>> -----------------------------------------------------------------
>>>
>
>
>--
>Dear Sybase user,
>
>I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
>Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
>These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
>Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
>Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.
>
>Kind regards,
>
>Rob Verschoor
>
>If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html
>
>See the
>ASE reference manual / System Administration Guide / Transact-SQL user's guide
>This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .
>
>For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .
>
>... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).
>
>
>To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .
>
>For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .
>
>The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .
>
>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-02-09 21:04:41.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 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
References: <4d521b68.575c.1681692777@sybase.com> <4d524b65$1@forums-1-dub> <4d52b957.517968515@forums.sybase.com> <4d52c8fd$1@forums-1-dub> <4d52ef17.531728093@forums.sybase.com>
In-Reply-To: <4d52ef17.531728093@forums.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: <4d530169$1@forums-1-dub>
Date: 9 Feb 2011 13:04:41 -0800
X-Trace: forums-1-dub 1297285481 10.22.241.152 (9 Feb 2011 13:04:41 -0800)
X-Original-Trace: 9 Feb 2011 13:04:41 -0800, vip152.sybase.com
Lines: 135
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29949
Article PK: 79173

ummmmm, there are only 2 columns in the xx table so the '3' position identifier doesn't make sense when there will only
be 2 columns in the final result set (ie, 'out of range of the number of items in the select-list').

On 02/09/2011 14:54, J wrote:
> On 9 Feb 2011 09:03:57 -0800, "Rob V [ Sybase ]"
> <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
>
> DBISQL Version - Interactive SQL Version 11.0.1, build 2430
>
> create table xx (c1 int, c2 int)
> insert xx values (1,1)
> insert xx values (2,2)
> select * from xx order by 3,2,1
>
> Error:
>
> Could not execute statement.
> The order-by position number '3' is out of range of the number of
> items in the select-list.
> Sybase error code=7757
> Severity Level=16, State=1, Transaction State=1
>
> Jay
>
>> Can you post the actual query and the ASE version?
>>
>> R.
>>
>>
>>
>>
>> On 09-Feb-2011 16:57, J wrote:
>>> On 9 Feb 2011 00:08:05 -0800, "Rob V [ Sybase ]"
>>> <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
>>>
>>> Rob, I tried a later version of the DBISQL with later Sybase Centrail
>>> and the warnings are fine there.
>>>
>>> Jay
>>>
>>>> On 09-Feb-2011 05:43, res wrote:
>>>>> Hi all
>>>>> while trying to select users in a database from sybase
>>>>> central (ASE 12.5.2)i'm getting a message like 'The order-by
>>>>> position number 'n' is out of range of the number of items
>>>>> in the select list'. however this err. doesn't appear for
>>>>> scjava version.
>>>>>
>>>>> is this due to any indexing issues? please assist to find
>>>>> out which table index is creating thie err.?
>>>>>
>>>>>
>>>>> Thanks
>>>>> res
>>>> This error has nothing to do with indexing. It comes from queries with
>>>> an order-by clause using positional specifiers, such as this one:
>>>>
>>>> select name, id, crdate
>>> >from sysobjects
>>>> order by 3, 1, 2 -- using positional specifiers rather than column names
>>>>
>>>>
>>>> If you'd specify 'order by 4,1,2' instead, you get the error you mention
>>>> since there are only 3 columns in the result set.
>>>> I'm guessing the Java version suppresses the error or something.
>>>>
>>>> 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
>>>> -----------------------------------------------------------------
>>>>
>>
>>
>> --
>> Dear Sybase user,
>>
>> I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
>> Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
>> These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
>> Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
>> Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.
>>
>> Kind regards,
>>
>> Rob Verschoor
>>
>> If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html
>>
>> See the
>> ASE reference manual / System Administration Guide / Transact-SQL user's guide
>> This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .
>>
>> For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .
>>
>> ... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).
>>
>>
>> To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .
>>
>> For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .
>>
>> The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .
>>
>> 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
>> -----------------------------------------------------------------
>>
>


J Posted on 2011-02-10 15:52:20.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
Reply-To: J@bogusemailAddress.com
Message-ID: <4d540976.604014093@forums.sybase.com>
References: <4d521b68.575c.1681692777@sybase.com> <4d524b65$1@forums-1-dub> <4d52b957.517968515@forums.sybase.com> <4d52c8fd$1@forums-1-dub> <4d52ef17.531728093@forums.sybase.com> <4d530169$1@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 10 Feb 2011 07:52:20 -0800
X-Trace: forums-1-dub 1297353140 10.22.241.152 (10 Feb 2011 07:52:20 -0800)
X-Original-Trace: 10 Feb 2011 07:52:20 -0800, vip152.sybase.com
Lines: 145
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29953
Article PK: 79183

On 9 Feb 2011 13:04:41 -0800, "Mark A. Parsons"
<iron_horse@no_spamola.compuserve.com> wrote:

Yes the post was stating that he did not see the error message and I
was stating that with the DBISQL from a much later version of Sybase
Central that this is not a problem (the missing error message).

Jay

>ummmmm, there are only 2 columns in the xx table so the '3' position identifier doesn't make sense when there will only
>be 2 columns in the final result set (ie, 'out of range of the number of items in the select-list').
>
>On 02/09/2011 14:54, J wrote:
>> On 9 Feb 2011 09:03:57 -0800, "Rob V [ Sybase ]"
>> <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
>>
>> DBISQL Version - Interactive SQL Version 11.0.1, build 2430
>>
>> create table xx (c1 int, c2 int)
>> insert xx values (1,1)
>> insert xx values (2,2)
>> select * from xx order by 3,2,1
>>
>> Error:
>>
>> Could not execute statement.
>> The order-by position number '3' is out of range of the number of
>> items in the select-list.
>> Sybase error code=7757
>> Severity Level=16, State=1, Transaction State=1
>>
>> Jay
>>
>>> Can you post the actual query and the ASE version?
>>>
>>> R.
>>>
>>>
>>>
>>>
>>> On 09-Feb-2011 16:57, J wrote:
>>>> On 9 Feb 2011 00:08:05 -0800, "Rob V [ Sybase ]"
>>>> <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
>>>>
>>>> Rob, I tried a later version of the DBISQL with later Sybase Centrail
>>>> and the warnings are fine there.
>>>>
>>>> Jay
>>>>
>>>>> On 09-Feb-2011 05:43, res wrote:
>>>>>> Hi all
>>>>>> while trying to select users in a database from sybase
>>>>>> central (ASE 12.5.2)i'm getting a message like 'The order-by
>>>>>> position number 'n' is out of range of the number of items
>>>>>> in the select list'. however this err. doesn't appear for
>>>>>> scjava version.
>>>>>>
>>>>>> is this due to any indexing issues? please assist to find
>>>>>> out which table index is creating thie err.?
>>>>>>
>>>>>>
>>>>>> Thanks
>>>>>> res
>>>>> This error has nothing to do with indexing. It comes from queries with
>>>>> an order-by clause using positional specifiers, such as this one:
>>>>>
>>>>> select name, id, crdate
>>>> >from sysobjects
>>>>> order by 3, 1, 2 -- using positional specifiers rather than column names
>>>>>
>>>>>
>>>>> If you'd specify 'order by 4,1,2' instead, you get the error you mention
>>>>> since there are only 3 columns in the result set.
>>>>> I'm guessing the Java version suppresses the error or something.
>>>>>
>>>>> 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
>>>>> -----------------------------------------------------------------
>>>>>
>>>
>>>
>>> --
>>> Dear Sybase user,
>>>
>>> I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
>>> Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
>>> These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
>>> Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
>>> Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.
>>>
>>> Kind regards,
>>>
>>> Rob Verschoor
>>>
>>> If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html
>>>
>>> See the
>>> ASE reference manual / System Administration Guide / Transact-SQL user's guide
>>> This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .
>>>
>>> For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .
>>>
>>> ... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).
>>>
>>>
>>> To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .
>>>
>>> For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .
>>>
>>> The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .
>>>
>>> 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
>>> -----------------------------------------------------------------
>>>
>>


res Posted on 2011-02-10 04:17:13.0Z
Sender: 5529.4d5214cb.1804289383@sybase.com
From: res
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase Central error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d5366c9.53d.1681692777@sybase.com>
References: <4d524b65$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Feb 2011 20:17:13 -0800
X-Trace: forums-1-dub 1297311433 10.22.241.41 (9 Feb 2011 20:17:13 -0800)
X-Original-Trace: 9 Feb 2011 20:17:13 -0800, 10.22.241.41
Lines: 64
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29951
Article PK: 79176

Dear Rob

it's so strange. later the day when i did the same thing i
could see all user details. i haven't used any selece
statements everything through GUI environment of the sybase
central. ie after connecting to the server, clicked on my
database and clicked on the users folder and then the error.

Thanks for the info.

Regards
res

> On 09-Feb-2011 05:43, res wrote:
> > Hi all
> > while trying to select users in a database from sybase
> > central (ASE 12.5.2)i'm getting a message like 'The
> > order-by position number 'n' is out of range of the
> > number of items in the select list'. however this err.
> > doesn't appear for scjava version.
> >
> > is this due to any indexing issues? please assist to
> > find out which table index is creating thie err.?
> >
> >
> > Thanks
> > res
>
> This error has nothing to do with indexing. It comes from
> queries with an order-by clause using positional
> specifiers, such as this one:
>
> select name, id, crdate
> from sysobjects
> order by 3, 1, 2 -- using positional specifiers rather
> than column names
>
>
> If you'd specify 'order by 4,1,2' instead, you get the
> error you mention since there are only 3 columns in the
> result set. I'm guessing the Java version suppresses the
> error or something.
>
> 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
> ----------------------------------------------------------
> -------
>