Using Easytrieve i have created one report. Using this Report i need to create the Outfile report as follows. Is that possible using ICETOOL.
RECFM : FBA and LRECL = 80.
Input file Report :
Code:
1REPORT-01 BANK TABLE EXPIRATION DATES
TITL2: B1
-
TABLE START END
BANK IND DATE DATE
0 B1 AA38 B1MR10080 000 07/01/00 04/31/10
AA38 B1MR10085 001 07/28/03 04/31/10
AA38 B1MR10090 002 11/01/01 04/31/10
BB46 B1MR10095 003 11/29/00 04/31/10
BB46 B1MC10010 10/21/99 05/11/10
1REPORT-01 BANK TABLE EXPIRATION DATE
TITL2: B2
-
TABLE START END
BANK IND DATE DATE
B2 AA38 B2MR10080 05/23/08 03/10/10
AA38 B2MR10085 04/29/12 03/12/10
BB46 B2MR10090 04/29/12 04/10/10
The Input report is Bankwise Break. In that AA38 and BB46 are the tables.
I have created the Input report using Easytrieve and I need to create the Output file which should summarise as the Table name and the Occurance of the table as follows. I couldn't create this report using Easytriev itself.
Hence asking whether it is possible to create using ICETOOL.
Outfile Report format :
Code:
1REPORT-01 BANK TABLE EXPIRATION DATES
TITL2: B1
-
TABLE START END
BANK IND DATE DATE
0 B1 AA38 B1MR10080 000 07/01/00 04/31/10
AA38 B1MR10085 001 07/28/03 04/31/10
AA38 B1MR10090 002 11/01/01 04/31/10
BB46 B1MR10095 003 11/29/00 04/31/10
BB46 B1MC10010 10/21/99 05/11/10
BANK SUMMARY SUMMARY TOTALS
------------ --------------
AA38 3
BB46 2
1REPORT-01 BANK TABLE EXPIRATION DATE
TITL2: B2
-
TABLE START END
BANK IND DATE DATE
B2 AA38 B2MR10080 05/23/08 03/10/10
AA38 B2MR10085 04/29/12 03/12/10
BB46 B2MR10090 04/29/12 04/10/10
BANK SUMMARY SUMMARY TOTALS
------------ --------------
AA38 2
BB46 1
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
While trying to create using Easytrieve i couldn't get the report properly.
Suggest that spending some more time learning more about Easytrieve would be a good investment of your time as it is already "standard" on your system. Also, once learned, it would be in your "tool kit" forever. . .
Not taking time to learn (or ask for Easytrieve help) and asking someone else to write the code is probably not the direction you want to follow. . .
Addiing additional processes that have to be maintained is probably not something your management would recommend either.
And then there is the potential of wasted system resources. . . What if there were hundreds of millions of records. . .
1REPORT-01 BANK TABLE EXPIRATION DATES
TITL2: B1
-
TABLE START END
BANK IND DATE DATE
0 B1 AA38 CB 000 07/01/00 04/31/10
AA38 CB 001 07/28/03 04/31/10
AA38 CB 002 11/01/01 04/31/10
BB46 CB 003 11/29/00 04/31/10
BB46 CB 004 12/31/09 04/31/10
BANK SUMMARY SUMMARY TOTALS
--------------- --------------
AA38 3
BB46 2
TOTAL FOR CORP: 5
1REPORT-01 BANK TABLE EXPIRATION DATES
TITL2: B2
-
TABLE START END
BANK IND DATE DATE
0 B2 AA38 CFMR10080 05/23/08 03/10/10
BB46 CFMR10080 05/23/08 03/10/10
BANK SUMMARY SUMMARY TOTALS
--------------- --------------
AA38 1
BB46 1
I got one more modification in this requirement. I need to add one Blank line if there is a change in the Table Ind. Means that in the below report i am having AA38 and BB46 as table ind. As soon as AA38 details are written into the report one blank link should come and then BB46 detail records should be written. Is that possible to do using DFSORT.
Code:
REPORT-01 BANK TABLE EXPIRATION DATES
TITL2: B1
-
TABLE START END
BANK IND DATE DATE
0 B1 AA38 CB 000 07/01/00 04/31/10
AA38 CB 001 07/28/03 04/31/10
AA38 CB 002 11/01/01 04/31/10
Thank you so much for the quick reply. But i didn't get the Ouput as expected. Actually the number of Table indicators are increased and the lenght also changed to 133 FBA format. Hence i modified the code accordingly. Herewith i am attaching the Code and the Expected Results.
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
Nethraa wrote:
Thank you so much for the quick reply. But i didn't get the Ouput as expected. Actually the number of Table indicators are increased and the lenght also changed to 133 FBA format.
Nethraa,
The given jobs works according to the input you provided. I just can't read your mind or look at your data. If you knew the specifications have changed you should have mentioned it before and it would save a lot of my time as well as your time. I can't keep working on 'n' different scenarios.
Here is the updated code which would give you the desired results
First of all i am really sorry as i took your valuable time. But Even i don't know before about the requirement change. As they asked me to change the record length i tried the code as i mentioned.