db2 doubt

supriya · Member Joined: 27 Sep 2006 Posts: 7

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

Krishna · Site Admin Joined: 27 Jan 2006 Posts: 929

Please check the answer in

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

It will help you to get desired result.

Thanks,
Krishna

ovreddy · Member Joined: 07 Oct 2006 Posts: 14 Location: Chennai

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.

Topics		Replies	Author	Views	Last Post
Related topics
	how to display panel through batch	1	Chanti	957	Tue Aug 04, 2009 1:05 am MrSpock
	for debugging , i need to display variables in hexadecimal	6	danig	2433	Thu Apr 17, 2008 1:34 pm danig
	use of display	3	neeraja	1743	Sat Feb 16, 2008 4:50 am DavidatK
	How to display in SYSOUT?	4	arrbee	3399	Fri Jun 15, 2007 12:59 pm arrbee
	How to Display COMP-3 value in report	1	Rithu	5145	Mon Feb 12, 2007 6:30 am dbzTHEdinosauer

	mainframegurukul.com Forum Index -> DB2 SQL - DB2 PROGRAMMING	All times are GMT + 5 Hours
Page 1 of 1