MVSFORUMS.com

js_praveen · Beginner Joined: 09 Jan 2003 Posts: 20 Topics: 7

Hi All,

I want to convert fields with low values to spaces in a file (10,000 records). Is it better do it in the JCL rather than doing it in the program? Please advice.

Thanks

JSP

kolusu · Posted: Tue Jan 21, 2003 12:42 am Post subject:

Praveen,

There are many of ways of doing it. The easiest would be using utilities like DFSORT, FILE-AID. The following DFSORT jcl will give you the desired results.There is a new feature TRAN=ALTSEQ with the latest PTF which will replace low values with spaces.Be careful with this kind of replacement as it will mess up packed or binary fields that have hex zeros in the first couple of bytes.

Method:1

Grant · Posted: Tue Jan 21, 2003 12:52 am Post subject:

Six of one half dozen of another.

My first thought was to use a utility (such as FileAid) to convert the data in a separate step, but the Inspect statement (assuming you are using Cobol) is pretty slick when both strings are constants (i.e. x'00' and x'40') .

Frank Yaeger · Posted: Tue Jan 21, 2003 11:09 am Post subject:

For more information on the TRAN=ALTSEQ option of DFSORT, see the "Change all zeros in your records to spaces" Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

DFSORT options TRAN=UTOL and TRAN=LTOU are also available to change uppercase to lowercase or lowercase to uppercase, respectively. For more information, see the "Change uppercase to lowercase or lowercase to uppercase" Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
_________________
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

Frank Yaeger · Posted: Thu Aug 07, 2008 4:10 pm Post subject:

With z/OS DFSORT V1R5 PTF UK90013 (July, 2008), you can now use FINDREP to do this kind of thing, e.g.