pivot / unpivot relational operator in informix

Posted in 2010

Ashutosh Khunte — Thu, 21 Jan 2010 18:01:59 — source: IIUG Forums & Mailing Lists

Does Informix SQL offers this feature? I know that I can use Informix DW studio to do this. But I was looking for a more direct statement bulit in the engine itself.

↪ replying to Ashutosh Khunte

Obnoxio The — Thu, 21 Jan 2010 18:05:00 — source: IIUG Forums & Mailing Lists

Ashutosh Khunte wrote: > Does Informix SQL offers this feature? > I know that I can use Informix DW studio to do this. But I was looking for a > more direct statement bulit in the engine itself. Don't hold your breath. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Ashutosh Khunte

Art Kagel — Thu, 21 Jan 2010 18:09:22 — source: IIUG Forums & Mailing Lists

Pivot as in make the columns into rows and vice-versa? That's not a relational operation, and anyway not supported by Informix in the engine. You could write a stored procedure or UDR to do it for you, however. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 21, 2010 at 1:01 PM, Ashutosh Khunte <akhunte@yahoo.com> wrote: > Does Informix SQL offers this feature? > I know that I can use Informix DW studio to do this. But I was looking for > a > more direct statement bulit in the engine itself. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00032555bc660e03a9047db09aff

↪ replying to Art Kagel

Ashutosh — Thu, 21 Jan 2010 19:00:57 — source: IIUG Forums & Mailing Lists

I know that I can write SPL or 4GL program. it is a relational operator supported in SQL Server and can be used as a part of Select statment. --- On Thu, 1/21/10, Art Kagel <art.kagel@gmail.com> wrote: From: Art Kagel <art.kagel@gmail.com> Subject: Re: pivot / unpivot relational operator in inf.... [18734] To: ids@iiug.org Date: Thursday, January 21, 2010, 10:09 AM Pivot as in make the columns into rows and vice-versa? That's not a relational operation, and anyway not supported by Informix in the engine. You could write a stored procedure or UDR to do it for you, however. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 21, 2010 at 1:01 PM, Ashutosh Khunte <akhunte@yahoo.com> wrote: > Does Informix SQL offers this feature? > I know that I can use Informix DW studio to do this. But I was looking for > a > more direct statement bulit in the engine itself. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00032555bc660e03a9047db09aff ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Ashutosh

Art Kagel — Thu, 21 Jan 2010 19:16:28 — source: IIUG Forums & Mailing Lists

OK. Pivot is an MS SQL Server extension to the language. It is not standard ANSI SQL and not supported in IDS. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 21, 2010 at 2:00 PM, Ashutosh Khunte <akhunte@yahoo.com> wrote: > I know that I can write SPL or 4GL program. > it is a relational operator supported in SQL Server and can be used as a > part > of Select statment. > > --- On Thu, 1/21/10, Art Kagel <art.kagel@gmail.com> wrote: > > From: Art Kagel <art.kagel@gmail.com> > Subject: Re: pivot / unpivot relational operator in inf.... [18734] > To: ids@iiug.org > Date: Thursday, January 21, 2010, 10:09 AM > > Pivot as in make the columns into rows and vice-versa? That's not a > relational operation, and anyway not supported by Informix in the engine. > You could write a stored procedure or UDR to do it for you, however. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Thu, Jan 21, 2010 at 1:01 PM, Ashutosh Khunte <akhunte@yahoo.com> > wrote: > > > Does Informix SQL offers this feature? > > I know that I can use Informix DW studio to do this. But I was looking > for > > a > > more direct statement bulit in the engine itself. > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --00032555bc660e03a9047db09aff > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747beaaf60af6047db189f7