IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SORT CARD used in JCL not working


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
geeta.mishra

New User


Joined: 27 Dec 2005
Posts: 21
Location: Bangalore

PostPosted: Thu Mar 23, 2006 11:49 am
Reply with quote

Hi,

I am using the following input file which has to be sorted on BRANCH-NO,ACCOUNT-NO,RECORD-ID.This is a variable block file of length 300.

Structure of the file:

:TAG:-MIGR-MAST-REC
3 :TAG:-RECORD X(300)
3 :TAG:-HEADER-RECORD REDEFINES :TAG:-RECORD
3 :TAG:-HEADER-RECORD GROUP
5 :TAG:-HR-BRANCH-NO 9(6)
5 :TAG:-C1 X
5 :TAG:-HR-ACCOUNT-NO 9(8)
5 :TAG:-C2 X
5 :TAG:-HR-RECORD-ID 99
5 :TAG:-C3 X

(for clarity I have mentioned only the first few records of the file)

I am using the following sort card to sort the records in the above file:

(1,6,ZD,A,8,8,ZD,A,17,2,ZD,A)

My input file has:

Branch-no C1 account-no C2 Record-id
100002 , 10000003 , 02
100003 , 10000003 , 02
100003 , 10000001 , 01
100003 , 10000003 , 01
100003 , 10000003 , 03
100002 , 10000002 , 01
100001 , 10000007 , 03
100001 , 10000005 , 01

and I am getting the output as:

Branch-no C1 account-no C2 Record-id

100001 ,10000005 , 01,
100001 ,10000007 , 03,
100002 ,10000002 , 01,
100002 ,10000003 , 02,
100003 ,10000001 , 01,
100003 ,10000003 , 02,
100003 ,10000003 , 01,
100003 ,10000003 , 03,

JCl is executing with MAXXCC=0 but output is not getting sorted.
This might be a problem with the Sort card which I am using.

Could you please help me out in this as early as possible.

Thanks,
Geeta
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Thu Mar 23, 2006 12:05 pm
Reply with quote

From The DFSORT Manual:

Quote:

The first data byte of a fixed-length record has relative position 1. The first data byte of a variable-length record has relative position 5. The first 4 bytes contain the record descriptor word.
Back to top
View user's profile Send private message
geeta.mishra

New User


Joined: 27 Dec 2005
Posts: 21
Location: Bangalore

PostPosted: Thu Mar 23, 2006 12:17 pm
Reply with quote

Thanks for giving me the new information about variable block file
Its working now:)


Thanks a lot!!
Geeta
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
Search our Forums:

Back to Top