MVSFORUMS.com

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Hi frineds I ahve a doubt in Dummy load
can we delete all the rows in the Table use Dummy laod(the Table cotains some not null fileds also)

Nic Clouston · Posted: Thu May 03, 2007 3:10 am Post subject:

Have you tried it - that will answer your question quicker than anyone here can!
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

However, you have to use the parameter REPLACE in combination with a SYSREC input dataset defined as DUMMY in the JCL AND(!!!) the parameter LOG NO.

REPLACE will always delete and define the underlying VSAM cluster of the tablespace. With this combination of parameters, you will very effectivly get rid of all the rows of a table (and, be shure to know about that, of all the rows of all tables defined in this tablespace as well; therefore beware).

regards
Christian