Re: PIVOT tables

neyoisles@aol.com wrote: :Hi all, :We have some crosstab queries that we had created in access for access :tables. now that we are migrating our tables to informix, we need to have :a way to recreate these crosstab queries using informix tables. I :understand that the PIVOT command (in SQL) is used most often using othere :database servers. Does anybody know if there is a similar command for :Infomix that would allow us to create these PIVOT tables?? We have been :unable to do this so far. There is no pivot table command in the standard Informix engines (sadly so). You have several options though: 1. It may work to connect the tables back into MS Access and do the pivot on them there. 2. If 1. doesn't work you might import the appropriate data into MS Access. Then the pivot will obviously work, but it may be to cumbersom. 3. You may look into the Informix MetaCube products that have all kinds of options to do what you want (and much more than simple pivot). This isn't inexpensive, but very powerfull. 4. You might write an application in Visual Basic or another MS Windows based language. Then you can buy ready made controls that can do the pivot function for you locally. 5. You might write a pivot table function yourself. That isn't easy (if you want a general one at least), but possible. 6. May be there is enough functionality in the new Universal Server to do this, or at least make it simpler. In any case the MetaCube product will be available as a datablade for this server and give you this option. :HELP!! :Thanks to all those that respond!! :Alden Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org