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.

prepared stmt

3 posts in General Discussion Last posting was on 2010-07-26 13:34:54.0Z
wannabedevloper Posted on 2010-07-23 22:33:45.0Z
Sender: 1414.4c486f74.1804289383@sybase.com
From: wannabedevloper
Newsgroups: sybase.public.ase.general
Subject: prepared stmt
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c4a18c9.29c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Jul 2010 15:33:45 -0700
X-Trace: forums-1-dub 1279924425 10.22.241.41 (23 Jul 2010 15:33:45 -0700)
X-Original-Trace: 23 Jul 2010 15:33:45 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29392
Article PK: 78631

where is prepared statement stored ? data cache or procedure
cache or somewhere in tempdb?


"Mark A. Parsons" <iron_horse Posted on 2010-07-23 22:51:01.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: prepared stmt
References: <4c4a18c9.29c.1681692777@sybase.com>
In-Reply-To: <4c4a18c9.29c.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: <4c4a1cd5$1@forums-1-dub>
Date: 23 Jul 2010 15:51:01 -0700
X-Trace: forums-1-dub 1279925461 10.22.241.152 (23 Jul 2010 15:51:01 -0700)
X-Original-Trace: 23 Jul 2010 15:51:01 -0700, vip152.sybase.com
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29394
Article PK: 78626

In the dataserver prepared statements are turned into light weight procedures (think 'temporary procedures') and thus
reside in procedure cache.

wannabedevloper wrote:
> where is prepared statement stored ? data cache or procedure
> cache or somewhere in tempdb?


wannabedevloper Posted on 2010-07-26 13:34:54.0Z
Sender: a51.4c4d8cf5.1804289383@sybase.com
From: wannabedevloper
Newsgroups: sybase.public.ase.general
Subject: Re: prepared stmt
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c4d8efe.b0b.1681692777@sybase.com>
References: <4c4a1cd5$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Jul 2010 06:34:54 -0700
X-Trace: forums-1-dub 1280151294 10.22.241.41 (26 Jul 2010 06:34:54 -0700)
X-Original-Trace: 26 Jul 2010 06:34:54 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29401
Article PK: 78632

how do i list all the prepared statement at any time?
monProcessProcedures ObjectType is always 'stored procedure'
sometimes trigger? where is 'prepared statement'?

> In the dataserver prepared statements are turned into
> light weight procedures (think 'temporary procedures') and
> thus reside in procedure cache.
>
> wannabedevloper wrote:
> > where is prepared statement stored ? data cache or
> > procedure cache or somewhere in tempdb?