SEO

#1 (**permalink**) 02-27-2008, 03:09 AM

How do I ensure that I always get back 1 row for a query, even if the
table doesn't have any rows? For example, table T1 is empty. I would
always like the data from t1 if it exists.

select c1 from t1

I have tried
(select c1 from t1
union
select 'n/a' from table (values 1) as dummy)
fetch first 1 rows only

but sometimes that gives me the n/a even if there is data in T1.

help,
Eric

#2 (**permalink**) 02-27-2008, 03:09 AM

elubin_nospam wrote:
> How do I ensure that I always get back 1 row for a query, even if the
> table doesn't have any rows? For example, table T1 is empty. I would
> always like the data from t1 if it exists.
>
> select c1 from t1
>
> I have tried
> (select c1 from t1
> union
> select 'n/a' from table (values 1) as dummy)
> fetch first 1 rows only
>
> but sometimes that gives me the n/a even if there is data in T1.
>
> help,
> Eric
>
SELECT T.* FROM SYSIBM.SYSDUMMY1
LEFT OUTER JOIN T
ON 1 = 1;

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

simple select question