Is it possible to delete the last five recods in sequential?

ramesh4mainframes
Posts: 32
Joined: Mon Jun 07, 2010 3:58 pm
Skillset: JCL COBOL VSAM DB2
Referer: MY Faculty
Location: Hyderabad

Is it possible to delete the last five recods in sequential?

Postby ramesh4mainframes » Thu Aug 12, 2010 10:01 am

Hi,

In KSDS file if we wanna delete a particular record then we have to move that Record number to key value then we can delete. It's only possible for single record. Is it possible to delete more than one record?
Thanks,
RamS

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: Is it possible to delete the last five recods in sequential?

Postby dick scherrer » Thu Aug 12, 2010 10:06 am

Hello,

You posted multiple questions in this topic. . .

Yes, the last 5 records can be deleted from a sequential file, but some program code is needed or a builtin feature of some utility (like the sort).

Any number of records can be read then deleted in a ksds. . .
Hope this helps,
d.sch.

ritikasingh
Posts: 39
Joined: Wed Sep 01, 2010 9:12 pm
Skillset: Operating Systems: MVS
Environment: Mainframe, Windows
Databases: VSAM, DB2 Tables
Programming Languages: COBOL, JCL,TSO/ISPF, CICS, DB2 (SQL),
Software Tools: File-AID, Endeavor, SORT, ICETOOL, SNDM, HP Quality Center,
OPC, DRMS,IDCAMS, SMARTIS, VISIO, Vision plus, HP(Service Manager),TSO,ISPF
Referer: google

Re: Is it possible to delete the last five recods in sequential?

Postby ritikasingh » Thu Oct 21, 2010 11:58 pm

Even file aid job can also be used to delete last five record, when you copy the record from one file to another ,give the option to copy from back and skip 5 records.This can be used using temporary option 'T'.


  • Similar Topics
    Replies
    Views
    Last post