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
 

 

Converting s9(9) comp field to char

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
l.nethaji

New User


Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu

PostPosted: Fri Jan 22, 2016 12:14 pm    Post subject: Converting s9(9) comp field to char
Reply with quote

Hi ,

I need to convert the s9(9) comp field to CHAR.

The Data looks as below

000001 I BE BLMN CORP
000002 I BE BMNO CORP
000003 $A PE HELLOC JAKE
000004 A PE HELLOC TOM

The first 4 bytes belongs to custid which I need to convert to CHAR

Could you please help me to resolve this issue.

Regards,
L.Nethaji
Back to top
View user's profile Send private message

l.nethaji

New User


Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu

PostPosted: Fri Jan 22, 2016 12:23 pm    Post subject: Reply to: Converting s9(9) comp field to char
Reply with quote

Hi ,

The input file looks as below .

I BE BLMN CORP
I BE BMNO CORP
$A PE HELLOC JAKE
A PE HELLOC TOM

My bad the rows got pasted in my previous post.Apologies.

I just need to convert it to CHAR

Regards,
L.nethaji
Back to top
View user's profile Send private message
l.nethaji

New User


Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu

PostPosted: Fri Jan 22, 2016 12:44 pm    Post subject: Reply to: Converting s9(9) comp field to char
Reply with quote

HI,

I tried the below JCL .

//JS111 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SORTIN DD DISP=SHR,DSN=ACSTNS1.ACST831P.TB01008
//SORTOUT DD DSN=ACSTN&LVL..ACST831P.TB01008.OUTPUT,
// DISP=(NEW,CATLG,DELETE),
// DCB=(RECFM=FB,BLKSIZE=0,DSORG=PS),
// UNIT=SYSDA,SPACE=&SPC1
//SYSIN DD *
OPTION COPY
OUTREC FIELDS=(1,4,BI,CH,LENGTH=11,7,2)
//*

Its giving Syntax error in CH. I am able to do only for converting to numeric edited field.Not able to do it for Char.

Regards,
L.Nethaji
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Fri Jan 22, 2016 2:14 pm    Post subject: Reply to: Converting s9(9) comp field to char
Reply with quote

Code tags. Use them.

If you don't post the error, why should we guess at it?

Have you looked up the error by its message-code?

The is no concept of conversion to "CH".

Since you've not indicated how you want the output, just see what 1,4,BI does. If that's not good enough for you, look at TO= and LENGTH= or the specification of an EDIT mask (EDIT=). Even others.

Can you point to the part of the manual which made you think you could convert to CH? I can attempt to arrange to get it fixed.
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 Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts Amount field is getting corrupted whe... thesumitk SYNCSORT 5 Tue Oct 18, 2016 8:20 pm


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