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.

Login triggers

2 posts in General Discussion Last posting was on 2011-06-09 08:51:16.0Z
Simon Scott Posted on 2011-06-09 06:54:40.0Z
Sender: 2c1a.4df06cd4.1804289383@sybase.com
From: Simon Scott
Newsgroups: sybase.public.ase.general
Subject: Login triggers
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4df06e30.2c37.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Jun 2011 23:54:40 -0700
X-Trace: forums-1-dub 1307602480 10.22.241.41 (8 Jun 2011 23:54:40 -0700)
X-Original-Trace: 8 Jun 2011 23:54:40 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30238
Article PK: 72417

Hey all

Does or will ASE have the ability to retain temporary tables
created in the login trigger?

Or any other method of creating a default set of temporary
tables for each new connection?

thanks


Matthew Posted on 2011-06-09 08:51:16.0Z
From: Matthew <matt.malthusian@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Login triggers
References: <4df06e30.2c37.1681692777@sybase.com>
In-Reply-To: <4df06e30.2c37.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: <4df08984$1@forums-1-dub>
Date: 9 Jun 2011 01:51:16 -0700
X-Trace: forums-1-dub 1307609476 10.22.241.152 (9 Jun 2011 01:51:16 -0700)
X-Original-Trace: 9 Jun 2011 01:51:16 -0700, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30239
Article PK: 72418

Hi Simon

I think you are left using pre-created regular user tables (in tempdb):

create table tempdb..temptable (...)


Ref:
http://tinyurl.com/6jj8g7j

/Matt

On 2011-06-09 08:54, Simon Scott wrote:
> Hey all
>
> Does or will ASE have the ability to retain temporary tables
> created in the login trigger?
>
> Or any other method of creating a default set of temporary
> tables for each new connection?
>
> thanks