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

Syncsort to extract the records


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sabarikanth

New User


Joined: 07 Jun 2010
Posts: 59
Location: coimbatore

PostPosted: Fri Apr 22, 2011 4:19 am
Reply with quote

Bill,

Quote:
Although your input file looks different, your parameters should help the TS to get somewhere as, as you say, one record has been deleted (I assume you have checked that it is the correct one).


I didnt use a different input file.. i'm using the same file(VB 32000) as input with 'SUB' in position 11.
I think the parameter 'SUB' is in 11th position. It has been confirmed by Shan in previous conversations.....

Thanks,
Sab.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Fri Apr 22, 2011 4:43 am
Reply with quote

sabarikanth wrote:
Bill,

Quote:
Although your input file looks different, your parameters should help the TS to get somewhere as, as you say, one record has been deleted (I assume you have checked that it is the correct one).


I didnt use a different input file.. i'm using the same file(VB 32000) as input with 'SUB' in position 11.
I think the parameter 'SUB' is in 11th position. It has been confirmed by Shan in previous conversations.....

Thanks,
Sab.


Hi Sab,

Well, your file looks different. Look at your display in your post and look at the original. Different?

With a VB file, you have the RDW. SORT still wants you to take the RDW into account when specifying your parameters. 11 from the original example includes the 4 for the RDW, so in the data SUP starts at position 7. In your file, you start at 11 in the data, which requires 15 in the sort parameter.

Any answer at all on why you swapped the conditions around? Last time that I ask.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 2
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top