Re: Manually Adding a Row to a Resultset
Try this:
create table dual(
dummy char(1)
);
insert into dual values ('x');
and the use dual as you normally would in oracle.
for your problem, this could be:
select 'constant'
from dual;
and use it in a join.
if you want to be very fancy don't create that dual table, instead use:
select 'constant'
from table( set{1} )
Of course if you use recent version of IDS.
J.
-----Original Message-----
From: "Potter" <drewpotter@gmail.com>
To: informix-list@iiug.org
Date: 19 Dec 2005 07:32:48 -0800
Subject: Manually Adding a Row to a Resultset
I am querying an Informix database via Sequelink and I want to manually
add a
row to my recordset. In SQL Server, I would use a UNION clause like
this:
SELECT
Field1 as ValueField
,Field2 as DescField
FROM TableA
UNION
SELECT
Null as ValueField
,'All' as DescField
Is there similar syntax for Informix?
Thanks in advance.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@gmail.com
sending to informix-list