String literal result set

[Hector Diaz]

Hopefully this is the right place to ask this question.

I want to return a result set that has nothing to do with tables.
In other DBMS's I can run the following select clause:

select 'a','b'

and get the following result set

1 2
-- --
a b


Is there a way to do something similar in UDB. I tried the above and it
does not work.

Can you email me if you have the answer? Thanks in advance.

[Greg Nash]

Hi,
Use

VALUES ('a','b')

or, in older versions, use

SELECT ('a','b') from sysibm.sysdummy1

--Greg
Hector Diaz wrote:

> Hopefully this is the right place to ask this question.
>
> I want to return a result set that has nothing to do with tables.
> In other DBMS's I can run the following select clause:
>
> select 'a','b'
>
> and get the following result set
>
> 1 2
> -- --
> a b
>
> Is there a way to do something similar in UDB. I tried the above and it
> does not work.
>
> Can you email me if you have the answer? Thanks in advance.