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

Output from Sort (VB to FB) giving hexadecimal values


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rammraju

New User


Joined: 05 Mar 2005
Posts: 65
Location: Hyderabad

PostPosted: Mon Nov 26, 2007 4:00 pm
Reply with quote

Hi all,
I have a sort card like the below way. input file is a VB flat file, output is a vsam file (FB).
Code:

SORT FIELDS=(54,10,ZD,A,39,2,CH,A,50,2,CH,A)
OUTFIL FILES=01,VTOF,                                           
         IFTHEN=(WHEN=(50,2,CH,EQ,C'31'),                       
          BUILD=(1:54,10,                                       
                11:39,2,                                       
                13:50,2)),                                       
         IFTHEN=(WHEN=(50,2,CH,EQ,C'34'),                       
          BUILD=(1:54,10,                                       
                11:39,2,                                       
                13:50,2))


when i run this in a job, in the output i am only able to see the data which is in character format. the other data which is in numeric/Packed decimal, it is showing as hexadecimal values.

Can anyone let me know how to remove this hexadecimal format for the numberic items.
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 Nov 26, 2007 9:06 pm
Reply with quote

Hello,

Quote:
an anyone let me know how to remove this hexadecimal format for the numberic items.
Why do you want to remove the packed/hex values? I suspect they were created in this format for some reason.

If the file definition for the vsam file includes comp-3 or comp fields, you will need to keep the current definitions.

Why is this a problem for you? If your only concern is "seeing" the values, you can look at the input file with "HEX ON".
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Nov 26, 2007 10:25 pm
Reply with quote

Ram,

It's not clear what you want to do exactly.

If you want to convert numeric values like PD or BI to displayable form, you can use DFSORT's edit masks. See the following for more information:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.8?DT=20060615173822
Back to top
View user's profile Send private message
rammraju

New User


Joined: 05 Mar 2005
Posts: 65
Location: Hyderabad

PostPosted: Tue Dec 04, 2007 8:24 pm
Reply with quote

Hi Frank,
I wanted to convert the PD data to a displayable form, it seems my problem can be solved by using edit masks.

Thanks for the reply
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
Search our Forums:

Back to Top