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.

#temp tables

3 posts in General Discussion Last posting was on 2008-09-23 02:54:20.0Z
RSands Posted on 2008-09-11 19:50:08.0Z
Sender: 29fe.48c975c5.1804289383@sybase.com
From: RSands
Newsgroups: sybase.public.workspace.general
Subject: #temp tables
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48c97670.2a1d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Sep 2008 12:50:08 -0700
X-Trace: forums-1-dub 1221162608 10.22.241.41 (11 Sep 2008 12:50:08 -0700)
X-Original-Trace: 11 Sep 2008 12:50:08 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:747
Article PK: 1088421

I cannot see data or edit data for #tables (private temp
tables), only "permanent" tempdb tables.


Chris Pollach Posted on 2008-09-12 12:25:17.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.workspace.general
References: <48c97670.2a1d.1681692777@sybase.com>
Subject: Re: #temp tables
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ca5fad@forums-1-dub>
Date: 12 Sep 2008 05:25:17 -0700
X-Trace: forums-1-dub 1221222317 10.22.241.152 (12 Sep 2008 05:25:17 -0700)
X-Original-Trace: 12 Sep 2008 05:25:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:748
Article PK: 1088418

Hmmm .. I wonder why? I have no problems using these with PowerBuilder!

What permissions (role, group) does your login UserID have?

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<RSands> wrote in message news:48c97670.2a1d.1681692777@sybase.com...
>I cannot see data or edit data for #tables (private temp
> tables), only "permanent" tempdb tables.


Daniel Huang Posted on 2008-09-23 02:54:20.0Z
Reply-To: "Daniel Huang" <lihuang@sybase.com>
From: "Daniel Huang" <lihuang@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <48c97670.2a1d.1681692777@sybase.com> <48ca5fad@forums-1-dub>
Subject: Re: #temp tables
Lines: 44
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48d85a5c$1@forums-1-dub>
Date: 22 Sep 2008 19:54:20 -0700
X-Trace: forums-1-dub 1222138460 10.22.241.152 (22 Sep 2008 19:54:20 -0700)
X-Original-Trace: 22 Sep 2008 19:54:20 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:751
Article PK: 1088423

Hi, RSands:

#tables is a non-shareable temporary table and only visible in the same
connection session.

You can create a non-shareable temporary table in the stored procedure
editor and edit/view data in Referenced Tables view when you debug this
stored procedure.



--
Thanks and regards,

Daniel Huang

Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Email: lihuang@sybase.com

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:48ca5fad@forums-1-dub...
>
> Hmmm .. I wonder why? I have no problems using these with PowerBuilder!
>
> What permissions (role, group) does your login UserID have?
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> <RSands> wrote in message news:48c97670.2a1d.1681692777@sybase.com...
>>I cannot see data or edit data for #tables (private temp
>> tables), only "permanent" tempdb tables.
>
>