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.

ASCINSERT

7 posts in General Discussion Last posting was on 2012-12-27 17:47:47.0Z
karthik Posted on 2012-12-24 09:42:40.0Z
Sender: 3e56.50d8220b.1804289383@sybase.com
From: Karthik
Newsgroups: sybase.public.ase.general
Subject: ASCINSERT
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50d82390.3eaa.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 24 Dec 2012 01:42:40 -0800
X-Trace: forums-1-dub 1356342160 172.20.134.41 (24 Dec 2012 01:42:40 -0800)
X-Original-Trace: 24 Dec 2012 01:42:40 -0800, 172.20.134.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31599
Article PK: 1158596

Hi,

I need a query to get "ascinsert" value for all the tables
in any userdatabase.

I think we have to use sysindexes --> status2 column. But I
am unable to mask the bit value (32 = 0 & 64 = 1) and form
the query.

If somebody helped on this, it would be great.


Rob V Posted on 2012-12-24 18:56:27.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASCINSERT
References: <50d82390.3eaa.1681692777@sybase.com>
In-Reply-To: <50d82390.3eaa.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: <50d8a55b$1@forums-1-dub>
Date: 24 Dec 2012 10:56:27 -0800
X-Trace: forums-1-dub 1356375387 172.20.134.152 (24 Dec 2012 10:56:27 -0800)
X-Original-Trace: 24 Dec 2012 10:56:27 -0800, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31601
Article PK: 1158601


On 24-Dec-2012 10:42, Karthik wrote:
> Hi,
>
> I need a query to get "ascinsert" value for all the tables
> in any userdatabase.
>
> I think we have to use sysindexes --> status2 column. But I
> am unable to mask the bit value (32 = 0 & 64 = 1) and form
> the query.
>
> If somebody helped on this, it would be great.
>

select * from sysindexes
where status2 & 64 = 64

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


karthik.m Posted on 2012-12-26 05:34:18.0Z
Sender: 7da.50da88e5.1804289383@sybase.com
From: karthik.m
Newsgroups: sybase.public.ase.general
Subject: Re: ASCINSERT
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50da8c5a.925.1681692777@sybase.com>
References: <50d8a55b$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 25 Dec 2012 21:34:18 -0800
X-Trace: forums-1-dub 1356500058 172.20.134.41 (25 Dec 2012 21:34:18 -0800)
X-Original-Trace: 25 Dec 2012 21:34:18 -0800, 172.20.134.41
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31603
Article PK: 1158605

select * from sysindexes
where status2 & 64 = 64

No..It didn't return any rows. But when i run sp_help
<tablename>

I can see 0 for ascinsert for all the "ALLPAGE" lock tables.

> On 24-Dec-2012 10:42, Karthik wrote:
> > Hi,
> >
> > I need a query to get "ascinsert" value for all the
> > tables in any userdatabase.
> >
> > I think we have to use sysindexes --> status2 column.
> > But I am unable to mask the bit value (32 = 0 & 64 = 1)
> > and form the query.
> >
> > If somebody helped on this, it would be great.
> >
>
>
> select * from sysindexes
> where status2 & 64 = 64
>
> --
> 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
> ----------------------------------------------------------
> -------


Rob V Posted on 2012-12-26 11:05:39.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASCINSERT
References: <50d8a55b$1@forums-1-dub> <50da8c5a.925.1681692777@sybase.com>
In-Reply-To: <50da8c5a.925.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: <50dada03@forums-1-dub>
Date: 26 Dec 2012 03:05:39 -0800
X-Trace: forums-1-dub 1356519939 172.20.134.152 (26 Dec 2012 03:05:39 -0800)
X-Original-Trace: 26 Dec 2012 03:05:39 -0800, vip152.sybase.com
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31608
Article PK: 1158610

...so the conclusion is that the query works since ascinsrt is off for
all tables. Right?

R.

On 26-Dec-2012 06:34, karthik.m wrote:
> select * from sysindexes
> where status2 & 64 = 64
>
> No..It didn't return any rows. But when i run sp_help
> <tablename>
>
> I can see 0 for ascinsert for all the "ALLPAGE" lock tables.
>
>
>
>
>
>> On 24-Dec-2012 10:42, Karthik wrote:
>>> Hi,
>>>
>>> I need a query to get "ascinsert" value for all the
>>> tables in any userdatabase.
>>>
>>> I think we have to use sysindexes --> status2 column.
>>> But I am unable to mask the bit value (32 = 0 & 64 = 1)
>>> and form the query.
>>>
>>> If somebody helped on this, it would be great.
>>>
>>
>>
>> select * from sysindexes
>> where status2 & 64 = 64
>>
>> --
>> 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
>> ----------------------------------------------------------
>> -------


