how copy selected records from vsam file based on condition

In this Mainframe Forum - You can post your queries on FILE-AID tool

Moderators: Anuj Dhawan, Moderator Group

Post Reply
puja_main
Member
Posts: 8
Joined: Fri Mar 30, 2012 3:29 pm

how copy selected records from vsam file based on condition

Post by puja_main » Wed May 16, 2012 11:55 am

hello there,

I'm using file-aid. I want to copy selected records from xxx.src.vsam file to xxx.dst.vsam based on condition.
In my src file there is one column cc-rating containing value from 1 to 5
and i want to copy only those records containg cc-rating > 3 to dst file.

plz help me with this.


Thanx

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed May 16, 2012 8:04 pm

VSAM files don't have "columns", that's a data-base term. Did you try to use the file-aid in "online" mode to generate the code for you, on the fly?
Regards,
Anuj

puja_main
Member
Posts: 8
Joined: Fri Mar 30, 2012 3:29 pm

Post by puja_main » Wed May 16, 2012 9:27 pm

yes it works. by using option selection in online process.
and sorry for the terms i used.
thanx anuj
Anuj Dhawan wrote:VSAM files don't have "columns", that's a data-base term. Did you try to use the file-aid in "online" mode to generate the code for you, on the fly?

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu May 17, 2012 4:08 pm

Glad you got it working, Have a good one... :)
Regards,
Anuj

Koshizanas
Member
Posts: 2
Joined: Tue May 08, 2018 1:33 pm

Post by Koshizanas » Tue May 08, 2018 1:40 pm

I think so, it has a great angle.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others