Mainframe, MVS and zOS Discussion

Posted: **Mon Jun 08, 2015 4:55 pm**

Hi,

I want to modify column value in a VSAM file using file-aid. There are moer than 100K records in teh file. And I have to modify the entire file for a particular value, can I do that using file-aid.

Thanks,

Posted: **Mon Jun 15, 2015 4:25 pm**

Hi,

If you want do it in batch, following job should help you:

Code: Select all

//FILEAID EXEC PGM=FILEAID                                
//SYSPRINT DD  SYSOUT=*                                    
//DD01     DD DISP=SHR,DSN=INPUT.VSAM.FILE 
//SYSIN    DD  *                                          
$$DD01 UPDATE IF=(1,EQ,C'VALUE1'),                      
       REPL=(1,C'VALUE2')                                
/*

If you want to do it online, it's pretty straight forward - C ALL 'old value' 'new value' should also do. (unless you are working with packed decimal)

Mainframe, MVS and zOS Discussion

Modify column value in VSAM using file-aid.

Modify column value in VSAM using file-aid.

Re: Modify column value in VSAM using file-aid.