String literal result set


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: String literal result set

Hybrid View

  1. #1
    Hector Diaz Guest

    String literal result set


    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.

  2. #2
    Greg Nash Guest

    Re: String literal result set

    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.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center