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.

Maximun length of sql text in ASE

4 posts in General Discussion Last posting was on 2009-06-01 15:09:08.0Z
heroxulei Posted on 2009-05-27 08:18:32.0Z
From: heroxulei@hotmail.com
Newsgroups: sybase.public.ase.general
Subject: Maximun length of sql text in ASE
Date: Wed, 27 May 2009 01:18:32 -0700 (PDT)
Organization: http://groups.google.com
Lines: 4
Message-ID: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.com>
NNTP-Posting-Host: 192.250.175.25
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1243412313 23547 127.0.0.1 (27 May 2009 08:18:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 27 May 2009 08:18:33 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a7g2000yqk.googlegroups.com; posting-host=192.250.175.25; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 nogrdcpx01a.statestr.com:80 (IronPort-WSA/5.6.2-102)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!a7g2000yqk.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27797
Article PK: 77049

In ASE, is there any parameter that specifies the maximun allowed
length of sql text?

Thanks for help.


Jeff Tallman [Sybase] Posted on 2009-05-27 18:19:13.0Z
From: "Jeff Tallman [Sybase]" <jeff.tallman@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Maximun length of sql text in ASE
References: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.com>
In-Reply-To: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.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: <4a1d8421$1@forums-1-dub>
Date: 27 May 2009 11:19:13 -0700
X-Trace: forums-1-dub 1243448353 10.22.241.152 (27 May 2009 11:19:13 -0700)
X-Original-Trace: 27 May 2009 11:19:13 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27798
Article PK: 77048

Besides "set textsize ####"??? Are you trying to restrict a text
column to a specific size (i.e. 20MB) or something?

Jeff Tallman
Enterprise Data Management Products Technical Evangelism
jeff.tallman@sybase.com
http://blogs.sybase.com/database

heroxulei@hotmail.com wrote:
> In ASE, is there any parameter that specifies the maximun allowed
> length of sql text?
>
> Thanks for help.


Neal Stack [Sybase] Posted on 2009-06-01 15:03:46.0Z
Message-ID: <4A23EDD1.6010802@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: heroxulei@hotmail.com
Subject: Re: Maximun length of sql text in ASE
References: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.com>
In-Reply-To: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.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
Date: 1 Jun 2009 08:03:46 -0700
X-Trace: forums-1-dub 1243868626 10.22.241.152 (1 Jun 2009 08:03:46 -0700)
X-Original-Trace: 1 Jun 2009 08:03:46 -0700, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27803
Article PK: 77054

Hello,

I don't believe there is a hard coded maximum length for a SQL statement.

You can see the various limits by using the following commands:
1> dbcc traceon(3604)
2> go
1> dbcc serverlimits
2> go
...etc...
General SQL related

Max size of character literals, sproc parameters : 16384
Max size of local @variables in T-SQL : 16384
Max number of arguments to stored procedures : 2048
Max number of arguments to dynamic SQL : 2048
Max number of aggregates in a COMPUTE clause : 254
Max number of arguments to Java methods : 31
Max number of user tables in a single SQL statement : 512
Max number of internal work tables in a single SQL statement : 46
Max number of subqueries in a single statement : 50
Max number of user-supplied expressions in select list : 4096
Max number of referential integrity user tables per query : 192
Max number of referential integrity work tables per query : 192
...etc...

Regards,
Neal


Bret Halford [Sybase] Posted on 2009-06-01 15:09:08.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Maximun length of sql text in ASE
References: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.com>
In-Reply-To: <9c09e5d1-eb0e-4904-a547-dd288f6a7bcd@a7g2000yqk.googlegroups.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: <4a23ef14@forums-1-dub>
Date: 1 Jun 2009 08:09:08 -0700
X-Trace: forums-1-dub 1243868948 10.22.241.152 (1 Jun 2009 08:09:08 -0700)
X-Original-Trace: 1 Jun 2009 08:09:08 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27804
Article PK: 77055


heroxulei@hotmail.com wrote:
> In ASE, is there any parameter that specifies the maximun allowed
> length of sql text?
>
> Thanks for help.

If you are asking about a limit on sql batch size, there is no
direct specific limit. Very large batches may fail due to lack
of resources, particularly heap space and free space in procedure
cache. These are fairly dynamic restrictions and generally depend
on the amount of concurrent activity.

-bret