Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Change Max Tables in SQL
0 views
Skip to first unread message
Chris
Nov 28, 2001, 3:24:31 PM11/28/01
to
We are using ASE on NT 4.0. I really need to change the maximun number of
tables allowed in an SQL statement (default 16). Where is this setting? I
have search through Sybooks several times but have been unable to find the
setting.
tables allowed in an SQL statement (default 16). Where is this setting? I
have search through Sybooks several times but have been unable to find the
setting.
Your expertise is greatly appreciated,
Chris
te...@e-streamsolutions.com
Ilya Zvyagin 2147483647
Nov 29, 2001, 5:09:28 AM11/29/01
to
"Chris" <cfi...@e-streamsolutions.com> wrote in message news:9u3h5e$g3c$1...@linux1.netconx.de...
> We are using ASE on NT 4.0. I really need to change the maximun number of
> tables allowed in an SQL statement (default 16). Where is this setting? I
> have search through Sybooks several times but have been unable to find the
> setting.
You can not change this, unfortunately. ASE 11.9.3 and before can have up to 16
tables in a query, since 12.0 - up to AFAIR 50 tables.
These all including all tables indirectly accessed via views and temporary
tables.
Ollie
Nov 29, 2001, 4:29:19 AM11/29/01
to
What version of ASE are you running? That's not configurable, it is
coded into the software. I believe 12.0 allow more.
Tchau
0 new messages