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

Right Justify the records in PDS


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sasikumar1984

Active User


Joined: 02 Jul 2007
Posts: 109
Location: Chennai - India

PostPosted: Fri Apr 04, 2008 7:58 am
Reply with quote

Hi,

i have 20 records in my PDS. All the records started from position 1 with numeric character except few records started with " symbol by mistake. I need to right justify this. See below exp:

15798789.......
31872699.......
"39712873......

The above records should be changed as below

15798789.......
31872699.......
39712873......

Please tell me how can i do it.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 435
Location: chennai, India

PostPosted: Fri Apr 04, 2008 10:01 am
Reply with quote

what is the field type and size of it?
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Fri Apr 04, 2008 4:21 pm
Reply with quote

Why don't you just edit the member and delete the quote?
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sun Apr 06, 2008 10:04 pm
Reply with quote

And here's how to do it.

In ISPF Edit enter on the cmd line:
Code:
c all 1 '"' ''

That reads "c space all space 1 space single quote double quote single quote space single quote single quote"
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Sun Apr 06, 2008 11:24 pm
Reply with quote

Turn hex on and make sure that " really is a ".
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Mon Apr 07, 2008 7:19 pm
Reply with quote

He'll find out soon enough. icon_smile.gif
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top