i have to change a report which prints data of 3 months.its header is define in a sort card using OUTFIL - HEADER2 field.
currently i have report in this format.
denial report - Medicare page no
non contracted providers
data1 data 2 data3
now i have to change this to:
denial report - Medicare page no
non contracted providers
jan 06 - mar 06
data1 data 2 data3
how can we get this time peroid in header..as this time period will vary for each report...suppose if current month report is of jan 2006 then..we have to print time peroid ... nov 05- jan 06..in this way...
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
It's not clear what you want for the time period. At first I thought you wanted to use the current month to get the time period. For example, if the report was run today, the current month would be Jan, 2007 and the heading would have nov 06- jan 07. But you show nov 05- jan 06, so where did the "current" month of jan 06 come from? Do you actually want to use the current month of the run, or do you want some other month and if so where do you get that month from?
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
You can create that heading line as a DFSORT symbol and then use the symbol in HEADER2. Here's a DFSORT job that shows how. You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's DATE2-2 function. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:
1st file we have - only single record that is : jan 06-mar06
2nd file we have a 2 line record that is:
denial report - Medicare page no
non contracted providers
we want to merge these 2 files in this format:
denial report - Medicare page no
non contracted providers
jan 06-mar06
how can we do this? can we do this using merge utility?
after that we have a file in which there are thousands of record and we want this merged header will come after every 52 lines in data.can we append this 3 lines header in the 3rd file which contains records like this:
data1 data2 data3 data4 data5 data6...
....
...
...
and we want combined file to look like this:
denial report - Medicare page no
non contracted providers
jan 06-mar06
data1 data2 data3 data4 data5 data6...
....
...
...
after 51 lines of data
denial report - Medicare page no
non contracted providers
jan 06-mar06
data1 data2 data3 data4 data5 data6...
....
...
...
after 51 line of data
denial report - Medicare page no
non contracted providers
jan 06-mar06
data1 data2 data3 data4 data5 data6...
....
...
...
how can we do all this without using programming...can we also do this using merge utility?
plz ignore previous query...i want answer to this one quickly...plzzz help....
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Here's a DFSORT job that will do what you asked for. I wasn't sure if you wanted "page no" in the first line of the header to be replaced with the actual page number of the report (e.g. 1, 2, ...) so I assumed you didn't. If you do, tell me what form you want the page no in (e.g. 0001) and I'll show you how to do that. I also assumed that file1 and file2 have RECFM=FB and the same LRECL.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
That's just another variation of what I already showed you how to do. Use the one record file to set up a symbol as shown previously, e.g. Mydate, and then use that Symbol for the date:
62:Mydate)
In my previous example, Line3 was set up for that constant.