Re: The FAQ is back!

Apologies for the late reply, FAQ updated. 4.1.20 Will Informix explode in the year 2000? Kept as people may still be using DBCENTURY 5.11 Is there *really* no "Upper" function!? Removed 8.49 How do I set tables memory resident? People may still be running old versions, updated to mention not valid in 10 and above. 8.57 What are the main Informix bugs? Removed Please let us know if you have any updates for the FAQ and any recommendations for a good wiki site. Regards, David. > On 22 April 2014 at 16:09 BENJAMIN THOMPSON <benjamin.thompson@bskyb.com> > wrote: > > > Hi David, > > There are a few gems in there that are still relevant but the FAQ looks to be > 15+ years out of date now and is beyond simple updating. Some examples: > > 4.1.20 Will Informix explode in the year 2000? > > :-D > > 5.11 Is there *really* no "Upper" function!? > > I can't actually remember when there wasn't and I started with Informix in > 1999. > > 8.49 How do I set tables memory resident? > > I didn't know about this feature but when I checked the docs just now it last > worked in version 9.40. > > 8.57 What are the main Informix bugs? > > These are ancient! I also question whether the ones listed were ever the > "main" bugs at any point in time since I knew of some worse ones :) > > I spotted some other suspect stuff, scripts where multiple page sizes are not > taken into account and so on, which would require more effort for me to check. > > I don't wish to be negative but everything in there needs a review at least. > Wouldn't it be better for a FAQ to be in the form of a Wiki if it's to be a > community based effort and maybe started again from scratch? > > Ben. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

memory resident tables were only supported in v7.30 (though the command was still supported but no-op until v11.10). Art Art S. Kagel, Principal Consultant ASK Database Management 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 Wed, Aug 27, 2014 at 6:03 PM, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > Apologies for the late reply, FAQ updated. > > 4.1.20 Will Informix explode in the year 2000? > Kept as people may still be using DBCENTURY > > 5.11 Is there *really* no "Upper" function!? > > Removed > > 8.49 How do I set tables memory resident? > People may still be running old versions, updated to mention not valid in > 10 > and > above. > > 8.57 What are the main Informix bugs? > > Removed > > Please let us know if you have any updates for the FAQ and any > recommendations > for a good wiki site. > > Regards, > David. > > > On 22 April 2014 at 16:09 BENJAMIN THOMPSON <benjamin.thompson@bskyb.com > > > > wrote: > > > > > > Hi David, > > > > There are a few gems in there that are still relevant but the FAQ looks > to > be > > 15+ years out of date now and is beyond simple updating. Some examples: > > > > 4.1.20 Will Informix explode in the year 2000? > > > > :-D > > > > 5.11 Is there *really* no "Upper" function!? > > > > I can't actually remember when there wasn't and I started with Informix > in > > 1999. > > > > 8.49 How do I set tables memory resident? > > > > I didn't know about this feature but when I checked the docs just now it > last > > worked in version 9.40. > > > > 8.57 What are the main Informix bugs? > > > > These are ancient! I also question whether the ones listed were ever the > > "main" bugs at any point in time since I knew of some worse ones :) > > > > I spotted some other suspect stuff, scripts where multiple page sizes are > not > > taken into account and so on, which would require more effort for me to > check. > > > > I don't wish to be negative but everything in there needs a review at > least. > > Wouldn't it be better for a FAQ to be in the form of a Wiki if it's to > be a > > community based effort and maybe started again from scratch? > > > > Ben. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158c200f2726c0501a40cf0

Art, FAQ updated and you have add to the list of credits! Regards, David. > On 27 August 2014 at 23:36 Art Kagel <art.kagel@gmail.com> wrote: > > > memory resident tables were only supported in v7.30 (though the command was > still supported but no-op until v11.10). > > Art > > Art S. Kagel, Principal Consultant > ASK Database Management > > 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 Wed, Aug 27, 2014 at 6:03 PM, david@smooth1.co.uk <david@smooth1.co.uk> > wrote: > > > Apologies for the late reply, FAQ updated. > > > > 4.1.20 Will Informix explode in the year 2000? > > Kept as people may still be using DBCENTURY > > > > 5.11 Is there *really* no "Upper" function!? > > > > Removed > > > > 8.49 How do I set tables memory resident? > > People may still be running old versions, updated to mention not valid in > > 10 > > and > > above. > > > > 8.57 What are the main Informix bugs? > > > > Removed > > > > Please let us know if you have any updates for the FAQ and any > > recommendations > > for a good wiki site. > > > > Regards, > > David. > > > > > On 22 April 2014 at 16:09 BENJAMIN THOMPSON <benjamin.thompson@bskyb.com > > > > > > wrote: > > > > > > > > > Hi David, > > > > > > There are a few gems in there that are still relevant but the FAQ looks > > to > > be > > > 15+ years out of date now and is beyond simple updating. Some examples: > > > > > > 4.1.20 Will Informix explode in the year 2000? > > > > > > :-D > > > > > > 5.11 Is there *really* no "Upper" function!? > > > > > > I can't actually remember when there wasn't and I started with Informix > > in > > > 1999. > > > > > > 8.49 How do I set tables memory resident? > > > > > > I didn't know about this feature but when I checked the docs just now it > > last > > > worked in version 9.40. > > > > > > 8.57 What are the main Informix bugs? > > > > > > These are ancient! I also question whether the ones listed were ever the > > > "main" bugs at any point in time since I knew of some worse ones :) > > > > > > I spotted some other suspect stuff, scripts where multiple page sizes are > > not > > > taken into account and so on, which would require more effort for me to > > check. > > > > > > I don't wish to be negative but everything in there needs a review at > > least. > > > Wouldn't it be better for a FAQ to be in the form of a Wiki if it's to > > be a > > > community based effort and maybe started again from scratch? > > > > > > Ben. > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e0158c200f2726c0501a40cf0 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >