Re: Column Names Returned from a View

Larry Kemmerling wrote: > > This is a follow up to my original posting. Thanks to everyone that > has offered help. > > I created a simple view: > > CREATE VIEW test > ( C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13,C14,C15,C16, > C17,C18,C19,C20,C21,C22,C23,C24,C25,C26,C27,C28,C29,C30, > C31,C32,C33,C34,C35,C36,C37,C38,C39,C40,C41,C42,C43,C44, > C45,C46,C47,C48,C49,C50,C51,C52,C53,C54,C55,C56,C57,C58, > C59,C60,C61,C62,C63,C64,C65,C66,C67,C68,C69,C70,C71,C72, > C73,C74,C75,C76 ) AS > SELECT '1','2','3','4','5','6','7','8','9','10','11','12','13', > '14','15','16','17','18','19','20','21','22','23','24', > '25','26','27','28','29','30','31','32','33','34','35', > '36','37','38','39','40','41','42','43','44','45','46', > '47','48','49','50','51','52','53','54','55','56','57', > '58','59','60','61','62','63','64','65','66','67','68', > '69','70','71','72','73','74','75','76' > FROM SysTables > WHERE TabId = 99;> > I can create this view without a problem and selecting from it works > as I would expect. However, if I alter "CREATE VIEW test" to > "CREATE VIEW t292", the view created has the same problem I reported > in my first posting. Namely, I'm seeing one of the column identifiers > being returned incorrectly. > > Since the system only seems to have a problem with the view when it is > named t292, I'm led to believe that there is some reference to the original > table that wasn't deleted from the information tables when I originally > dropped (the table) t292. Note that I did not encounter any errors when > I dropped t292. I can use a different name for the view, but I'd still > like to know why this view won't function properly unless I name it some- > thing other than t292. > > Any ideas? BING! This now rings a bell. One of our tech support guys here had a similar case, also on SUN. The problem unfortunately went away on it's own. All they did was play with the data dictionary cache size. Try adding the following lines to your onconfig file: DD_HASHSIZE 211 DD_HASHMAX 45 Please let me know if this solves it. Thanks, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+