IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


How to find the number of records altered using DFSORT



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

Re: How to find the number of records altered using DFSORT

Postby Prasanna G » Wed Apr 13, 2011 9:33 pm

Hi Frank

Thanks a lot for getting me the solution.
I have seen one more problem in the report.
The report page number is always 2 as below.
Can you please tell me what could be the reason for that?

Select all
 -------------------------------------------------------------------------------
 SDSF OUTPUT DISPLAY S927328A JOB30632  DSID   102 LINE 0       COLUMNS 42- 121
 COMMAND INPUT ===>                                            SCROLL ===> CSR 
********************************* TOP OF DATA **********************************
XYZ COMPANY                                          PAGE:   2                 
ARTFORD                                   STANDARD REPORT                       
 TRANSACTION CONVERSION                                                         
      CONTROL REPORT                                                           
                                                                               
                                                                               
                                                                               
 TO 63:        2                                                               
 TO 66:        2                                                               
                                                                               
                                                                               
                                                                               
         *** END OF REPORT ***                                                 
******************************** BOTTOM OF DATA ********************************

User avatar
Prasanna G
 
Posts: 71
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time
Top

Re: How to find the number of records altered using DFSORT

Postby Frank Yaeger » Wed Apr 13, 2011 10:26 pm

When I run the DFSORT job I posted, the page number is 1, not 2. If you're getting page number 2, then either you're not using DFSORT, or you changed something.

You would need to show me the complete JES log for your job in order for me to comment further.
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
Top

Re: How to find the number of records altered using DFSORT

Postby Prasanna G » Wed Apr 13, 2011 10:34 pm

Hi Frank

Just now I noticed the Spool data. It shows Syncsort for Z/OS 1.3.2.1R.
But I have not modified anything in the sort card.
I gave PGM=SORT in the step. I dont know how it takes the program as SYNCSORT.

Select all
 SDSF OUTPUT DISPLAY S927328A JOB30632  DSID   103 LINE 0       COLUMNS 02- 81 
 COMMAND INPUT ===>                                            SCROLL ===> CSR 
********************************* TOP OF DATA **********************************
 SYNCSORT FOR Z/OS  1.3.2.1R    U.S. PATENTS: 4210961, 5117495   (C) 2007 SYNCSO
                               KAISER PERMANENTE INFORMATION TECHNOLOGY   z/OS 
 SYNCSORT LICENSED FOR CPU SERIAL NUMBER 52655, MODEL 2097 710             LICEN
 SYSIN :                                                                       
   OPTION COPY                                                                 

User avatar
Prasanna G
 
Posts: 71
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time
Top

Re: How to find the number of records altered using DFSORT

Postby Frank Yaeger » Wed Apr 13, 2011 11:17 pm

It takes the program as Syncsort because that's the sort product installed at YOUR site.

The job I posted works fine with DFSORT and displays page 1. Syncsort is apparently displaying page 2.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

Please post Syncsort questions in the Syncsort Topic, not in the DFSORT Topic.
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
Top

Re: How to find the number of records altered using DFSORT

Postby Prasanna G » Wed Apr 13, 2011 11:23 pm

ok Frank. Thanks a lot for your valuable time and input.
User avatar
Prasanna G
 
Posts: 71
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time
Top
Previous
Post a reply

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks