I'm sure this is an easy one, but I can't find any answer
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.
From: Matt Clark
Subject: Suppress Fetch Warning in ISQL
X-Mailer: WebNews to Mail Gateway v1.1t
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
Xref: forums-1-dub ianywhere.public.general:6752
Article PK: 4996
Subject: Re: Suppress Fetch Warning in ISQL
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
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
Xref: forums-1-dub ianywhere.public.general:6754
Article PK: 4997
You can check out the ANSINULL option.