MVSFORUMS.com

haritha_e · Beginner Joined: 30 Jan 2007 Posts: 14 Topics: 8

Hi,

I have a date field in my input file, which is binary. I want to convert that binary field into character using DFSORT.

Any help in this regard will be appreciated

Regards
Haritha

kolusu · Posted: Wed Mar 14, 2007 12:37 pm Post subject:

haritha_e,

It is very easy. Assume that your binary date field starts at pos 1 for 4 bytes then you can simply use the following sort card

saraswathi · Beginner Joined: 08 Dec 2006 Posts: 14 Topics: 8

hi,

i need to convert a data from binary to numeric. you mentioned the syntax for binary to charcter conversion. shall i use the same for numeric conversion?if so what should i give in EDIT?

thanks,
Saraswathi

kolusu

saraswathi · Beginner Joined: 08 Dec 2006 Posts: 14 Topics: 8

hi,
yes.Its readable format of binary.i tried you code with TTTT option.But if i wish to convert more fields from input file into radable numeric data type what should i do?
say:
X , Y, Z fields in input file are binary.i need to convert them into readable numeric format and write the same in various positions of output file.

thanks,
Saraswathi

kolusu · Posted: Thu Mar 15, 2007 7:48 am Post subject:

saraswathi,

you can code the same for all your binary/packed fields

Frank Yaeger · Posted: Thu Mar 15, 2007 10:42 am Post subject:

A couple of alternatives you can use where n is the length you want for the output field:

p,m,f,M11,LENGTH=n

or

p,m,f,TO=ZD,LENGTH=n

For more information on converting fields with DFSORT, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.7?DT=20060615173822

and:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.8?DT=20060615173822
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort