Sort an input dataset based on col 11 to lenght 6

P.RAJESH · New User Joined: 20 Mar 2008 Posts: 54 Location: chennai

Hi all,

May be this question discussed beforeo but i can't able to find it in forum so that posting

Question is :

I need to sort an input dataset based on col 11 to lenght 6, this field value appear in data set as in hex decimal format.

I used the control card is INCLUDE=(11,6,BI,LE,X' ø Ñ ')

ø Ñ = generated by previous job.

if i use this control card got ICE113A error message.

All field positions are correct in control i specified.

gcicchet · Posted: Thu Sep 11, 2008 11:29 am

Hi,

please post entire jobb especially all the SYSIN DD statements

Gerry

P.RAJESH · New User Joined: 20 Mar 2008 Posts: 54 Location: chennai

hi Gerry,

OPTION COPY
OUTFIL FNAMES=OUTFIL1,
INCLUDE=(11,6,BI,LE,X' ø Ñ ')
OUTFIL FNAMES=OUTFIL2,
INCLUDE=(11,6,BI,GT,X' ø Ñ ',AND,
11,6,BI,LE,X' ø Ê@')
OUTFIL FNAMES=OUTFIL3,
INCLUDE=(11,6,BI,GT,X' ø Ê@',AND,
11,6,BI,LE,X' ø ß@')
OUTFIL FNAMES=OUTFIL4,SAVE

i have one input file and splitting this file into four files based on the above control card.

expat · Posted: Thu Sep 11, 2008 11:35 am

I believe that you need to use the hexadecimal representation rather than the character representation shown above

example - X'F1F2' is the same as C'12'

gcicchet · Posted: Thu Sep 11, 2008 11:46 am

Hi,

as Expat has already explained, you need to convert the 6 byte search to HEX, ie it should be represented by 12 bytes of HEX values.

Gerry

P.RAJESH · New User Joined: 20 Mar 2008 Posts: 54 Location: chennai

Hi Expat/Gerry,

The equivalent valuse for

ø Ñ = 05700008691 like that i gave to equvalent values in card card for other values also and i ran the job but job passing all record into first data set, it is not splitting reords into other data sets.
Now control card shown below,

OPTION COPY
OUTFIL FNAMES=OUTFIL1,
INCLUDE=(11,6,CH,LE,C'05700008691')
OUTFIL FNAMES=OUTFIL2,
INCLUDE=(11,6,CH,GT,C'05700008691',AND,
11,6,CH,LE,C'05700010727')
OUTFIL FNAMES=OUTFIL3,
INCLUDE=(11,6,CH,GT,C'05700010727',AND,
11,6,CH,LE,C'05700013597')
OUTFIL FNAMES=OUTFIL4,SAVE

Is the control card fine or any chagnes needs to be done ?

expat · Posted: Thu Sep 11, 2008 12:44 pm

INCLUDE=(11,6,CH,LE,C'05700008691')

should be

INCLUDE=(11,6,CH,LE,X'05700008691')

gcicchet · Posted: Thu Sep 11, 2008 12:47 pm

Hi,

it shoud be 12 bytes of hex values and not 11

Gerry

expat · Posted: Thu Sep 11, 2008 12:51 pm

gcicchet · Posted: Thu Sep 11, 2008 12:57 pm

Hi,

P.RAJESH · New User Joined: 20 Mar 2008 Posts: 54 Location: chennai

Hi Expat,

Job got abended with below message i mentioned in first.

ICE113A E COMPARISON FIELD ERROR
OUTFIL FNAMES=OUTFIL2,
INCLUDE=(11,6,CH,GT,X'05700008691',AND,
11,6,CH,LE,X'05700010727')

Gerry,

I tired with your view at the time all records passed to last file

dick scherrer · Posted: Thu Sep 11, 2008 7:53 pm

Hello,

Your hex values only show 11 digits. For 6 bytes, you need 12 hex digits.
X'05700008691'
X'05700010727'

P.RAJESH · New User Joined: 20 Mar 2008 Posts: 54 Location: chennai

Sorry, i didn't informed. I gave the 12 hex digits and got the result.

Thank you...

dick scherrer · Posted: Tue Nov 25, 2008 10:55 pm

Good to hear it is working - thank you for letting us know

d