Page 1 of 1

doubt in db2

Posted: Wed Sep 27, 2006 12:56 pm
by supriya
hi,
pls help me.
1)How to display * using select query?
* *
* * *

sql query

Posted: Wed Sep 27, 2006 3:32 pm
by Krishna

Code: Select all

Select '*' from SYSIBM.SYSDUMMY1

or

Select CHAR('*')  from SYSIBM.SYSDUMMY1


Thanks,
Krishna

Posted: Sat Oct 07, 2006 4:26 pm
by ovreddy
Hi Supriya,

Please refer to the following syntax to get the result.

SELECT '*' FROM SYSIBM.SYSDUMMY1
UNION
SELECT '**' FROM SYSIBM.SYSDUMMY1
UNION
SELECT '***' FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------+---------+---------+

---------+---------+---------+---------+---------+---------+---------+---------+
*
**
***
DSNE610I NUMBER OF ROWS DISPLAYED IS 3

Hope you got what you want.

Thanks,
Reddy.