Modify column value in VSAM using file-aid.

[RekhaRani]

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,

[Anuj Dhawan]

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)