Re: PIVOT tables
Nils Myklebust <Nils.Myklebust@idg.no> wrote in article <58471m$853@nntp.idgonline.no>... > 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 > > If is your "crosstab query" static, you can write SP (we are using this for PB clients). It works fine. You can use some EIS product (Media is very good). I saw an MS EXCEL extension for pivot tables but i cannot remember who is selling it (Excel was connect through the ODBC). -- HTH, Pepa Josef Dufek ISS s.r.o., Benesova 2/4, 602 00 Brno, Czech Republic vondr@issbrno.anet.cz