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.

Symbol (object) lookups in case-insensitive servers

2 posts in General Discussion Last posting was on 2008-03-18 23:37:23.0Z
mpeppler Posted on 2008-03-17 12:27:54.0Z
Sender: 5c3a.47de4144.1804289383@sybase.com
From: mpeppler@peppler.org
Newsgroups: sybase.public.workspace.general
Subject: Symbol (object) lookups in case-insensitive servers
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47de63ca.6035.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Mar 2008 04:27:54 -0800
X-Trace: forums-1-dub 1205756874 10.22.241.41 (17 Mar 2008 04:27:54 -0800)
X-Original-Trace: 17 Mar 2008 04:27:54 -0800, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:632
Article PK: 1088309

Hi,

We have a number of ASE servers that are built with the
case-insensitive sort order. In such a server the case of
objects is not checked by ASE when referring to a
table/proc, so quite often you might have a table called
CACHE_data but accessed with

select ... from cache_data, ...

in T-SQL code.

When this happens then Workspace (2.0.1) won't find the
object when you use F3 to look it up (I guess WS loads the
objects to memory, and uses normal string comparisons to do
lookups.)

Michael


Samir Nigam Posted on 2008-03-18 23:37:23.0Z
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47de63ca.6035.1681692777@sybase.com>
Subject: Re: Symbol (object) lookups in case-insensitive servers
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47e05233$1@forums-1-dub>
Date: 18 Mar 2008 15:37:23 -0800
X-Trace: forums-1-dub 1205883443 10.22.241.152 (18 Mar 2008 15:37:23 -0800)
X-Original-Trace: 18 Mar 2008 15:37:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:636
Article PK: 1088314

Thanks for letting us know. I have created a CR 494760 to get this issue
addressed.

Regards,
Samir

<mpeppler@peppler.org> wrote in message
news:47de63ca.6035.1681692777@sybase.com...
> Hi,
>
> We have a number of ASE servers that are built with the
> case-insensitive sort order. In such a server the case of
> objects is not checked by ASE when referring to a
> table/proc, so quite often you might have a table called
> CACHE_data but accessed with
>
> select ... from cache_data, ...
>
> in T-SQL code.
>
> When this happens then Workspace (2.0.1) won't find the
> object when you use F3 to look it up (I guess WS loads the
> objects to memory, and uses normal string comparisons to do
> lookups.)
>
> Michael