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

Need help in editable format


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

New User


Joined: 21 Jan 2006
Posts: 19
Location: Mumbai

PostPosted: Mon Apr 29, 2013 2:46 am
Reply with quote

Hi,

10 ABC PIC X(8).
10 def PIC S9(9) USAGE COMP.
10 lmn PIC S9(9) USAGE COMP.
10 xyz PIC X(26).


I have my file layout in this format.

i want to present this data in notepad in comma editable format.

I am having a problem to this in editable format.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Apr 29, 2013 3:06 am
Reply with quote

You won't be able to convert binary fields to ASCII, and you won't be able to edit binary fields in wordpad, and if you want commas you'll need commas. Make the COMP fields "NUMERIC EDITED" with a sign.
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 Apr 29, 2013 3:57 am
Reply with quote

Hello,

Read the file you have and reformat to DISPLAY numbers (instead of COMP) and inert commas beween the fields.

You could use your sort product or the COBOL STRING to do this.

When the file is downloaded, it will have been properly converted to ASCII and ready to use.
Back to top
View user's profile Send private message
rajeevdas03
Warnings : 1

New User


Joined: 21 Jan 2006
Posts: 19
Location: Mumbai

PostPosted: Mon Apr 29, 2013 5:11 am
Reply with quote

dick scherrer wrote:
Hello,

Read the file you have and reformat to DISPLAY numbers (instead of COMP) and inert commas beween the fields.

You could use your sort product or the COBOL STRING to do this.

When the file is downloaded, it will have been properly converted to ASCII and ready to use.


Thanks, can you please tell me how we can do it thru Sort card.
Back to top
View user's profile Send private message
rajeevdas03
Warnings : 1

New User


Joined: 21 Jan 2006
Posts: 19
Location: Mumbai

PostPosted: Mon Apr 29, 2013 5:14 am
Reply with quote

Thanks for reply,

can you please help me how to do it thru sort catrd, I am getting error in sorting, please tell me the syntax of how to convert the field.
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 Apr 29, 2013 5:55 am
Reply with quote

Hello,

Post the JCL and sort control statements, the messages generated (including the message ids), the definition of the input data, and some example of the output you want.
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 Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts InfoSphere OPTIM CSV ouput vs DSNTIUA... IBM Tools 3
No new posts Need mmmyy date format SYNCSORT 6
Search our Forums:

Back to Top