Karthik M Posted on 2012-12-27 04:21:48.0Z
Sender: 7a10.50dbcc45.1804289383@sybase.com
From: Karthik M
Newsgroups: sybase.public.ase.general
Subject: Re: ASCINSERT
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50dbccdb.7a18.1681692777@sybase.com>
References: <50dada03@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 26 Dec 2012 20:21:48 -0800
X-Trace: forums-1-dub 1356582108 172.20.134.41 (26 Dec 2012 20:21:48 -0800)
X-Original-Trace: 26 Dec 2012 20:21:48 -0800, 172.20.134.41
Lines: 70
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31613
Article PK: 1158623

Nope. Query didn't work.

Note: ascinsert is 0 for most of the tables.

I need a query which will show whether ascinsert is off or
not.

> ...so the conclusion is that the query works since
> ascinsrt is off for all tables. Right?
>
> R.
>
>
>
> On 26-Dec-2012 06:34, karthik.m wrote:
> > select * from sysindexes
> > where status2 & 64 = 64
> >
> > No..It didn't return any rows. But when i run sp_help
> > <tablename>
> >
> > I can see 0 for ascinsert for all the "ALLPAGE" lock
> tables. >
> >
> >
> >
> >
> >> On 24-Dec-2012 10:42, Karthik wrote:
> >>> Hi,
> >>>
> >>> I need a query to get "ascinsert" value for all the
> >>> tables in any userdatabase.
> >>>
> >>> I think we have to use sysindexes --> status2 column.
> >>> But I am unable to mask the bit value (32 = 0 & 64 =
> 1) >>> and form the query.
> >>>
> >>> If somebody helped on this, it would be great.
> >>>
> >>
> >>
> >> select * from sysindexes
> >> where status2 & 64 = 64
> >>
> >> --
> >> 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-12-27 16:56:51.0Z
From: Bret Halford <bret.halford@sap.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASCINSERT
References: <50dada03@forums-1-dub> <50dbccdb.7a18.1681692777@sybase.com>
In-Reply-To: <50dbccdb.7a18.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: <50dc7dd3$1@forums-1-dub>
Date: 27 Dec 2012 08:56:51 -0800
X-Trace: forums-1-dub 1356627411 172.20.134.152 (27 Dec 2012 08:56:51 -0800)
X-Original-Trace: 27 Dec 2012 08:56:51 -0800, vip152.sybase.com
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31615
Article PK: 1158632


On 12/26/2012 9:21 PM, Karthik M wrote:
> Nope. Query didn't work.
>
> Note: ascinsert is 0 for most of the tables.
>
> I need a query which will show whether ascinsert is off or
> not.
>
>

It is always helpful to specify exactly what happened
rather than just saying "didn't work". The query
should have returned all the tables for which ASCINSERTS
was on (it does on my test server).

Perhaps you are just looking for a variant of the query
such as the following?


create table t_asc (x int)
go
create table t_n_asc (x int)
go
dbcc tune(ascinserts, 1, t_asc)
go
select left(object_name(id), 40) as "name",
case
when (status2 & 64) = 64
then "on"
else
"off"
end as "ascinserts"
from
sysindexes
where
id > 99 -- user tables only
go



name ascinserts
---------------------------------------- ----------
t_asc on
t_n_asc off

(2 rows affected)




--
Bret Halford
Support Architect, ASE Tactical Support Team, AGS Primary Support
Sybase, Inc., an SAP Company
385 Interlocken Crescent, Suite 300, Broomfield, Colorado, 80021


Mark A. Parsons Posted on 2012-12-27 17:47:47.0Z
Sender: 29b5.50dc88d4.1804289383@sybase.com
From: Mark A. Parsons
Newsgroups: sybase.public.ase.general
Subject: Re: ASCINSERT
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50dc89c3.29d1.1681692777@sybase.com>
References: <50dc7dd3$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 27 Dec 2012 09:47:47 -0800
X-Trace: forums-1-dub 1356630467 172.20.134.41 (27 Dec 2012 09:47:47 -0800)
X-Original-Trace: 27 Dec 2012 09:47:47 -0800, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31616
Article PK: 1158634


> On 12/26/2012 9:21 PM, Karthik M wrote:
> > Nope. Query didn't work.
> >
> > Note: ascinsert is 0 for most of the tables.
> >
> > I need a query which will show whether ascinsert is off
> > or not.
> >
> >
>
> It is always helpful to specify exactly what happened
> rather than just saying "didn't work". The query
> should have returned all the tables for which ASCINSERTS
> was on (it does on my test server).

Alternatively the OP can always look at the source code for
a Sybase-supplied system procedure which provides the
desired info, eg, pull the relevant ascinsert-related query
pieces from the source code for the sp_help stored proc.