VB file: find and copy matching record



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

VB file: find and copy matching record

Postby RonaldCDcosta » Sun Apr 18, 2010 5:56 am

I have a VB file as below:
Record length : 32187
Block size : 32191

I have a list of records to find from this file. The positon in file is 18, length 11.
I need to copy the complete row to a new VB file for these matching records and all non-matching records to anothe VB file.

Input : VB file
output1 : VB matching records
output2: VB non-matching records

How to do this?

I used below Sort, but it seems this works only for FB.
SORT FIELDS=COPY
INCLUDE COND=((18,11,CH,EQ,C'111111111111'),OR,
(18,11,CH,EQ,C'22222222222'),OR,
(18,11,CH,EQ,C'33333333333'))

Please help.
RonaldCDcosta
 
Posts: 14
Joined: Thu Feb 11, 2010 1:58 am
Has thanked: 0 time
Been thanked: 0 time

Re: VB file: find and copy matching record

Postby dick scherrer » Sun Apr 18, 2010 7:09 am

Hello,

This should work for vb files as well as fb. What happened when you tried this?

You need to post the jcl and any informational messages generated by the run.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: VB file: find and copy matching record

Postby Robert Sample » Sun Apr 18, 2010 7:29 am

Is the position 18 with or without the 4 bytes of the record descriptor word (RDW)? If you didn't include the RDW, your sort statements must be changed to position 22 to allow for the RDW.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post