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
 

 

eazytrieve program ( to add a new column and sort )

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
bujji

New User


Joined: 12 Dec 2005
Posts: 3

PostPosted: Mon Dec 26, 2005 6:12 pm    Post subject: eazytrieve program ( to add a new column and sort )
Reply with quote

Hi Friends,

I m new to eazytrieve.

Pls look over the following report.

names place ........

aaaa xxxxx
bbbb yyyyy
cccc zzzzzz
dddd ppppp

I Have to modify the above report like this.
a) I have to add a new column class
b) Based on the class and names i have to sort and print the report. and
class name has to print only once. corresponding to that class , all
names have to be displayed.

class names place..........

FIRST aaaa xxxxx
ccccc zzzzzz
second bbbb yyyyy
dddd ppppp


If any one can help , please send the modifications to do it.

Thanks in advance,
Bujji.
Back to top
View user's profile Send private message

bujji

New User


Joined: 12 Dec 2005
Posts: 3

PostPosted: Mon Dec 26, 2005 6:30 pm    Post subject:
Reply with quote

the above reports are not clear


first report.
Name Place
Aaaa Hyd
Bbbb Secun
Cccc Secun
Dddd kurnool




New report has to look like this.



Class Name place
First Aaaa Hyd
Cccc Secun
Second Bbbb Secun
Dddd kurnool


where in first class aaaa,cccc names exits and
in second class bbbb,dddd names exist.


Regards,
Bujji
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Dec 28, 2005 6:51 pm    Post subject:
Reply with quote

Hi,

u have to change your report statement

REPORT REPORT1 LINESIZE .. +
CONTROL class

u need to add control statement in ur report statment..

* CONTROL - identifies control fields used for a control report. A
control break occurs whenever the value of any control field
changes or end-of-report occurs.

It will be better if you give me ur report statement of ur program so that i can tell u where u need to change

hope it will be helpful
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm


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