Oninit cdi / Archive
Talk to an expert →

select table from table ??

Posted in 2008

Topics: Platform-Specific Issues

Jean Sagi — — source: IIUG Forums & Mailing Lists

Hi All, Just by pure chance I did something like: select table -- the first column is the name of the table from table ; and it works... It returned something like a row-type representation of each row. It looks interesting. Anyone knows where is this documented? (I'd like to read about it - quick look at documentation don't reveal much...). Also, char column are padded with blanks to a string of its length... why? IDS 11.50 xC2 (HP-UX and Windows) J.

↪ replying to Jean Sagi
Fernando Nunes — — source: IIUG Forums & Mailing Lists

I think it's here: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids _sqs_0993.htm It's considered a row type expression... Regards. On Fri, Nov 28, 2008 at 5:01 PM, Jean Sagi <jeansagi.ifx@gmail.com> wrote: > Hi All, > Just by pure chance I did something like: > > select table -- the first column is the name of the table > from table > ; > > and it works... > > It returned something like a row-type representation of each row. > It looks interesting. > > Anyone knows where is this documented? (I'd like to read about it - quick > look at documentation don't reveal much...). > Also, char column are padded with blanks to a string of its length... why? > > IDS 11.50 xC2 (HP-UX and Windows) > > J. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

↪ replying to Fernando Nunes
Jean Sagi — — source: IIUG Forums & Mailing Lists

Yep it's covered under row types. A table name evaluate to a row type if in the projection clause. Thanks. J. 2008/11/28 Fernando Nunes <domusonline@gmail.com> > I think it's here: > > > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids _sqs_0993.htm > > It's considered a row type expression... > Regards. > > On Fri, Nov 28, 2008 at 5:01 PM, Jean Sagi <jeansagi.ifx@gmail.com> wrote: > > > Hi All, > > Just by pure chance I did something like: > > > > select table -- the first column is the name of the table > > from table > > ; > > > > and it works... > > > > It returned something like a row-type representation of each row. > > It looks interesting. > > > > Anyone knows where is this documented? (I'd like to read about it - quick > > look at documentation don't reveal much...). > > Also, char column are padded with blanks to a string of its length... > why? > > > > IDS 11.50 xC2 (HP-UX and Windows) > > > > J. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >