Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SORT CARD used in JCL not working

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: SORT CARD used in JCL not working
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

Moderator Team Head


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

PostPosted: Thu Mar 23, 2006 12:05 pm    Post subject: Re: SORT CARD used in JCL not working
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us