File-Aid VSAM 'COPY' using sequential key file



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

File-Aid VSAM 'COPY' using sequential key file

Postby rnanavaty » Tue Mar 01, 2016 3:01 pm

Dear All,

I have a VSAM file which contains more than 4 million records. Also I have a sequential file which contains approx. 50,000 key values of VSAM.

Aim is 'Using file-aid' can we get 50,000 records with key as in sequential file and copy to another VSAM file. In other words using File-Aid or File-Aid/batch can we read sequential file to extract particular records

Regards
Rahul
rnanavaty
 
Posts: 2
Joined: Tue Mar 01, 2016 2:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File-Aid VSAM 'COPY' using sequential key file

 

Re: File-Aid VSAM 'COPY' using sequential key file

Postby enrico-sorichetti » Tue Mar 01, 2016 3:57 pm

what about looking at the fileaid manuals or the online help ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: File-Aid VSAM 'COPY' using sequential key file

Postby rnanavaty » Tue Mar 01, 2016 4:03 pm

Dear Enrico,

I tried looknging multiple online options.

All talk about inline condition for condional copy. I have found no place where an input sequential file read to perform this activity. We have performed mentioned query with EZT but as per few standards we are looking for more peferable option using file-aid.
rnanavaty
 
Posts: 2
Joined: Tue Mar 01, 2016 2:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File-Aid VSAM 'COPY' using sequential key file

Postby NicC » Tue Mar 01, 2016 4:13 pm

Well, if it isn't in the manual then it cannot be done. You will have to find some other way of doing it - possibly your sort prduct or, possibly better, a bespoke program.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post