Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Delete specific column in a member in dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
HappySrinu

Active User


Joined: 22 Jan 2008
Posts: 195
Location: India

PostPosted: Fri Mar 14, 2008 12:35 pm    Post subject: Delete specific column in a member in dataset
Reply with quote

Hello All,

Requirement: Having a member in a dataset. Now want to delete the specific length based on column width.

I am able to do for row's using X command but looking for column basis, Are there any commands exist.

Thanks,
Srini
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 14, 2008 12:51 pm    Post subject:
Reply with quote

Please give an example of what you want to do
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Fri Mar 14, 2008 12:54 pm    Post subject: Reply to: Delete specific column in a member in dataset
Reply with quote

google for "ispf column manipulation macros"
Back to top
View user's profile Send private message
HappySrinu

Active User


Joined: 22 Jan 2008
Posts: 195
Location: India

PostPosted: Fri Mar 14, 2008 12:57 pm    Post subject:
Reply with quote

0IEBGENER *lvl srini.test.dataset
0IEBGENER *lvl srini.test.dataset
0IEBGENER *lvl srini.test.dataset
0IEBGENER *lvl srini.test.dataset
0IEBGENER *lvl srini.test.dataset

ONE OF THE LINES IN A MEMBER IS SHOWN ABOVE, NOW I WANR TO DELETE 'IEB' OR '0' IN THE FIRST COLUMN

ANY COMMANDS , PLS
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 14, 2008 1:02 pm    Post subject:
Reply with quote

Did you know that there is a button at the top of this page "SEARCH"

Look what I found using it - might not be perfect but should point you in the right direction.
http://ibmmainframes.com/about16666.html
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Fri Mar 14, 2008 1:03 pm    Post subject: Reply to: Delete specific column in a member in dataset
Reply with quote

if ISPF had some direct commands to do column manipulation I would have posted it,
I posted how to look for tools to achieve what You ask..
"delcols 2 4" ==> delete from column 1 to 3 and shift left

or in pure ispf as a work around
c p'^' '' 2 4 all ( non blanks )
c p'=' '' 2 4 all ( all )


it' s You who is asking for help, so it would be more polite not to shout icon_evil.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 14, 2008 1:05 pm    Post subject:
Reply with quote

Do you mean to delete only those characters or the whole line ?

If only the characters, are they replaced with spaces or nulls ?
Back to top
View user's profile Send private message
HappySrinu

Active User


Joined: 22 Jan 2008
Posts: 195
Location: India

PostPosted: Fri Mar 14, 2008 1:26 pm    Post subject:
Reply with quote

All,
Thanks for the comments, I was in CAPS mode so i typed text here same . Sorry for it.

Secondly, I tried in search but may not be enough which i understood after i got link from expat.

thridly, once i deleted the specific column i would like to move the next columns to left side ti fill that gap.

i guess i got it with your help
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Fri Mar 14, 2008 2:28 pm    Post subject:
Reply with quote

change the bounds and shift left 2.
Back to top
View user's profile Send private message
MCEVOY

New User


Joined: 21 Nov 2005
Posts: 18

PostPosted: Fri Mar 14, 2008 3:54 pm    Post subject:
Reply with quote

In ISPF Edit there is a BNDS Line Command which lets you set the left and right-hand sides of the data to be manipulated.
1) Puts BNDS against a line
2) Position the red '<' and '>' indicators as appropriate
3) Use the (( Line Commands to shift your data left
4) Reset the BNDS commands to encompass the whole line

If you just want to get rid of the first 3 bytes in each line, this can be accomplished with the (( Line Command alone.
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us