Report generation - using Sort



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Report generation - using Sort

Postby karthi_ind » Fri Dec 10, 2010 7:34 pm

Hi all,

I have to create a report in the format below:

Input
Status   id   id1    id2  price   qty   error
-----------------------------------------------
 aaa     1     1       1     100     10   inv-type                              man-err               typ-err
 bbb     2     2       2       50     5                   typ-err                  new-err   send-err              man-err


output
Status  id   id1    id2  price   qty   error
-----------------------------------------------
  aaa     1     1       1    100     10    inv-type
                                                        man-err
                                                        typ-err
<one blank line>
  bbb      2    2       2       50     5     typ-err
                                                       new-err
                                                       send-err
                                                        man-err


The only difference in the output file is the error field has to be displayed column wise for each row, then one blank line
and same for all other records. There are spaces in between the errors, that needs to be removed and bring it to the next column from the input file.
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Report generation - using Sort

Postby Frank Yaeger » Fri Dec 10, 2010 10:03 pm

What is the RECFM and LRECL of the input file?

What position do the "errors" start in and what position do they end in? What is the maximum number of "errors" per record?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Report generation - using Sort

Postby karthi_ind » Sat Dec 11, 2010 12:02 pm

Hi Frank,

The details are as below

RECFM is FB and the input file record size is 252.
But the output file size should be max 133. (as it is a report file)

The errors positions starts at 83 and ends at 252. Maximum no of errors can be 6 to 7. But it depends.

As i mentioned initially the error can be for example in the first field, third field and the last field for some records. And only in the third field and last field for some other records. But in the output file it should be displayed as a column wise (as mentioned in the example). Field means the error 'inv-type' in the first field, the error 'man-err' in the thrid field .. like wise.

Thanks.
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Report generation - using Sort

Postby karthi_ind » Sat Dec 11, 2010 12:44 pm

Hi Frank ,

The version which I am using is

Z/OS DFSORT V1R5

Thanks.
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Report generation - using Sort

Postby skolusu » Wed Dec 15, 2010 1:07 am

karthi_ind wrote:The errors positions starts at 83 and ends at 252. Maximum no of errors can be 6 to 7. But it depends.


Well you have mentioned that the errors can vary . So what is the length of each error? The total error length is 170 bytes. What is the length of each individual error? The posts here and on other board indicate that you have a old version of DFSORT which is NOT supported. Even for this request you may need SQZ to handle varying length errors.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: Report generation - using Sort

Postby karthi_ind » Thu Dec 16, 2010 3:07 pm

Thanks Frank and Skolusu for your reply and spending time on this.
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post