Re: Tables of type raw

Madison Pruet wrote: > Mo wrote: >> Is there a way to create a table with type raw on HDR primary? I get >> the following: >> >> >> 19844: Tables of type raw are not allowed in a logged database on an>> HDR primary >> >> server. >> > We are currently trying to make this possible. The problem with a raw > table is that since there is no logging, then there is no way that a > secondary of any kind can maintain the raw table. > I'm shaking! :) Because I understand the problem, and I can't imagine a solution even without having to deal with the technical details... > I have a question however. Why are you using raw tables? Are you > updating them or just loading them? I have a customer (the usual one ;) ) that would like to do this for some operations... Like: - You want to delete a significant part of a table, so sometimes can be more efficient to load the useful rows into a new table and then drop old/change new to standard/rename new to old - You need to create a new table and load data into it... Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...