Syncsort - need help w/ modifying a report. Line break logic

ScottUrban

I know the topic sounds simple however when dealing with state programs nothing is ever simple. The report process here writes the detail lines to a GDG and then uses a sort member to place the headings and position the detail as pasted below;

ScottUrban

Anyone... Anyone?

Skolusu

ScottUrban,

I really have no idea as to what the requirement is. Show me the input cobol layout and output cobol layout and may be we can help you.

1. What is the LRECL and RECFM of the input and output files
2. Show us a sample of input and desired output

ScottUrban · Posted: Thu Jun 26, 2008 7:46 pm Post subject:

I did show you in the first post what the desired output is.

I am modifying a report

The file is a normal FB gdg lrecl 105 with all the detail lines for the report.
the sort member puts in the headers and arranges the detail with the outrec.

The requirement is to add two more columns to the report. Provider number 9(9) bytes and provider name X(20) but there is no room on the report. I do not want to increase the size of the file if possible.

The current input fields are
DCN 1-8
SSN 9-17
Name 18-49
DOD 50-59
ADJ ICN 60-72
ICN 73-85
FDOS 86-95
LDOS 96-105

Abbreviated snapshot of the input file currently
----+----1----+----2----+----3----+----4----+----5----+----
********************************* Top of Data *************
00012352496541967ELSIE ACHOTT 03/26/2008
00148363431725019MAXINE CSTEVERSON 03/19/2008
00148363431725019MAXINE CSTEVERSON 03/19/2008

Currenty the report appears like I posted before but the headings didn't line up in my post with the detail lines.... I posted an abbreviated snapshot of the report only the first detail line and the first four fields on that line. Along with the main report heading.

GMBM9700-R001 MEDICAID MANAGEMENT
AS OF 06/09/08 ADJUSTED CLAIMS FOR

DCN--------SSN----------NAME--------------DOD

00012352 496541967 ELSIE A CHOTT 03/26/2008

I want to write the provider number and name to the current file as the first detail line for the first and subsequent DCN the first field in the file that will be the driver. when it changes a new provider number and name will be written before the next DCN. This will be done in my COBOL program. not a problem easy to do....

Example
Abbreviated snapshot of the new input file (detail lines for the report)
----+----1----+----2----+----3----+----4----+----5----+----
********************************* Top of Data *************
010135408ST JOHNS REGIONAL
00012352496541967ELSIE ACHOTT 03/26/2008
580155109MADISON MEDICAL CENT
00148363431725019MAXINE CSTEVERSON 03/19/2008
00148363431725019MAXINE CSTEVERSON 03/19/2008

Now the above new input still FB lrecl 105 but now with a new detail record of provider number and name will come before the original detail line record. So in the example below, provider number 010135408 belongs with DCN 00012352 and Provider number 580155109 belongs with DCN 00148363

I want to know if it is possible to modify the current sort member from my original post above to handle the new input as a line break. so the report can print like below

GMBM9700-R001 MEDICAID MANAGEMENT
AS OF 06/09/08 ADJUSTED CLAIMS FOR

PROVIDER---PROVIDER NAME <<this is the new header

010135408 ST JOHNS REGIONAL <<This is the new detail

DCN--------SSN----------NAME--------------DOD <<< existing header

00012352 496541967 ELSIE A CHOTT 03/26/2008 <existing detail

PROVIDER---PROVIDER NAME

580155109 MADISON MEDICAL CENT

DCN--------SSN----------NAME----------------------DOD

00148363 431725019 MAXINE C STEVERSON 03/19/2008
00148363 431725019 MAXINE C STEVERSON 03/19/2008

Skolusu

ScottUrban,

ScottUrban · Posted: Fri Jun 27, 2008 8:26 pm Post subject:

The first 9 bytes of the new input record are a unique provider number if that's what you mean. The heading could be PROVIDER # using the # as an abbreviation for number and the pound sign could be the indentifier. I'm not sure If I totally understand what you are looking for.

Skolusu · Posted: Fri Jun 27, 2008 9:13 pm Post subject:

ScottUrban,

All I am asking is is there any indicator on the ST JOHNS REGIONAL record which differentiate it from the detail record of it

I was under impression that your input already has a hospital name record and then followed by the detail records for the hospital.

So if we can identify the Hospital name record we can splice that to all detail records and then we can use that as the header

Kolusu

ScottUrban · Posted: Sat Jun 28, 2008 12:59 am Post subject:

The first detail record will be a unique provider number Pic 9(9) and the name of the provider Pic x(20) not necessarily a hospital but the entity that provided service to the recipient

the provider number is a unique 9 digit number in the first 9 bytes.

The detail records following the provider will contain the recipients information. The DCN is a unique 8 digit number that identifies that record

if that dcn changes then a new provider will be retrieved and written to the file as the start of the next recipients information. So a recipients information on the report would start with their provider# and name and then their info one to many times depending on how many claims they have. I hope I have explained it correctly for you.

010135408ST JOHNS REGIONAL
00012352496541967ELSIE ACHOTT 03/26/2008
580155109MADISON MEDICAL CENT
00148363431725019MAXINE CSTEVERSON 03/19/2008
00148363431725019MAXINE CSTEVERSON 03/19/2008

dick scherrer · Posted: Sat Jun 28, 2008 2:49 am Post subject:

Hello,

You (and now some of us

) know a header from a detail from using IEBIBALL (eyeball).

Would it be safe to say that a "header" can be identified as a record having no date (nn/nn/nn) in the record?

ScottUrban · Posted: Mon Jun 30, 2008 5:54 pm Post subject:

The record I am adding to the original file using my cobol program will only contain the two fields, Provider Number and Provider name. The new record will still be 105 bytes but only contain two fields.

The record(s) the follow it will be the original detail line(s) that go with that provider number and name. I have posted an entire 105 byte detail record and the new record I will be adding.

010135408ST JOHNS REGIONAL
00012352496541967ELSIE ACHOTT 03/26/20084008094065290700816197000003/31/200803/31/2008

dick scherrer · Posted: Mon Jun 30, 2008 8:36 pm Post subject:

Hello,

ScottUrban

Ok, So what do you suggest. Should I add a delimitter to the new record so it can be identified? Byte 30-105 would contain nothing on the Provider number and name record. Below I put a % marking byte 30.

010135408ST JOHNS REGIONAL %

ScottUrban · Posted: Mon Jun 30, 2008 8:43 pm Post subject:

Also, remember the original SYSIN member being used in my original post. I wanted a solution that would just be able to add to that member.

Skolusu · Posted: Mon Jun 30, 2008 10:35 pm Post subject:

scotturban,

Assuming that you did put # on the provider record, the following DFSORT JCL will give you the desired results.

ScottUrban · Posted: Mon Jun 30, 2008 11:29 pm Post subject:

Thank you. It looks good. One thing, I need the DCN SSN NAME DOD header portion to be before the original detail line though.

So the report would be

SARPAGE 1

GMBM9700-R001 MEDICAID MANAGEMENT INFORMA

PROVIDER PROVIDER NAME
010135408 ST JOHNS REGIONAL

DCN SSN NAME DOD

00012352 496541967 ELSIE A CHOTT 03/26/2008

PROVIDER PROVIDER NAME
580155109 MADISON MEDICAL CENT

DCN SSN NAME DOD

00148363 431725019 MAXINE C STEVERSON 03/19/2008
00148363 431725019 MAXINE C STEVERSON 03/19/2008