The first VSAM file V1 has 2 fields A and B . There is a DB2 file which has fi

The first VSAM file V1 has 2 fields A and B . There is a
DB2 file which has fields E and f. We need the fields A,
B , E and F to another VSAM file called V2. Kindly mention
the logic in procedure division in cobol..

Question Posted / don

2 Answers
8903 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

The first VSAM file V1 has 2 fields A and B . There is a DB2 file which has fields E and f. We nee..

Answer / rookie

I suppose the question is a bit confusing....DB2 deals in
table's and has records...

Open VSAM file and read the records into WS variables,
Fetch DB2 records in host variables
Now write them to file V2.

Is This Answer Correct ?

2 Yes

0 No

The first VSAM file V1 has 2 fields A and B . There is a DB2 file which has fields E and f. We nee..

Answer / anoop

One methode is we can first repro the VSAM file into
sequential file and then SORT it into another sequential
file to include only A and B fileds. Then repro it again
into the VSAM file V2.

In cobol open this file in I-O mode and read it sequentialy
and move A & B fileds to a working storage variable.

Read the field E & F from data base and A & B from the
working storage and populate into the V2 VSAM file.

There could be some changes in the logic as per the exact
requirement.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer