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.

maximum number of text columns in a table

6 posts in General Discussion Last posting was on 2012-08-02 07:50:02.0Z
motif Posted on 2012-08-01 15:18:56.0Z
Sender: 3e59.5019414d.1804289383@sybase.com
From: motif
Newsgroups: sybase.public.ase.general
Subject: maximum number of text columns in a table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <501948e0.3f8c.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Aug 2012 08:18:56 -0700
X-Trace: forums-1-dub 1343834336 172.20.134.41 (1 Aug 2012 08:18:56 -0700)
X-Original-Trace: 1 Aug 2012 08:18:56 -0700, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31306
Article PK: 74195

ASE version: 15.5 ESD#5.1

My impression is that only one text column per table is
allowed in a table. But seems can't find reference in any
Sybase document.

Is this a new changed? Or maybe this is replication
limitation. But didn't find it in Rep document.

Now, I can created two text columns in a table in ASE 15.5
ESD#5.1. Not sure multiple text columns are allowed in Rep
environment or previous ASE ESD.

Would anyone confirm this or point me to the right document?


Rob V Posted on 2012-08-01 15:35:25.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: maximum number of text columns in a table
References: <501948e0.3f8c.1681692777@sybase.com>
In-Reply-To: <501948e0.3f8c.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: <50194cbd$1@forums-1-dub>
Date: 1 Aug 2012 08:35:25 -0700
X-Trace: forums-1-dub 1343835325 172.20.134.152 (1 Aug 2012 08:35:25 -0700)
X-Original-Trace: 1 Aug 2012 08:35:25 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31308
Article PK: 74196


On 01-Aug-2012 17:18, motif wrote:
> ASE version: 15.5 ESD#5.1
>
> My impression is that only one text column per table is
> allowed in a table. But seems can't find reference in any
> Sybase document.
>
> Is this a new changed? Or maybe this is replication
> limitation. But didn't find it in Rep document.
>
> Now, I can created two text columns in a table in ASE 15.5
> ESD#5.1. Not sure multiple text columns are allowed in Rep
> environment or previous ASE ESD.
>
> Would anyone confirm this or point me to the right document?
>

There is no limitation on the number of text or image columns in a
table, and there has never been one. The only limit is the number of
columns in a table, regardless of datatype, which is 1024.

HTH,

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

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"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
-----------------------------------------------------------------


motif Posted on 2012-08-01 15:41:49.0Z
Sender: 3e59.5019414d.1804289383@sybase.com
From: motif
Newsgroups: sybase.public.ase.general
Subject: Re: maximum number of text columns in a table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50194e3d.403a.1681692777@sybase.com>
References: <50194cbd$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Aug 2012 08:41:49 -0700
X-Trace: forums-1-dub 1343835709 172.20.134.41 (1 Aug 2012 08:41:49 -0700)
X-Original-Trace: 1 Aug 2012 08:41:49 -0700, 172.20.134.41
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31310
Article PK: 74199

Thanks Rob for clarification.

> On 01-Aug-2012 17:18, motif wrote:
> > ASE version: 15.5 ESD#5.1
> >
> > My impression is that only one text column per table is
> > allowed in a table. But seems can't find reference in
> > any Sybase document.
> >
> > Is this a new changed? Or maybe this is replication
> > limitation. But didn't find it in Rep document.
> >
> > Now, I can created two text columns in a table in ASE
> > 15.5 ESD#5.1. Not sure multiple text columns are allowed
> > in Rep environment or previous ASE ESD.
> >
> > Would anyone confirm this or point me to the right
> document? >
>
> There is no limitation on the number of text or image
> columns in a table, and there has never been one. The
> only limit is the number of columns in a table,
> regardless of datatype, which is 1024.
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide"
> "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
> ----------------------------------------------------------
> -------


Bret Halford Posted on 2012-08-01 16:45:22.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: maximum number of text columns in a table
References: <50194cbd$1@forums-1-dub> <50194e3d.403a.1681692777@sybase.com>
In-Reply-To: <50194e3d.403a.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: <50195d22$1@forums-1-dub>
Date: 1 Aug 2012 09:45:22 -0700
X-Trace: forums-1-dub 1343839522 172.20.134.152 (1 Aug 2012 09:45:22 -0700)
X-Original-Trace: 1 Aug 2012 09:45:22 -0700, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31312
Article PK: 74201

What you may be thinking of is that
the space for all the text and image columns
in a table are stored separately from the
main data row. This space is tracked using
a row in sysindexes with index id 255; there
is at most one such row per table - but it
can be shared by multiple text/image columns
in the table.

-bret


Cory Sane [TeamSybase] Posted on 2012-08-02 05:24:47.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <50194cbd$1@forums-1-dub> <50194e3d.403a.1681692777@sybase.com> <50195d22$1@forums-1-dub>
In-Reply-To: <50195d22$1@forums-1-dub>
Subject: Re: maximum number of text columns in a table
Lines: 19
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <501a0f1f$1@forums-1-dub>
Date: 1 Aug 2012 22:24:47 -0700
X-Trace: forums-1-dub 1343885087 172.20.134.152 (1 Aug 2012 22:24:47 -0700)
X-Original-Trace: 1 Aug 2012 22:24:47 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31314
Article PK: 74202

Bret, As a follow up question... When does replication indexes #254 come into play?

--
Cory Sane
[TeamSybase]
Certified Sybase ASE 15.0 Administrator Associate
Certified Sybase ASE 15.0 SQL Developer Professional

"Bret Halford" <bret@sybase.com> wrote in message news:50195d22$1@forums-1-dub...
> What you may be thinking of is that
> the space for all the text and image columns
> in a table are stored separately from the
> main data row. This space is tracked using
> a row in sysindexes with index id 255; there
> is at most one such row per table - but it
> can be shared by multiple text/image columns
> in the table.
>
> -bret
>


Rob V Posted on 2012-08-02 07:50:02.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: maximum number of text columns in a table
References: <50194cbd$1@forums-1-dub> <50194e3d.403a.1681692777@sybase.com> <50195d22$1@forums-1-dub> <501a0f1f$1@forums-1-dub>
In-Reply-To: <501a0f1f$1@forums-1-dub>
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: <501a312a$1@forums-1-dub>
Date: 2 Aug 2012 00:50:02 -0700
X-Trace: forums-1-dub 1343893802 172.20.134.152 (2 Aug 2012 00:50:02 -0700)
X-Original-Trace: 2 Aug 2012 00:50:02 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31315
Article PK: 74205


On 02-Aug-2012 07:24, Cory Sane [TeamSybase] wrote:
> Bret, As a follow up question... When does replication indexes #254 come
> into play?
>

These have index IDs 254, 253, 252, etc. They apply when marking a table
with a text/image column for replication, and using the "use_index"
option of sp_setreptable, sp_setrepcol or sp_reptostandby.
it follows that there is a limit to the number of text/image columns you
can mark for replication in a table with the use_index clause.

--
HTH,

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

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"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
-----------------------------------------------------------------