Re: SELECT
-----Original Message-----
From: Marvin <ales.romaniuk@zag.si>
Date: Mon, 28 Feb 2000 13:59:48 +0100
To: informix-list@iiug.org
Subject: SELECT
> Hi !
>
> I have two questions regarding SELECT statement.
>
> 1. If I do SELECT statement, I get each fields in a record in
> seperate row:
> MYID 1
> MYNAME Name
>
> MYID 2
> MYNAME Name2
> ...
>
> I would like to get output like:
> MYID MYNAME
> 1 Name
> 2 Name2
> ...
>
> How to change that
Your desired output is the default in dbaccess and isql unless the combined fields lengths exceed your window size (may or may not be adjustable).
>
> 2. I would like to replace field name with something else
> like
> SELECT "Id:"=MYID,"Name:"=MYNAME FROM TABLE (this works in SyBase)
>
> Id Name
> 1 Name
> 2 Name2
>
Select MYID Id, MYNAME Name from table
You'll probably lose the caps on the column names though.
>
>
> Alex
>
--
Get your free email from www.linuxmail.org
<br>
<a href=http://adserver-hk.outblaze.com/cgi-bin/nph-ad1?id=6&c=RANDOM>;
<img src=http://adserver-hk.outblaze.com/cgi-bin/nph-img1?id=6&c=RANDOM
border="0"></a>
<br>