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

need to change DELETE some columns in PS
IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
ajayvamsi

New User


Joined: 21 Jul 2005
Posts: 56
Location: Hyderabad
PostPosted: Sat Jan 07, 2006 10:52 am
 Reply with quote
Hi All,

I need to delete 1 column in the fixed length Flat file can anyone help me how to do this with out using SORT

I came to know that we can do this using File-Aid (Reformat) option can anyone help how to do so using reformat option...!!

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

New User


Joined: 23 Nov 2005
Posts: 69
Location: Minneapolis, MN USA
PostPosted: Tue Jan 10, 2006 5:54 pm
 Reply with quote
Hi,

Please try the following!!

Type (( and ((1 in the line numbers as follow

Code:
((0001  ERWERTE
000002  FGGFGFE
((1003  BNNBMME


or

type the following in the Command line

c all P'?' '' 1

Correct me if my answer is wrong..

Thanks,
Mani
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 -> Compuware & Other Tools

 

Similar Topics
Topic Forum Replies
No new posts Binary File format getting change whi... All Other Mainframe Topics 7
No new posts DELETE SPUFI DB2 1
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Increase the number of columns in the... IBM Tools 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us