Update Statistics, with a Table Named Distribution
User reported syntax error when running UPDATE STATISTICS on a table named "distributiions" in IDS 11.50.FC5. Suggestions offered were to use quotes around the table name or prefix with owner name (owner.tablename). User confirmed quotes didn't work and planned to test the owner.tablename approach. No final resolution confirmation provided in thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 11.50.FC5 AIX 5.3 I am attempting to establish resolution and confidence factors for tables within a particular database; however, there is a table named "distributiions" within this database and it is too ingrained within the code to change at this time. This table name generates a syntax error when trying to use this table name in an UPDATE STATISTICS command. Any ideas on how I can specify this tablename within the Update Statistics SQL? Thanks in advance. Clifton _________________________________________________________________ Hotmail: Trusted email with Microsofts powerful SPAM protection. http://clk.atdmt.com/GBL/go/201469226/direct/01/
Clifton Bean wrote: > IDS 11.50.FC5 AIX 5.3 > > I am attempting to establish resolution and confidence factors for tables > within a particular database; however, there is a table named "distributiions" > within this database and it is too ingrained within the code to change at this > time. This table name generates a syntax error when trying to use this table > name in an UPDATE STATISTICS command. > > Any ideas on how I can specify this tablename within the Update Statistics > SQL? Put it in quotes, or prefix it with the owner name? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Did you try using the fully qualified table name, or at least owner.tabname? John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 02/11/2010 03:02:37 PM: > [image removed] > > Update Statistics, with a Table Named Distribu.... [19027] > > Clifton Bean > > to: > > ids > > 02/11/2010 03:03 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > IDS 11.50.FC5 AIX 5.3 > > I am attempting to establish resolution and confidence factors for tables > within a particular database; however, there is a table named > "distributiions" > within this database and it is too ingrained within the code to > change at this > time. This table name generates a syntax error when trying to use this table > name in an UPDATE STATISTICS command. > > Any ideas on how I can specify this tablename within the Update Statistics > SQL? > > Thanks in advance. > > Clifton > > _________________________________________________________________ > Hotmail: Trusted email with Microsoft’s powerful SPAM protection. > http://clk.atdmt.com/GBL/go/201469226/direct/01/ > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
I tried the quotes and it did not work, will try the tablename idea when I return to work tomorrow. Thanks, O. Clifton > To: ids@iiug.org > From: obnoxio@serendipita.com > Subject: Re: Update Statistics, with a Table Named Dist.... [19028] > Date: Thu, 11 Feb 2010 18:06:40 -0500 > > Clifton Bean wrote: > > IDS 11.50.FC5 AIX 5.3 > > > > I am attempting to establish resolution and confidence factors for tables > > within a particular database; however, there is a table named > "distributiions" > > within this database and it is too ingrained within the code to change at > this > > time. This table name generates a syntax error when trying to use this table > > name in an UPDATE STATISTICS command. > > > > Any ideas on how I can specify this tablename within the Update Statistics > > SQL? > > Put it in quotes, or prefix it with the owner name? > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Hotmail: Trusted email with Microsofts powerful SPAM protection. http://clk.atdmt.com/GBL/go/201469226/direct/01/
John Miller iii wrote:
> Did you try using the fully qualified table name, or at least
> owner.tabname?
>
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 02/11/2010 03:02:37 PM:
>
> > [image removed]
> >
> > Update Statistics, with a Table Named Distribu.... [19027]> >
> > Clifton Bean
> >
> > to:
> >
> > ids
> >
> > 02/11/2010 03:03 PM
> >
> > Sent by:
> >
> > ids-bounces@iiug.org
> >
> > Please respond to ids
> >
> > IDS 11.50.FC5 AIX 5.3
> >
> > I am attempting to establish resolution and confidence factors for tables
>
> > within a particular database; however, there is a table named
> > "distributiions"
> > within this database and it is too ingrained within the code to
> > change at this
> > time. This table name generates a syntax error when trying to use this
> table
> > name in an UPDATE STATISTICS command.
> >
> > Any ideas on how I can specify this tablename within the Update
> Statistics
> > SQL?
> >
> > Thanks in advance.
> >
> > Clifton
> >
> > _________________________________________________________________
> > Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
> > http://clk.atdmt.com/GBL/go/201469226/direct/01/
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
I bet you say that to all the girls! :o)
--
Cheers,
Obnoxio The Clown
http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
I am sure John had something very illuminating to say; we just aren't on the
same level as he and need someone to translate it into common everyday
language.
:)
Clifton
> To: ids@iiug.org
> From: obnoxio@serendipita.com
> Subject: Re: Update Statistics, with a Table Named Dist.... [19031]
> Date: Thu, 11 Feb 2010 18:22:36 -0500
>
> John Miller iii wrote:
> >
Did you try using the fully qualified table name, or at least
owner.tabname?
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 02/11/2010 03:02:37 PM:
> [image removed]
>
> Update Statistics, with a Table Named Distribu.... [19027]>
> Clifton Bean
>
> to:
>
> ids
>
> 02/11/2010 03:03 PM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> IDS 11.50.FC5 AIX 5.3
>
> I am attempting to establish resolution and confidence factors for tables
> within a particular database; however, there is a table named
> "distributiions"
> within this database and it is too ingrained within the code to
> change at this
> time. This table name generates a syntax error when trying to use this
table
> name in an UPDATE STATISTICS command.
>
> Any ideas on how I can specify this tablename within the Update
Statistics
> SQL?
>
> Thanks in advance.
>
> Clifton
>
> _________________________________________________________________
> Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
> http://clk.atdmt.com/GBL/go/201469226/direct/01/
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> I bet you say that to all the girls! :o)
>
> --
> Cheers,
> Obnoxio The Clown
>
> http://obotheclown.blogspot.com
> I will now proceed to pleasure myself with this fish.
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Hotmail: Trusted email with Microsofts powerful SPAM protection.
http://clk.atdmt.com/GBL/go/201469226/direct/01/
Clifton Bean wrote: > I am sure John had something very illuminating to say; we just aren't on the > same level as he and need someone to translate it into common everyday > language. I think it's more likely that he's just using Bloatus Goats. :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
You can set DELIMIDENT and quote the tablename. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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, Feb 11, 2010 at 6:02 PM, Clifton Bean <clifton_bean@hotmail.com>wrote: > IDS 11.50.FC5 AIX 5.3 > > I am attempting to establish resolution and confidence factors for tables > within a particular database; however, there is a table named > "distributiions" > within this database and it is too ingrained within the code to change at > this > time. This table name generates a syntax error when trying to use this > table > name in an UPDATE STATISTICS command. > > Any ideas on how I can specify this tablename within the Update Statistics > SQL? > > Thanks in advance. > > Clifton > > _________________________________________________________________ > Hotmail: Trusted email with Microsofts powerful SPAM protection. > http://clk.atdmt.com/GBL/go/201469226/direct/01/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151744898c0f907f047f5c1dcd
________________________________ From: Art Kagel <art.kagel@gmail.com> To: ids@iiug.org Sent: Fri, 12 February, 2010 11:11:51 AM Subject: Re: Update Statistics, with a Table Named Dist.... [19035] You can set DELIMIDENT and quote the tablename. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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, Feb 11, 2010 at 6:02 PM, Clifton Bean <clifton_bean@hotmail.com>wrote: > IDS 11.50.FC5 AIX 5.3 > > I am attempting to establish resolution and confidence factors for tables > within a particular database; however, there is a table named > "distributiions" > within this database and it is too ingrained within the code to change at > this > time. This table name generates a syntax error when trying to use this > table > name in an UPDATE STATISTICS command. > > Any ideas on how I can specify this tablename within the Update Statistics > SQL? > > Thanks in advance. > > Clifton > > _________________________________________________________________ > Hotmail: Trusted email with Microsofts powerful SPAM protection. > http://clk.atdmt.com/GBL/go/201469226/direct/01/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151744898c0f907f047f5c1dcd ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Perhaps if anyone still has "SETI at home" running on their computer you could
crunch the data.....
Bob
----- Original Message -----
From: "Clifton Bean" <clifton_bean@hotmail.com>
To: ids@iiug.org
Sent: Thursday, February 11, 2010 6:53:48 PM GMT -05:00 US/Canada Eastern
Subject: RE: Update Statistics, with a Table Named Dist.... [19033]
I am sure John had something very illuminating to say; we just aren't on the
same level as he and need someone to translate it into common everyday
language.
:)
Clifton
> To: ids@iiug.org
> From: obnoxio@serendipita.com
> Subject: Re: Update Statistics, with a Table Named Dist.... [19031]
> Date: Thu, 11 Feb 2010 18:22:36 -0500
>
> John Miller iii wrote:
> >
Did you try using the fully qualified table name, or at least
owner.tabname?
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 02/11/2010 03:02:37 PM:
> [image removed]
>
> Update Statistics, with a Table Named Distribu.... [19027]>
> Clifton Bean
>
> to:
>
> ids
>
> 02/11/2010 03:03 PM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> IDS 11.50.FC5 AIX 5.3
>
> I am attempting to establish resolution and confidence factors for tables
> within a particular database; however, there is a table named
> "distributiions"
> within this database and it is too ingrained within the code to
> change at this
> time. This table name generates a syntax error when trying to use this
table
> name in an UPDATE STATISTICS command.
>
> Any ideas on how I can specify this tablename within the Update
Statistics
> SQL?
>
> Thanks in advance.
>
> Clifton
>
> _________________________________________________________________
> Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
> http://clk.atdmt.com/GBL/go/201469226/direct/01/
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> I bet you say that to all the girls! :o)
>
> --
> Cheers,
> Obnoxio The Clown
>
> http://obotheclown.blogspot.com
> I will now proceed to pleasure myself with this fish.
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>
>
*******************************************************************************
It works.
update statistics for table informix.distributions
Statistics updated.
Frank
On Thu, Feb 11, 2010 at 7:11 PM, Art Kagel <art.kagel@gmail.com> wrote:
> You can set DELIMIDENT and quote the tablename.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Advanced DataTools, 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, Feb 11, 2010 at 6:02 PM, Clifton Bean <clifton_bean@hotmail.com
> >wrote:
>
> > IDS 11.50.FC5 AIX 5.3
> >
> > I am attempting to establish resolution and confidence factors for tables
> > within a particular database; however, there is a table named
> > "distributiions"
> > within this database and it is too ingrained within the code to change at
> > this
> > time. This table name generates a syntax error when trying to use this
> > table
> > name in an UPDATE STATISTICS command.
> >
> > Any ideas on how I can specify this tablename within the Update
> Statistics
> > SQL?
> >
> > Thanks in advance.
> >
> > Clifton
> >
> > _________________________________________________________________
> > Hotmail: Trusted email with Microsofts powerful SPAM protection.
> > http://clk.atdmt.com/GBL/go/201469226/direct/01/
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00151744898c0f907f047f5c1dcd
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0050450295d95be245047f6bfb43
It's Base64 encoded text - it isn't rocket science to decode it...
John's new text was:
Did you try using the fully qualified table name, or at least
owner.tabname?
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
The rest was a quote of the original message...
On Fri, Feb 12, 2010 at 08:44, rroussey@comcast.net
<rroussey@comcast.net>wrote:
> Perhaps if anyone still has "SETI at home" running on their computer you
> could
> crunch the data.....
>
> Bob
>
> ----- Original Message -----
> From: "Clifton Bean" <clifton_bean@hotmail.com>
> To: ids@iiug.org
> Sent: Thursday, February 11, 2010 6:53:48 PM GMT -05:00 US/Canada Eastern
> Subject: RE: Update Statistics, with a Table Named Dist.... [19033]
>
> I am sure John had something very illuminating to say; we just aren't on
> the
> same level as he and need someone to translate it into common everyday
> language.
>
> :)
>
> Clifton
>
> > To: ids@iiug.org
> > From: obnoxio@serendipita.com
> > Subject: Re: Update Statistics, with a Table Named Dist.... [19031]
> > Date: Thu, 11 Feb 2010 18:22:36 -0500
> >
> > John Miller iii wrote:
>
> Did you try using the fully qualified table name, or at least
> owner.tabname?
>
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 02/11/2010 03:02:37 PM:
>
> > [image removed]
> >
> > Update Statistics, with a Table Named Distribu.... [19027]> >
> > Clifton Bean
> >
> > to:
> >
> > ids
> >
> > 02/11/2010 03:03 PM
> >
> > Sent by:
> >
> > ids-bounces@iiug.org
> >
> > Please respond to ids
> >
> > IDS 11.50.FC5 AIX 5.3
> >
> > I am attempting to establish resolution and confidence factors for tables
>
> > within a particular database; however, there is a table named
> > "distributiions"
> > within this database and it is too ingrained within the code to
> > change at this
> > time. This table name generates a syntax error when trying to use this
> table
> > name in an UPDATE STATISTICS command.
> >
> > Any ideas on how I can specify this tablename within the Update
> Statistics
> > SQL?
> >
> > Thanks in advance.
> >
> > Clifton
> >
> > _________________________________________________________________
> > Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
> > http://clk.atdmt.com/GBL/go/201469226/direct/01/
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
--
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.
Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>;
- "I'm willing to admit that I may not always be right, but I am never
wrong."
--000e0cd1b36e8843f6047f9dcec1