View previous topic :: View next topic
|
Author |
Message |
bnrinbox
New User
Joined: 15 Feb 2005 Posts: 4
|
|
|
|
Hi,
without any HLL support, is it be possible to print the following series. Assume only 3 lines.
Thanks |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
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 |
|
|
bnrinbox
New User
Joined: 15 Feb 2005 Posts: 4
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10889 Location: italy
|
|
|
|
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 |
|
|
bnrinbox
New User
Joined: 15 Feb 2005 Posts: 4
|
|
|
|
Yes, the same one. As it is.... asked. |
|
Back to top |
|
|
|