Modify column value in VSAM using file-aid.

File-AID from Compuware and File Manager from IBM.
Previous topicNext topic

Topic Author
RekhaRani
New Member
Posts: 1
Joined: Thu Nov 20, 2014 7:47 pm

Modify column value in VSAM using file-aid.

Post by RekhaRani » 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,



User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

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

Post by Anuj Dhawan » 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)


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.

Previous topicNext topic

Return to “File-AID and IBM File Manager.”