Global variable in a stored procedure
On Solaris/IDS 11.50, UPDATE STATISTICS ON PROCEDURE for a whole database failed with error 699 (global variable ksavage.use_fuzzy5mbid declared inconsistently), but the variable couldn't be found in the dbschema -ss output. Art Kagel suggested querying sysprocedures/sysprocbody (datakey='T') with a MATCHES pattern on the variable name, and Mike Walker suggested wrapping it in lower() for case differences; neither returned rows. Running UPDATE STATISTICS per procedure (as dostats does) let the poster process all 309 procedures and isolate two with inconsistent global declarations, though none mentioned the fuzzy5mbid variable. The original error's source was never identified, so no real resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Solaris 10
IDS 11.50.FC5
SPARC 64
I am trying to do a
UPDATE STATISTICS ON PROCEDURE
on one of our databases. I receive the following error.
699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.
I have run the following to get a look at the stored procedures.
dbschema -ss -d database > file_name
I can't find that variable anywhere in any procedure. Where else should/can I
look to try to find the variable?
Larry
select procname
from sysprocedures sp, sysprocbody spb
where sp.procid = spb.procid
and datakey = 'T'
and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> Solaris 10
>
> IDS 11.50.FC5
>
> SPARC 64
>
> I am trying to do a
>
> UPDATE STATISTICS ON PROCEDURE>
> on one of our databases. I receive the following error.
>
> 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.>
> I have run the following to get a look at the stored procedures.
>
> dbschema -ss -d database > file_name>
> I can't find that variable anywhere in any procedure. Where else
> should/can I
> look to try to find the variable?
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045ff682d45508054eb53d02
I tried it with spaces before the commas below and without spaces before the
comments below (in the brackets) and no rows are returned.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Thursday, May 4, 2017 10:27 AM
To: ids@iiug.org
Subject: Re: Global variable in a stored procedure [39112]
select procname
from sysprocedures sp, sysprocbody spb
where sp.procid = spb.procid
and datakey = 'T'
and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> Solaris 10
>
> IDS 11.50.FC5
>
> SPARC 64
>
> I am trying to do a
>
> UPDATE STATISTICS ON PROCEDURE>
> on one of our databases. I receive the following error.
>
> 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.>
> I have run the following to get a look at the stored procedures.
>
> dbschema -ss -d database > file_name>
> I can't find that variable anywhere in any procedure. Where else
> should/can I
> look to try to find the variable?
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045ff682d45508054eb53d02
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Have you tried looking for references in upper case?
Perhaps: ... and lower(data) matches '*[ ,]use_fuzzy5mbid[ ,]*';
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Thursday, May 04, 2017 10:39 AM
To: ids@iiug.org
Subject: Re: Global variable in a stored procedure [39113]
I tried it with spaces before the commas below and without spaces before the
comments below (in the brackets) and no rows are returned.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Thursday, May 4, 2017 10:27 AM
To: ids@iiug.org
Subject: Re: Global variable in a stored procedure [39112]
select procname
from sysprocedures sp, sysprocbody spb
where sp.procid = spb.procid
and datakey = 'T'
and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
Art
Art S. Kagel, President and Principal Consultant ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> Solaris 10
>
> IDS 11.50.FC5
>
> SPARC 64
>
> I am trying to do a
>
> UPDATE STATISTICS ON PROCEDURE>
> on one of our databases. I receive the following error.
>
> 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.>
> I have run the following to get a look at the stored procedures.
>
> dbschema -ss -d database > file_name>
> I can't find that variable anywhere in any procedure. Where else
> should/can I look to try to find the variable?
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045ff682d45508054eb53d02
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
The spaces should be there. The variable name is preceded and followed by
either a space or a comma. Hmm. Don't know what that means. This query
should find any definition like:
define global use_fuzzy5mbid type;
define global barney,use_fuzzy5mbid, freddy type;
You could try adding a tab character to the search, but ...
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 12:38 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I tried it with spaces before the commas below and without spaces before
> the
> comments below (in the brackets) and no rows are returned.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:27 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39112]
>
> select procname
> from sysprocedures sp, sysprocbody spb
> where sp.procid = spb.procid>
> and datakey = 'T'
>
> and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > SPARC 64
> >
> > I am trying to do a
> >
> > UPDATE STATISTICS ON PROCEDURE> >
> > on one of our databases. I receive the following error.
> >
> > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> >
> > I have run the following to get a look at the stored procedures.
> >
> > dbschema -ss -d database > file_name> >
> > I can't find that variable anywhere in any procedure. Where else
> > should/can I
> > look to try to find the variable?
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403045ff682d45508054eb53d02
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a114d0e3c64721a054eb585a5
Hmm. Try running the update statistics for each procedure individually,
that's what dostats does. At worst it should show you which procedure
causes the error! It might just get past it that way.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 12:38 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I tried it with spaces before the commas below and without spaces before
> the
> comments below (in the brackets) and no rows are returned.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:27 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39112]
>
> select procname
> from sysprocedures sp, sysprocbody spb
> where sp.procid = spb.procid>
> and datakey = 'T'
>
> and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > SPARC 64
> >
> > I am trying to do a
> >
> > UPDATE STATISTICS ON PROCEDURE> >
> > on one of our databases. I receive the following error.
> >
> > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> >
> > I have run the following to get a look at the stored procedures.
> >
> > dbschema -ss -d database > file_name> >
> > I can't find that variable anywhere in any procedure. Where else
> > should/can I
> > look to try to find the variable?
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403045ff682d45508054eb53d02
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c11b594051d2e054eb58ac1
Ooooo. DUH! Or mixed case!. So:
select procname
from sysprocedures sp, sysprocbody spb
where sp.procid = spb.procid
and datakey = 'T'
and lower(data) matches '*[ ,]use_fuzzy5mbid[ ,]*';
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 12:46 PM, Mike Walker <mike@advancedatatools.com>
wrote:
> Have you tried looking for references in upper case?
>
> Perhaps: ... and lower(data) matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY
> SORENSEN
> Sent: Thursday, May 04, 2017 10:39 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39113]
>
> I tried it with spaces before the commas below and without spaces before
> the
> comments below (in the brackets) and no rows are returned.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:27 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39112]
>
> select procname
> from sysprocedures sp, sysprocbody spb
> where sp.procid = spb.procid>
> and datakey = 'T'
>
> and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> Art
>
> Art S. Kagel, President and Principal Consultant ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do those
> opinions reflect those of other individuals affiliated with any entity with
> which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > SPARC 64
> >
> > I am trying to do a
> >
> > UPDATE STATISTICS ON PROCEDURE> >
> > on one of our databases. I receive the following error.
> >
> > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> >
> > I have run the following to get a look at the stored procedures.
> >
> > dbschema -ss -d database > file_name> >
> > I can't find that variable anywhere in any procedure. Where else
> > should/can I look to try to find the variable?
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403045ff682d45508054eb53d02
>
> ************************************************************
> ****************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************
> ****************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c11b594ed4309054eb59223
I created a script to update all 309 stored procedures manually.
Two of the stored procedures errored out with a similar error of inconsistent
global variable declaration, but there was no mention of the fuzzy5mbid.
Curious.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Thursday, May 4, 2017 10:49 AM
To: ids@iiug.org
Subject: Re: Global variable in a stored procedure [39117]
Hmm. Try running the update statistics for each procedure individually,
that's what dostats does. At worst it should show you which procedure
causes the error! It might just get past it that way.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 12:38 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I tried it with spaces before the commas below and without spaces before
> the
> comments below (in the brackets) and no rows are returned.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:27 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39112]
>
> select procname
> from sysprocedures sp, sysprocbody spb
> where sp.procid = spb.procid>
> and datakey = 'T'
>
> and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > SPARC 64
> >
> > I am trying to do a
> >
> > UPDATE STATISTICS ON PROCEDURE> >
> > on one of our databases. I receive the following error.
> >
> > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> >
> > I have run the following to get a look at the stored procedures.
> >
> > dbschema -ss -d database > file_name> >
> > I can't find that variable anywhere in any procedure. Where else
> > should/can I
> > look to try to find the variable?
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403045ff682d45508054eb53d02
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c11b594051d2e054eb58ac1
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
very odd.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 1:47 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I created a script to update all 309 stored procedures manually.
>
> Two of the stored procedures errored out with a similar error of
> inconsistent
> global variable declaration, but there was no mention of the fuzzy5mbid.
> Curious.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:49 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39117]
>
> Hmm. Try running the update statistics for each procedure individually,
> that's what dostats does. At worst it should show you which procedure
> causes the error! It might just get past it that way.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 12:38 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > I tried it with spaces before the commas below and without spaces before
> > the
> > comments below (in the brackets) and no rows are returned.
> >
> > Larry
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Thursday, May 4, 2017 10:27 AM
> > To: ids@iiug.org
> > Subject: Re: Global variable in a stored procedure [39112]
> >
> > select procname
> > from sysprocedures sp, sysprocbody spb
> > where sp.procid = spb.procid> >
> > and datakey = 'T'
> >
> > and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> > www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
> > Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
> am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> > wrote:
> >
> > > Solaris 10
> > >
> > > IDS 11.50.FC5
> > >
> > > SPARC 64
> > >
> > > I am trying to do a
> > >
> > > UPDATE STATISTICS ON PROCEDURE> > >
> > > on one of our databases. I receive the following error.
> > >
> > > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> > >
> > > I have run the following to get a look at the stored procedures.
> > >
> > > dbschema -ss -d database > file_name> > >
> > > I can't find that variable anywhere in any procedure. Where else
> > > should/can I
> > > look to try to find the variable?
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --f403045ff682d45508054eb53d02
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --94eb2c11b594051d2e054eb58ac1
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c13edd6fe3c3b054eb685c1
Even with the "lower" in there, nothing was returned.
Oh well. At least I found 2 inconsistencies for declarations in other stored
procedures and updated statistics for all others.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Thursday, May 4, 2017 10:52 AM
To: ids@iiug.org
Subject: Re: Global variable in a stored procedure [39118]
Ooooo. DUH! Or mixed case!. So:
select procname
from sysprocedures sp, sysprocbody spb
where sp.procid = spb.procid
and datakey = 'T'
and lower(data) matches '*[ ,]use_fuzzy5mbid[ ,]*';
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Thu, May 4, 2017 at 12:46 PM, Mike Walker <mike@advancedatatools.com>
wrote:
> Have you tried looking for references in upper case?
>
> Perhaps: ... and lower(data) matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY
> SORENSEN
> Sent: Thursday, May 04, 2017 10:39 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39113]
>
> I tried it with spaces before the commas below and without spaces before
> the
> comments below (in the brackets) and no rows are returned.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:27 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39112]
>
> select procname
> from sysprocedures sp, sysprocbody spb
> where sp.procid = spb.procid>
> and datakey = 'T'
>
> and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
>
> Art
>
> Art S. Kagel, President and Principal Consultant ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com<http://www.askdbmgt.com>;
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do those
> opinions reflect those of other individuals affiliated with any entity with
> which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > SPARC 64
> >
> > I am trying to do a
> >
> > UPDATE STATISTICS ON PROCEDURE> >
> > on one of our databases. I receive the following error.
> >
> > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> >
> > I have run the following to get a look at the stored procedures.
> >
> > dbschema -ss -d database > file_name> >
> > I can't find that variable anywhere in any procedure. Where else
> > should/can I look to try to find the variable?
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403045ff682d45508054eb53d02
>
> ************************************************************
> ****************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************
> ****************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c11b594ed4309054eb59223
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Do you have a procedure called use_fuzzy5mbid?
Regards.
On Thu, May 4, 2017 at 6:47 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I created a script to update all 309 stored procedures manually.
>
> Two of the stored procedures errored out with a similar error of
> inconsistent
> global variable declaration, but there was no mention of the fuzzy5mbid.
> Curious.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:49 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39117]
>
> Hmm. Try running the update statistics for each procedure individually,
> that's what dostats does. At worst it should show you which procedure
> causes the error! It might just get past it that way.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 12:38 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > I tried it with spaces before the commas below and without spaces before
> > the
> > comments below (in the brackets) and no rows are returned.
> >
> > Larry
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Thursday, May 4, 2017 10:27 AM
> > To: ids@iiug.org
> > Subject: Re: Global variable in a stored procedure [39112]
> >
> > select procname
> > from sysprocedures sp, sysprocbody spb
> > where sp.procid = spb.procid> >
> > and datakey = 'T'
> >
> > and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> > www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
> > Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
> am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> > wrote:
> >
> > > Solaris 10
> > >
> > > IDS 11.50.FC5
> > >
> > > SPARC 64
> > >
> > > I am trying to do a
> > >
> > > UPDATE STATISTICS ON PROCEDURE> > >
> > > on one of our databases. I receive the following error.
> > >
> > > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> > >
> > > I have run the following to get a look at the stored procedures.
> > >
> > > dbschema -ss -d database > file_name> > >
> > > I can't find that variable anywhere in any procedure. Where else
> > > should/can I
> > > look to try to find the variable?
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --f403045ff682d45508054eb53d02
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --94eb2c11b594051d2e054eb58ac1
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--001a113518b2e42712054eb7299e
I get the impression that I may have in the past, but I can find no evidence
of anything called "use_fuzzy5mbid" anywhere now.
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Fernando Nunes
<domusonline@gmail.com>
Sent: Thursday, May 4, 2017 12:44 PM
To: ids@iiug.org
Subject: Re: Global variable in a stored procedure [39122]
Do you have a procedure called use_fuzzy5mbid?
Regards.
On Thu, May 4, 2017 at 6:47 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I created a script to update all 309 stored procedures manually.
>
> Two of the stored procedures errored out with a similar error of
> inconsistent
> global variable declaration, but there was no mention of the fuzzy5mbid.
> Curious.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Thursday, May 4, 2017 10:49 AM
> To: ids@iiug.org
> Subject: Re: Global variable in a stored procedure [39117]
>
> Hmm. Try running the update statistics for each procedure individually,
> that's what dostats does. At worst it should show you which procedure
> causes the error! It might just get past it that way.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com<http://www.askdbmgt.com>;
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Thu, May 4, 2017 at 12:38 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > I tried it with spaces before the commas below and without spaces before
> > the
> > comments below (in the brackets) and no rows are returned.
> >
> > Larry
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Thursday, May 4, 2017 10:27 AM
> > To: ids@iiug.org
> > Subject: Re: Global variable in a stored procedure [39112]
> >
> > select procname
> > from sysprocedures sp, sysprocbody spb
> > where sp.procid = spb.procid> >
> > and datakey = 'T'
> >
> > and data matches '*[ ,]use_fuzzy5mbid[ ,]*';
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com<http://www.askdbmgt.com>;
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com<http://www.askdbmgt.com>;
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> > www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com<http://www.askdbmgt.com>;
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
> > Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
> am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Thu, May 4, 2017 at 11:38 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> > wrote:
> >
> > > Solaris 10
> > >
> > > IDS 11.50.FC5
> > >
> > > SPARC 64
> > >
> > > I am trying to do a
> > >
> > > UPDATE STATISTICS ON PROCEDURE> > >
> > > on one of our databases. I receive the following error.
> > >
> > > 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently.> > >
> > > I have run the following to get a look at the stored procedures.
> > >
> > > dbschema -ss -d database > file_name> > >
> > > I can't find that variable anywhere in any procedure. Where else
> > > should/can I
> > > look to try to find the variable?
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --f403045ff682d45508054eb53d02
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --94eb2c11b594051d2e054eb58ac1
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ****************************************************