Admin Tools Forum

Re: SPL dbacces vs isql

Posted By: Jonathan Leffler
Date: Thursday, 30 April 2009, at 4:34 a.m.

In Response To: Re: SPL dbacces vs isql (Art Kagel)

On Wed, Apr 29, 2009 at 08:42, Art Kagel <art.kagel@gmail.com> wrote:
> The only answer is to not run it in ISQL. Use dbaccess or Jonathan
> Leffler's sqlcmd instead.

And report the bug to IBM/Informix Tech Support.

There's no reason for the limitation in ISQL if DB-Access can manage it.

> On Wed, Apr 29, 2009 at 10:34 AM, MICHAEL MASON <mase14@gmail.com> wrote:
>
>> I've created a procedure that returns a 25 columns. When I run it in
>> dbaccess
>> I have no issues it retruns the expected results. When I run it under ISQL I
>> get this error "684: Function (mmason.pro_name) returns too many values."
>> The
>> ISQL version is IBM INFORMIX-SQL Version 7.32.FC4.

I suppose officially I should encourage you to check whether the bug
is fixed in ISQL 7.50, but somehow I doubt that it has changed.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Winston Churchill - "The best argument against democracy is a
five-minute conversation with the average voter." -
http://www.brainyquote.com/quotes/authors/w/winston_churchill.html

Messages In This Thread

• SPL dbacces vs isql
  MICHAEL MASON -- Wednesday, 29 April 2009, at 10:34 a.m.
  • Re: SPL dbacces vs isql
    Art Kagel -- Wednesday, 29 April 2009, at 11:42 a.m.
    • Re: SPL dbacces vs isql
      Jonathan Leffler -- Thursday, 30 April 2009, at 4:34 a.m.

Admin Tools Forum is maintained by Administrator with WebBBS 5.12.