MVSFORUMS.com

pgorthi · Beginner Joined: 13 Sep 2004 Posts: 33 Topics: 16

Hi,

BSAM or QSAM file data i want to delete all rows any command is there please give me reply. i am giving more detail description about my requirement. using 3.4 option we will open in edit mode and in first row dd and last row dd we write after we will press enter it will delete.instead of this any alternative method is there.

Regards,
Pgorthi Rolling Eyes

kolusu · Posted: Wed Oct 06, 2004 9:03 am Post subject:

Pgorthi,

Open your Dataset in edit mode and try this TSO command

pgorthi · Beginner Joined: 13 Sep 2004 Posts: 33 Topics: 16

Hi Kolusu,

Sorry kolusu i searched using another string that's why i didn't find.
Now i tried DEL ALL NX command but it is saying invalid command. with out using rex is it possible. please suggest me.

Regards,
Pgorthi

pgorthi · Beginner Joined: 13 Sep 2004 Posts: 33 Topics: 16

Hi Kolusu,

i opened my file in edit mode but it is showing like browse mode in the contents of file and even not possible to edit any character. what is the problem?

regards,
Pgorthi Embarassed

tauras_kk · Beginner Joined: 03 Oct 2004 Posts: 4 Topics: 0

Pgorthi,

You might want to try this JCL (which uses IEBGENER utility)

//*
//Step01 EXEC PGM=IEBGENER
//SYSUT1 DD DUMMY,DCB=DCB Parameters of "FILE"
//SYSUT2 DD DSN=FILE,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY
//*

Regards,
Karthik

Cogito-Ergo-Sum · Posted: Wed Oct 06, 2004 11:04 am Post subject:

pgorthi,
The DEL NX ALL command does not work for you because, you are in BROWSE mode and not in EDIT mode. This is because, the file is too large to be opened in EDIT mode.

Method suggested by Karthik above, should work fine.
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

kolusu · Posted: Wed Oct 06, 2004 11:07 am Post subject:

Pgorthi,

If your input file is huge then , you will be substituted with browse mode. This is due to Maximum initial storage allowed for Edit and View.

Check this topic for ways of changing that initial sotrage value.

http://www.mvsforums.com/helpboards/viewtopic.php?t=2288&highlight=browse

You can use Karthik's suggested method to delete the contents of the file. But just change the disp=shr to disp=old for sysut2.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

tauras_kk · Beginner Joined: 03 Oct 2004 Posts: 4 Topics: 0

Kolusu,

disp=shr works fine for me..any specific reason why this needs to be changed.

Cheers
Karthik

kolusu · Posted: Wed Oct 06, 2004 11:24 am Post subject:

karthik,

Check this link which explains the difference between using DISP=SHR vs DISP=OLD

http://www.mvsforums.com/helpboards/viewtopic.php?t=1202&highlight=corrupted

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu