Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
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    Post subject: By using DB2 alone (No Language Support), can we print.
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: 686
Location: Earth

PostPosted: Tue Jun 29, 2010 8:16 am    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Thu Jul 01, 2010 10:35 am    Post subject: Reply to: By using DB2 alone (No Language Support), can we p
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Why TS/OP would Not contact site supp... RahulG31 All Other Mainframe Topics 2 Wed Mar 22, 2017 7:46 am
No new posts Need Help in understanding what is th... mainakdalal PL/I & Assembler 9 Mon Oct 03, 2016 8:03 pm
No new posts Any body aware of CAP-COBOL language? Sachin Raghuwanshi COBOL Programming 4 Tue Aug 02, 2016 9:34 am
No new posts ISPF 3.4, SF line command does not su... Pedro TSO/ISPF 0 Fri Jan 15, 2016 11:09 pm
No new posts print out the correct info in LOOP? jackzhang75 CLIST & REXX 7 Wed Dec 23, 2015 10:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us