IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to delete the sequence numbers from a dataset


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
YaminiPYKD

New User


Joined: 29 Mar 2010
Posts: 1
Location: vja

PostPosted: Mon Mar 29, 2010 8:08 pm
Reply with quote

Hi All,

Some sequence number is added in a dataset (at the end) by using Icetool.
Please see the data below:
599 010810 10000 000000001
1600 020810 1600 000000002
100 032610 4020 000000003

Now , i want to remove the last column ... can anyone help me out , how to accomplish this task
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA

PostPosted: Mon Mar 29, 2010 8:35 pm
Reply with quote

Terminology is critical in IT. You need to be aware that column for a data set refers to one byte -- only in a data base (which is NOT a data set) does "column" refer to more than one byte of data. So you are asking for a way to remove the 1, 2, 3, ... but leave the remaining bytes of the sequence number.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Mar 29, 2010 8:46 pm
Reply with quote

Hello and welcome to the forum,

Suggest you post the output you want from the sample input.

Also, mention the recfm and lrel of the files. Post any "rules" for getting form the input to the ouput.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Mar 29, 2010 10:16 pm
Reply with quote

are the sequence numbers used by any process after the icetool step?

if not, change the original icetool step to drop the sequence number on output.

if that is the case, providing the control cards of the icetool step would enable someone to provide you with the additional control cards to drop the sequence number.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
Search our Forums:

Back to Top