Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how to delete the dataset's content

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
LinkinPark
Warnings : 1

New User


Joined: 20 Nov 2005
Posts: 44
Location: DALIAN,CHINA

PostPosted: Sat Feb 25, 2006 11:10 am    Post subject: how to delete the dataset's content
Reply with quote

how to delete the dataset's content from 4th column to 5 column ?
my dataset like this
Code:
JPVPJ2.CMS.TAMNA.S5.TEMP.SE                      ZJP564+  PS    FB
JPVPJ2.CMS.TAMNA.S6.TEMP.SE                      ZJP589+  PS    FB
JPVPJ2.CMS.TAMNA.S7.TEMP.SE                      ZJP737+  PS    FB

how to change it to

Code:

JPVPJ2.CMS.TAMNA.S5.TEMP.SE                      PS    FB
JPVPJ2.CMS.TAMNA.S6.TEMP.SE                      PS    FB
JPVPJ2.CMS.TAMNA.S7.TEMP.SE                      PS    FB


thanks
Back to top
View user's profile Send private message

mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sat Feb 25, 2006 9:40 pm    Post subject:
Reply with quote

Link,

Your comments don't match your example.

Also you don't tell us if you want to do it in a pgm, ISPF, sort or whatever.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Sat Feb 25, 2006 9:45 pm    Post subject:
Reply with quote

You can use a DFSORT job like this one to do what you asked for:

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=... output file
//SYSIN    DD    *
   OPTION COPY
   OUTREC FIELDS=(1,49,59,8)
/*


If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
Sandy-is-here

New User


Joined: 16 Mar 2006
Posts: 6
Location: Bangalore

PostPosted: Tue Apr 04, 2006 11:16 am    Post subject: Re: how to delete the dataset's content
Reply with quote

Hi Link,

You can try giving BNDS option in front of your first row and set the BNDS pointer '<' to the specific column want to delete. Then shift that many columns to left using ((8 (in your case) on first record and ((8 at the last record. Once that particular column is deleted, set back the BNDS pointer to the first column.
Try this out..might work faster for less number of records, where a file can open in edit mode..

-Sandy
Back to top
View user's profile Send private message
sathyajes

New User


Joined: 02 Mar 2006
Posts: 24
Location: Chennai

PostPosted: Tue Apr 04, 2006 1:19 pm    Post subject: Re: how to delete the dataset's content
Reply with quote

Hi Link,

If want your requirement to be accomplished thru an ISPF Command the follwing on the Command line on Edit mode will suffice.

c all p'?' ' ' 30 40

This says - Change all chacters from 30th position to 40th position to space and also move the content towards left

If there is a <space> between the Quotes then it would be replaced by spaces alone and conten will not be moved left

c all p'?' ' ' 30 40

This would be handy if you want to edit a dataset very quickly

Hope it helps you !

With Regds,

Sathya
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
This topic is locked: you cannot edit posts or make replies. Cobol to fetch the content by using s... arunc55 COBOL Programming 4 Fri Nov 17, 2017 1:25 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us