RE: FROM TABLE(MULTISET( In HDR

Please, run this statement first on Primary. Then, it will work on Secondary. This might sound crazy.. Per my request, this 'feature' description was added to 'release notes'. The problem is that for each new type (even created 'on the fly'), like this MULTISET, Informix need to make an insert into several system tables (like SYSXTDTYPES, etc). This insert is impossible on Secondary. When you run the statement on Primary, it creates a new type description in SYSTABLES, and propagates this description to Secondary. Then. it works on Secondary. Enjoy! -Alexey > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] > On Behalf Of Tam OShanter > Sent: Tuesday, July 25, 2006 11:01 AM > To: informix-list@iiug.org > Subject: FROM TABLE(MULTISET( In HDR > > Hello Group, > > Question regarding executing a statement like the following: > > SELECT ... FROM TABLE(MULTISET(SELECT What, You, Wanted FROM WhereEver))> > It does not seem to work on a read-only server participating in HDR. Flavor > is 10.0 UC4 > > > Wondering the following: > > Why does it not work, read only I get, but this is creating an in memory > construct and isn't physically creating anything? > > Isn't using a statement like this going to be more efficient than creating a > temp table as in memory operations are going to be faster than writing to a > physical device (a la temp tables...)? > > Is there a configuration setting or workaround that will allow me to use the > TABLE(MULTISET( statements on my read only server? > > > As always, thanks in advance for your time and kind assistance. > > > Tam. > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

Thanks for the help friends worked great. Tam. "Alexey Sonkin" <alexeys@cidc.com> wrote in message news:mailman.73.1153862140.20706.informix-list@iiug.org... Please, run this statement first on Primary. Then, it will work on Secondary. This might sound crazy.. Per my request, this 'feature' description was added to 'release notes'. The problem is that for each new type (even created 'on the fly'), like this MULTISET, Informix need to make an insert into several system tables (like SYSXTDTYPES, etc). This insert is impossible on Secondary. When you run the statement on Primary, it creates a new type description in SYSTABLES, and propagates this description to Secondary. Then. it works on Secondary. Enjoy! -Alexey > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] > On Behalf Of Tam OShanter > Sent: Tuesday, July 25, 2006 11:01 AM > To: informix-list@iiug.org > Subject: FROM TABLE(MULTISET( In HDR > > Hello Group, > > Question regarding executing a statement like the following: > > SELECT ... FROM TABLE(MULTISET(SELECT What, You, Wanted FROM WhereEver))> > It does not seem to work on a read-only server participating in HDR. Flavor > is 10.0 UC4 > > > Wondering the following: > > Why does it not work, read only I get, but this is creating an in memory > construct and isn't physically creating anything? > > Isn't using a statement like this going to be more efficient than creating a > temp table as in memory operations are going to be faster than writing to a > physical device (a la temp tables...)? > > Is there a configuration setting or workaround that will allow me to use the > TABLE(MULTISET( statements on my read only server? > > > As always, thanks in advance for your time and kind assistance. > > > Tam. > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list