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.

Correlation name not found

2 posts in General Discussion Last posting was on 2007-05-16 21:35:08.0Z
Ajantha Posted on 2007-05-16 20:10:44.0Z
Sender: 3a08.464b6351.1804289383@sybase.com
From: Ajantha
Newsgroups: ianywhere.public.general
Subject: Correlation name not found
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <464b6544.3a45.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 May 2007 13:10:44 -0700
X-Trace: forums-1-dub 1179346244 10.22.241.41 (16 May 2007 13:10:44 -0700)
X-Original-Trace: 16 May 2007 13:10:44 -0700, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6006
Article PK: 2466

Hi

I am using Adaptive Server Anywhere ISQL Version 9.0.2.2451
(dbisqlc.exe)

I get a "Correlation name '<username>' not found" error on
running a simple select statement like 'SELECT * from
<username>.employees' or 'SELECT * from employees'

However, I am able to query the same table in Interactive
SQL 9.0.2.2451 and get the right data without any errors. I
am also able to look at the table's data in Sybase Central
(under the Data tab)

I created a new table like:
SELECT * INTO employees_new FROM employees
and queried the new table (employees_new) in Adaptive Server
Anywhere ISQL and have no issues

Any help is appreciated

Thank you!
Ajantha


Ajantha Posted on 2007-05-16 21:35:08.0Z
Sender: 3bc9.464b78cc.1804289383@sybase.com
From: Ajantha
Newsgroups: ianywhere.public.general
Subject: Re: Correlation name not found
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <464b790c.3bd0.1681692777@sybase.com>
References: <464b6544.3a45.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 May 2007 14:35:08 -0700
X-Trace: forums-1-dub 1179351308 10.22.241.41 (16 May 2007 14:35:08 -0700)
X-Original-Trace: 16 May 2007 14:35:08 -0700, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6007
Article PK: 2465

Sorry; found the issue
It had to with how the table was setup via the publication

> Hi
>
> I am using Adaptive Server Anywhere ISQL Version
> 9.0.2.2451 (dbisqlc.exe)
>
> I get a "Correlation name '<username>' not found" error on
> running a simple select statement like 'SELECT * from
> <username>.employees' or 'SELECT * from employees'
>
> However, I am able to query the same table in Interactive
> SQL 9.0.2.2451 and get the right data without any errors.
> I am also able to look at the table's data in Sybase
> Central (under the Data tab)
>
> I created a new table like:
> SELECT * INTO employees_new FROM employees
> and queried the new table (employees_new) in Adaptive
> Server Anywhere ISQL and have no issues
>
> Any help is appreciated
>
> Thank you!
> Ajantha