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.

Suppress Fetch Warning in ISQL

2 posts in General Discussion Last posting was on 2008-03-12 13:47:25.0Z
Matt Clark Posted on 2008-03-11 20:08:34.0Z
Sender: 1bb8.47d6e4da.1804289383@sybase.com
From: Matt Clark
Newsgroups: ianywhere.public.general
Subject: Suppress Fetch Warning in ISQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47d6e6c2.1bfd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Mar 2008 12:08:34 -0800
X-Trace: forums-1-dub 1205266114 10.22.241.41 (11 Mar 2008 12:08:34 -0800)
X-Original-Trace: 11 Mar 2008 12:08:34 -0800, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6752
Article PK: 4996

Hello,

I'm sure this is an easy one, but I can't find any answer
that works.

I'm running a script in ISQL on a iAnywhere 9.0 database for
Windows (I have downloaded the latest Bug Fix).

I receive a Fetch Warning that says "NULL value eliminated
in aggregate function SQLCODE=109, ODBC 3 State ='01003'

This database is on the local machine so I'm just connecting
using the general file connection. However, I have tried to
connect via ODBC (checking the box that says suppress fetch
warnings), but that doesn't seem to work.

If anyone has any idea how to suppress this warning, I would
love to hear how.

Thanks,
Matt


"Nick Elson" < Posted on 2008-03-12 13:47:25.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <47d6e6c2.1bfd.1681692777@sybase.com>
Subject: Re: Suppress Fetch Warning in ISQL
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47d7deed$1@forums-1-dub>
Date: 12 Mar 2008 05:47:25 -0800
X-Trace: forums-1-dub 1205329645 10.22.241.152 (12 Mar 2008 05:47:25 -0800)
X-Original-Trace: 12 Mar 2008 05:47:25 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6754
Article PK: 4997

You can check out the ANSINULL option.

<Matt Clark> wrote in message news:47d6e6c2.1bfd.1681692777@sybase.com...
> Hello,
>
> I'm sure this is an easy one, but I can't find any answer
> that works.
>
> I'm running a script in ISQL on a iAnywhere 9.0 database for
> Windows (I have downloaded the latest Bug Fix).
>
> I receive a Fetch Warning that says "NULL value eliminated
> in aggregate function SQLCODE=109, ODBC 3 State ='01003'
>
> This database is on the local machine so I'm just connecting
> using the general file connection. However, I have tried to
> connect via ODBC (checking the box that says suppress fetch
> warnings), but that doesn't seem to work.
>
> If anyone has any idea how to suppress this warning, I would
> love to hear how.
>
> Thanks,
> Matt