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?
Is it possible to delete the last five recods in sequential?
-
- Posts: 32
- Joined: Mon Jun 07, 2010 3:58 pm
- Skillset: JCL COBOL VSAM DB2
- Referer: MY Faculty
- Location: Hyderabad
- 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?
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. . .
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.
d.sch.
-
- 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?
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
-
-
Merging PDS members into single sequential file.
by jcbrotel » Thu Aug 18, 2022 7:27 pm » in IBM Cobol - 4
- 2938
-
by prino
View the latest post
Fri Aug 19, 2022 11:20 pm
-
-
- 1
- 2328
-
by Robert Sample
View the latest post
Fri Feb 25, 2022 7:42 pm
-
- 1
- 5699
-
by enrico-sorichetti
View the latest post
Fri Dec 10, 2021 5:23 pm
-
-
strategy: partitioned table, delete millions of rows
by BobHarris » Wed Aug 17, 2022 2:47 pm » in DB2 - 1
- 1961
-
by engh
View the latest post
Tue Sep 20, 2022 1:56 pm
-
-
-
Issue Create/delete ALIAS IDC3013I and then IDC3012I
by jcdm » Thu Dec 05, 2024 9:26 pm » in VSAM/SMS - 1
- 1721
-
by willy jensen
View the latest post
Fri Dec 06, 2024 12:04 am
-