MVSFORUMS.com

Jamylady · Beginner Joined: 04 Nov 2004 Posts: 68 Topics: 22

Hi,
Just wondering..would it be possible to split the query result in to multiple rows?
For example
I have the follwoing Query.

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

Jamylady,

Do u have QMF installed in your shop? I guess this is possible thru QMF.
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

Jamylady,

I could not think of a normal SQL solution. Yet I would suggest that this can be done by executing the query via REXX and perform the formatting in REXX itself.
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

mickeygoo · Beginner Joined: 15 Nov 2007 Posts: 26 Topics: 7

You can use DFSORT to reformat the query output:

OUTFIL REMOVECC,
OUTREC=(1,17,/,
17X,18,10,/,
.
.
.

Position and length values in the above are guestimates Very Happy

Basically, print each field (or field combination) in one line, add a carriage return (the "/") in between each field, and padded spaces (the 17x) to indent the 2nd line onward.
_________________
Not an expert, but I did stay at a Holiday Inn... though it has been a while...