How to get rid of MULTISET in DB queries.

Posted in 2010

meenu sharma — Thu, 17 Jun 2010 11:55:33 — source: IIUG Forums & Mailing Lists

Hi, I have a requirement to remove MULTISET from the SQL queries. Please suggest some alternative ways in which I can implement my queries without MULTISET. Any help will be greatly appreciated. Thanks and Regards, Meenu Thapliyal --00c09f88cdd05650460489386794

↪ replying to meenu sharma

Everett Mills — Thu, 17 Jun 2010 16:50:13 — source: IIUG Forums & Mailing Lists

Meenu- You didn't say what version of Informix you're running. It makes a big difference for your answer. In earlier versions you can create temp tables, later version allow you to use derived tables to replace multiset queries. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > meenu sharma > Sent: Thursday, June 17, 2010 6:56 AM > To: ids@iiug.org > Subject: How to get rid of MULTISET in DB queries. [20410] > > Hi, > > I have a requirement to remove MULTISET from the SQL queries. > > Please suggest some alternative ways in which I can implement my > queries > without MULTISET. > > Any help will be greatly appreciated. > > Thanks and Regards, > Meenu Thapliyal > > --00c09f88cdd05650460489386794 > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.