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
 

 

Convert huge no of Numeric fields to EDITED NUMERIC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
i.see.the.truth

New User


Joined: 21 Sep 2007
Posts: 8
Location: CHENNAI

PostPosted: Tue Dec 08, 2015 6:27 am    Post subject: Convert huge no of Numeric fields to EDITED NUMERIC
Reply with quote

We have a input file having numerous input fields of different datatypes. We have the requirement to convert all numeric fields among them into edited numeric so that the destination application would be able to read the data. To achieve this objective we are using a SORT card like below -

SORT FIELDS=COPY
OUTREC FIELDS=(01:01,04,BI,EDIT=(TTTTTTTTTT),
11:05,05,PD,EDIT=(STTTT.TTTTT),SIGNS=(+,-),
.....500 more fields to be converted
)
END

but due to the huge number of fields converted the SORT step abends with the following error

ICS085A 0 SECOND COMMUNICATION AREA SPACE EXCEEDED - ADD ATLEASE 0K BYTES TO REGION

I've tried using OPTION MAINSIZE=MAX but that doesn't help either.
Back to top
View user's profile Send private message

RahulG31

Active User


Joined: 20 Dec 2014
Posts: 331
Location: USA

PostPosted: Tue Dec 08, 2015 8:07 am    Post subject: Reply to: CONVERT HUGE NUMBER OF NUMERIC FIELDS INTO EDITED NUMERIC
Reply with quote

This may help: http://ibmmainframes.com/about47444.html

.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Tue Dec 08, 2015 9:30 pm    Post subject:
Reply with quote

Quote:
To achieve this objective we are using a SORT card like below

Why don't you write a COBOL program and make it simple and easy to support.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Convert +9999999999999.99 to S9(12)V9(3) vnktrrd DFSORT/ICETOOL 8 Thu Nov 17, 2016 8:15 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts convert PD to ZD ram_vizag DFSORT/ICETOOL 5 Sat Nov 05, 2016 3:06 am
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am


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