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.

problem with Interactive SQL version 9.0.2, build 3480 ?

2 posts in General Discussion Last posting was on 2007-08-08 21:21:57.0Z
Murali Minchala Posted on 2007-07-26 12:01:10.0Z
Sender: 18f6.46a887ed.1804289383@sybase.com
From: Murali Minchala
Newsgroups: ianywhere.public.general
Subject: problem with Interactive SQL version 9.0.2, build 3480 ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46a88d06.197e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Jul 2007 05:01:10 -0700
X-Trace: forums-1-dub 1185451270 10.22.241.41 (26 Jul 2007 05:01:10 -0700)
X-Original-Trace: 26 Jul 2007 05:01:10 -0700, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6156
Article PK: 4629

Hi,

we are using ASE 15.0.2 in windows 2003. After executing the
"select into.." command in Interactive SQL version 9.0.2,
build 3480 the below error is coming:

could not execute statement.

The statement used to define the cursor `isql#` is neither a
SELECT nor an EXECUTE.
Sybase error code=3803, SQLState="ZZZZZ"
Line 1


When i run in other(old) build 3332(with 15.0.1) it is
working. And also working in isql(cmd).

Where is the problem? is it bug with new build 3480?

In that case what sould i do?

Thanks in advance.
Murali


Chris Irie Posted on 2007-08-08 21:21:57.0Z
From: "Chris Irie" <irie_spam_free@sybase.com>
Newsgroups: ianywhere.public.general
References: <46a88d06.197e.1681692777@sybase.com>
Subject: Re: problem with Interactive SQL version 9.0.2, build 3480 ?
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: irie-370.sybase.com
X-Original-NNTP-Posting-Host: irie-370.sybase.com
Message-ID: <46ba33f5$1@forums-1-dub>
Date: 8 Aug 2007 14:21:57 -0700
X-Trace: forums-1-dub 1186608117 10.25.99.105 (8 Aug 2007 14:21:57 -0700)
X-Original-Trace: 8 Aug 2007 14:21:57 -0700, irie-370.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6174
Article PK: 2611

Hi Murali,

It would help to know more about what you're doing. For example, can you
show us a complete SELECT statement that demonstrates the problem (and also
the schema of any related tables)?

-- Chris Irie
iAnywhere Solutions

<Murali Minchala> wrote in message
news:46a88d06.197e.1681692777@sybase.com...
> Hi,
>
> we are using ASE 15.0.2 in windows 2003. After executing the
> "select into.." command in Interactive SQL version 9.0.2,
> build 3480 the below error is coming:
>
> could not execute statement.
>
> The statement used to define the cursor `isql#` is neither a
> SELECT nor an EXECUTE.
> Sybase error code=3803, SQLState="ZZZZZ"
> Line 1
>
>
> When i run in other(old) build 3332(with 15.0.1) it is
> working. And also working in isql(cmd).
>
> Where is the problem? is it bug with new build 3480?
>
> In that case what sould i do?
>
> Thanks in advance.
> Murali