How to delete all or part of the contents of a PS

ziddiguy · New User Joined: 20 Jul 2007 Posts: 14 Location: Germany

Hi friends..

I have some more doubt that how can we delete(purge) the contents(data) in a PS.. Suppose I hava a PS with millions of record
1)I would like to delete all millions of records and make PS empty

2) How can I purge only first 1000 records

Appreciate your help

Thanks

CICS Guy · Posted: Sat Aug 18, 2007 9:54 pm

Point almost any utility at it and write no records, it will open and close it, creating an empty file. For instance:

ziddiguy · New User Joined: 20 Jul 2007 Posts: 14 Location: Germany

Appreciate your prompt reply.. But for the second question that if I want to purge only first 1000 records

William Thompson · Posted: Sat Aug 18, 2007 10:21 pm

You can't directly, you will have to read the dataset and rewrite it. Sort has a command that allows you to skip records.

ofer71 · Posted: Sun Aug 19, 2007 12:56 am

For your first question, you can also try IDCAMS REPRO with COUNT(0).

O.

Frank Yaeger · Posted: Sun Aug 19, 2007 8:56 pm

ziddiguy · New User Joined: 20 Jul 2007 Posts: 14 Location: Germany

Thanks Guys

Appreciate your help!!!!!