How did you refresh a VSAM file and how frequently you do
it ?
Answer Posted / mahesh
Depends , refresh can be done dialy/weekly/monthy.
Refresh means just DELETE/DEFINE the VSAM file
i.e this done in two steps
STEP1 : deleting the Existing vsam file;
IF LASTCC =8 ; SET MAXCC=0
STEP2 : DEFINE VSAM-FILE(COND=(0,LT,STEP1)
Note: we will get Return-code=8; when the file we are
trying the delete doen't exist.
Thanks & Regards,
Mahesh.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
explain how can you initialize a vsam file before any operation?
what are s0c1, s0c4, s0c5, s0c7 abends?
Explain the function of the relative record data set?
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
How does control intervals and control areas related to each other?
what do you mean by recovery and speed parameters in define cluster command?
Differentiate between ci split and ca split?
What are the common vsam error conditions and codes?
difference between vsam and database tables
What is control area?
Explain the purpose of the file status clause in the select statement?
What is a lds (linear data set)?
what do you mean by the repro command?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
what are the additional information you should give in the dd statement while defining the next generation of a gdg?