Stored Procedure Global variable question

Solaris 10 SPARC 64 IDS 11.50.FC5 I am trying to run "UPDATE STATISTICS FOR PROCEDURE" on one of my databases. I am receiving the following error: 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently. I have run dbschema -ss -d database_name to see if I can track down the variable. I can't see it anywhere. Where can I look to find this? Larry

If you can't find the variable in the dbschema output (which is odd...), then you could try narrowing it down by updating stats for each procedure and see where the error hits. For example, you can generate the update stats like this: dbaccess <database_name> <<! unload to updproc.sqldelimiter "" select unique "update statistics for procedure " || procname || ";" from sysprocedures where mode in ("O", "D");! export DBACCNOIGN=1 dbaccess -e <database_name> updproc.sql > updproc.out 2>&1 If you still don't find it, then remove the "mode in..." and try again. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Thursday, May 04, 2017 10:27 AM To: ids@iiug.org Subject: Stored Procedure Global variable question [39111] Solaris 10 SPARC 64 IDS 11.50.FC5 I am trying to run "UPDATE STATISTICS FOR PROCEDURE" on one of my databases. I am receiving the following error: 699: Global variable (ksavage.use_fuzzy5mbid) declared inconsistently. I have run dbschema -ss -d database_name to see if I can track down the variable. I can't see it anywhere. Where can I look to find this? Larry **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.