IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

By using DB2 alone (No Language Support), can we print.


IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bnrinbox

New User


Joined: 15 Feb 2005
Posts: 4

PostPosted: Tue Jun 29, 2010 7:02 am
Reply with quote

Hi,

without any HLL support, is it be possible to print the following series. Assume only 3 lines.

Code:
   *
  * *
 * * *

Thanks
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Tue Jun 29, 2010 8:16 am
Reply with quote

I don't think this serves any business purpose but try this-
Code:
SELECT '*' FROM SYSIBM.SYSDUMMY1
UNION
SELECT '**' FROM SYSIBM.SYSDUMMY1

I think you got the hint..
Back to top
View user's profile Send private message
bnrinbox

New User


Joined: 15 Feb 2005
Posts: 4

PostPosted: Thu Jul 01, 2010 7:36 am
Reply with quote

My apologies for late reply.

And the query is also not clear to many.

I have only 1 table. Number of columns not specified. No HLL support.
And the result should be as below. Where 'B' stands for Blank.
BBB*BBB
BB*B*BB
B*B*B*B

Thanks,
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jul 01, 2010 10:35 am
Reply with quote

if You had used the code tags, You would have gotten a slightly different reply!

why not use a tiny tiny bit of imagination and experiment with the sample query You got ???
Back to top
View user's profile Send private message
bnrinbox

New User


Joined: 15 Feb 2005
Posts: 4

PostPosted: Sun Jul 04, 2010 12:03 pm
Reply with quote

Yes, the same one. As it is.... asked.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> HomeWorks & Requests

 


Similar Topics
Topic Forum Replies
No new posts APL support TSO/ISPF 1
No new posts JCL sortcard to print only the records DFSORT/ICETOOL 11
No new posts CICS V 5.6 provides support for COMMA... CICS 4
No new posts After hours quick-fix support for IBM... Mainframe Jobs 0
No new posts is there a way to print time in HH:MM... SYNCSORT 12
Search our Forums:

Back to Top