SYNCSORT replace certain content of vsam into another vsam

Pons · Posted: Thu May 28, 2009 9:31 pm

I have a VSAM file with 808080 in the 30th to 40th position.
I just want to modify the 808080 to 909090 for all the records into another VSAM file.

dick scherrer · Posted: Fri May 29, 2009 1:50 am

Hello,

Your post shows 6 bytes, but mentions 11 positions. Show some proper sample input and the output you want from that input.

Bhargav_1058 · New User Joined: 13 Dec 2008 Posts: 53 Location: New York

Hi,

If your file is having all 808080 starting from 30th position to 40th position and if you want to change all of them then try below.

1). Copy your VASM to a flat file using below sort condition..

SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(30,10,CH,EQ,C'8080808080'),OVERLAY=(30:C'9090909090'))

2). Copy the new output file from the above step to your VSAM file.

Thanks,
Bhargav.

expat · Posted: Fri May 29, 2009 1:41 pm

Why unload the file, SORT products can do VSAM >> VSAM

Bhargav_1058 · New User Joined: 13 Dec 2008 Posts: 53 Location: New York

Yeah thats true...

Sort can do VSAM to VSAM, not required to unload the VSAM.

dick scherrer · Posted: Fri May 29, 2009 9:23 pm

Hello,

The request mentions 11 positions, the "solution" only 10. . .

Robert Sample · Posted: Fri May 29, 2009 9:26 pm

Pons · Posted: Thu Jun 11, 2009 2:38 am

Hi Dick,

I gave the data for sample. All 11 bytes are like 80808080808.

Thanks bhargav. I will try your idea and let you know in case of any assistance.