Re: Need help hot to distinguish btw 2 members

I might add a new section between TRANSACTIONS and POSITIONS that would add
a record to the file as a footer for Transactions and add a second record as
a header for POSITIONS. Maybe the easiest way would be to create a 2-record
file with your footer & header, the do a runqry against it? 
 
The new section would be a clone of the other two RUNQRYs, but query your
new 2-record file.
 
Is that clear? Or did I confuse things?
 
 
---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Wednesday, September 24, 2003 10:56:47 PM
To: Midrange Systems Technical Discussion
Subject: Need help hot to distinguish btw 2 members
 
hi all,
below is my cl program,iam generating spool file for user sake in
third query.my program is working fine and generating correct
report.
my problem is ,is there anyway i can distiguish between
TRANSACTIONS and POSITIONS in the final report.since iam adding
POSITIONS to the TRANSACTIONS ,user is unable to find where
exactly POSITIONS starts in the final report (ysusprep).Below is
the final report.Please try to help me how do i distinuish btw
these TRANSACTION &POSITIONS..can anybody help?
------------------------------------------------------------------------
PGM
/* FOR TRANSACTIONS */
RUNQRY QRY(YNGTEST/YSUSPQRY1) +
QRYFILE((QS36FSUR/GMICMFF1) +
(QS36FSUR/GMITRNF1)) OUTTYPE(*OUTFILE)
+
OUTFILE(YNGTEST/YSUSPREP *FIRST
*RPLMBR)
/* FOR POSITIONS */
RUNQRY QRY(YNGTEST/YSUSPQRY2) +
QRYFILE((QS36FSUR/GMICMFF1) +
(QS36FSUR/GMIPOSF1)) OUTTYPE(*OUTFILE)
+
OUTFILE(YNGTEST/YSUSPREP *FIRST
*ADDMBR)
RUNQRY QRY(YNGTEST/YSUSPQRY3)
ENDPGM
------------------------------------------------------------------------
 
------------------------- YSUSPREP-----------------------
ACCOUNT DESC EXCH DATE
69999999 DEC 03 TSE 10 YR JGB 24 20,030,918
69999999 DEC 03 TSE TOPIX 24 20,030,918
69999999 DEC 03 TSE TOPIX 24 20,030,918
69999999 DEC 03 TSE TOPIX 24 20,030,918
69999999 DEC 03 TSE TOPIX 24 20,030,918
69999999 DEC 03 TSE TOPIX 24 20,030,918