mainframegurukul.com

1) How to display
*
* *
* * *
using select query?

Please check the answer in

http://www.ibmmainframeguru.com/Mainfra ... php?t=1144

It will help you to get desired result.



Thanks,
Krishna

Hi Krishna,

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.