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
 

 

Problem in Easytrieve report generation

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

New User


Joined: 09 Feb 2011
Posts: 7
Location: Hyderabad

PostPosted: Mon Mar 28, 2011 7:33 pm    Post subject: Problem in Easytrieve report generation
Reply with quote

Hi,

I am trying to generate the report as follows using easytrieve program

Code:



3/28/2011                      S U M M A R Y -                     PAGE      1
                         PROC-IND   TYPE    COUNT
                       ----------   ------  ---------- 
                     FILIN-CRDT   FILIN-PROG     TALLY
                     DTCY/CCAN                         5
                     DTCY/CCAN                         5
                     DTCY/DLVA                        16
                     DTCY/DLVA                        16
                                                              21


But i am getting as follows

Code:


3/28/2011                      S U M M A R Y -                     PAGE      1
                          PROC-IND   TYPE    COUNT

                     FILIN-CRDT   FILIN-PROG     TALLY
                     DTCY/CCAN                         5
                     DTCY/CCAN                         5
                     DTCY/DLVA                        16
                     DTCY/DLVA                        16
                                                              21



I want to insert a extra lines(Like : ---------- ----- ------- ) between title and heading
Title --> PROC-IND TYPE COUNT

Heading--> FILIN-CRDT FILIN-PROG TALLY

Code as follows:

Code:


TITLE 01 'S U M M A R Y - '
TITLE 02 'PROC-IND   TYPE    COUNT '
HEADING  FILIN-CRDT ('FILIN-CRDT')
HEADING  FILIN-PROG ('PROG')
HEADING  TALLY      ('TALLY')
LINE 01  FILIN-CRDT FILIN-PROG  TALLY

Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Mar 28, 2011 7:54 pm    Post subject:
Reply with quote

EASYTRIEVE is a CA product.
Please learn to post in the correct forum.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Mon Mar 28, 2011 10:00 pm    Post subject:
Reply with quote

How about this (and RTFM) :

TITLE 03 '---------- ------ ----------'

And change this :

Never give up until you try and succeed:-)

into

Never give give up, till other people do your work.
Back to top
View user's profile Send private message
Prem.y

New User


Joined: 09 Feb 2011
Posts: 7
Location: Hyderabad

PostPosted: Tue Mar 29, 2011 12:41 pm    Post subject:
Reply with quote

Thanks Peter icon_smile.gif

Now My requirement is changed. Expecting to be as follows

Code:

 
3/28/2011                      S U M M A R Y -                     PAGE      1
                         PROC-IND   TYPE    COUNT
                         
                     FILIN-CRDT   FILIN-PROG     TALLY
                    ----------    ---------     ----------
                     DTCY/CCAN                         5
                     DTCY/CCAN                         5
                     DTCY/DLVA                        16
                     DTCY/DLVA                        16
                                                              21



Expecting the lines ( --------- ------- ---------- ) after heading

I tried but not able to get the expected one.do needul.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue Mar 29, 2011 1:35 pm    Post subject:
Reply with quote

As far as i see it nothing changed in your requirement (your 1st post)
So you say the following is not working ? :

Code:

TITLE 01 'S U M M A R Y - '
TITLE 02 'PROC-IND   TYPE    COUNT '
TITLE 03 '---------- ------ ----------'
HEADING  FILIN-CRDT ('FILIN-CRDT')
HEADING  FILIN-PROG ('PROG')
HEADING  TALLY      ('TALLY')
LINE 01  FILIN-CRDT FILIN-PROG  TALLY


And maybe you show your whole REPORT statement?
Back to top
View user's profile Send private message
Prem.y

New User


Joined: 09 Feb 2011
Posts: 7
Location: Hyderabad

PostPosted: Tue Mar 29, 2011 1:59 pm    Post subject:
Reply with quote

The above code which you pasted is working fine and lines will be displayed in the report after Title 02 ( i.e after 'PROC-IND TYPE COUNT ) , but here my requirement is I want the lines to be displayed in the report after Heading(i.e after FILIN-CRDT FILIN-PROG TALLY
) as

Code:

TITLE 01 'S U M M A R Y - '
TITLE 02 'PROC-IND   TYPE    COUNT '
HEADING  FILIN-CRDT ('FILIN-CRDT')
HEADING  FILIN-PROG ('PROG')
HEADING  TALLY      ('TALLY')
TITLE 03 '---------- ------ ----------'
LINE 01  FILIN-CRDT FILIN-PROG  TALLY


When i put TITLE 03 after heading then Job ending with Maxcc=16

The report should look like:
Code:

3/28/2011                      S U M M A R Y -                     PAGE      1
                         PROC-IND   TYPE    COUNT
                         
                     FILIN-CRDT   FILIN-PROG     TALLY
                    ----------    ---------     ----------
                     DTCY/CCAN                         5
                     DTCY/CCAN                         5
                     DTCY/DLVA                        16
                     DTCY/DLVA                        16
                                                              21


and not like:
Code:


3/28/2011                      S U M M A R Y -                     PAGE      1
                         PROC-IND   TYPE    COUNT
                       ----------   ------  ---------- 
                     FILIN-CRDT   FILIN-PROG     TALLY
                     DTCY/CCAN                         5
                     DTCY/CCAN                         5
                     DTCY/DLVA                        16
                     DTCY/DLVA                        16
                                                              21


Suggest me icon_neutral.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue Mar 29, 2011 2:06 pm    Post subject:
Reply with quote

My bad, i missed the '----' after the heading.

But try this :

HEADING FILIN-CRDT ('FILIN-CRDT' '----------')

etc.

And you still didnt RTFM icon_eek.gif

One or more alphanumeric literal values specify the content of the alternate
heading. Multiple literals within the parentheses are stacked vertically over the
field when printed.
Back to top
View user's profile Send private message
Prem.y

New User


Joined: 09 Feb 2011
Posts: 7
Location: Hyderabad

PostPosted: Tue Mar 29, 2011 2:32 pm    Post subject:
Reply with quote

Thanks a lot Peter icon_biggrin.gif

Its working icon_smile.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue Mar 29, 2011 2:45 pm    Post subject:
Reply with quote

Everything i suggest is working icon_mad.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Tue Mar 29, 2011 2:59 pm    Post subject: Reply to: Problem in Easytrieve report generation
Reply with quote

the only thing that seldom works around here is the suggestion to read the manuals icon_wink.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue Mar 29, 2011 3:08 pm    Post subject:
Reply with quote

Enrico, thats the terrible truth.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Mar 29, 2011 3:51 pm    Post subject:
Reply with quote

Why read it yourself when you have staff to do it for you icon_lol.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue Mar 29, 2011 6:19 pm    Post subject:
Reply with quote

That was a long time ago when i was a "staff" member, after a while my a-social behavior helped me to form my own staff, that was me and myself.
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 Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am


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