MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Report creation Ezetrieve

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
deepeshk79
Beginner


Joined: 20 Jun 2003
Posts: 112
Topics: 48
Location: Bangalore
PostPosted: Wed Jan 14, 2004 1:48 am    Post subject: Report creation Ezetrieve Reply with quote
Hi All,

I have a requriement as below..which needs to be done thru Ezetrieve..

Code:

File 1
A   AAA BBB  CCC 675 000 125
B   DDD EEE  FFF   778 678 444
C   XXX YYY  ABC  123 444 123
...................
...............................
......................


The file 1 can contain n number of records.

I need to create a report such that it shud have the colums 1,2,3,4 first written with all the records...then the columns 1,5,6,7 written with all the records. A page break shud be inserted in between.

Thus the report shud look like
Code:

HEADING
A   AAA BBB  CCC 
B   DDD EEE  FFF   
C   XXX YYY  ABC   
PAGE BREAK
HEADING
A   675 000 125
B   778 678 444
C   123 444 123


We can achieve this by using two consecutive reads of file1 but can we have arrays in Ezetrieve into which i can store the records the first time i read and then write them at the end in the above format..?? Also i dont know the number of records in file1, then what shud be the size of the array??

Thanks,
Deepesh
Back to top
View user's profile Send private message AIM Address
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Wed Jan 14, 2004 10:10 am    Post subject: Reply with quote
Deepesh,

You can code virtual files to store the intermediate results. But wouldn't it be the same as reading the data twice? First you read the file and store into a temp array and at the end you will again have to read the array to print the results. This process (read+store+read-write) actually is more work when you can simply do it by 2 conscuetive reads of the file.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group