doubt in db2

[supriya]

hi,
pls help me.
1)How to display * using select query?
* *
* * *

[Krishna]

[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.