Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Sort an input dataset based on col 11 to lenght 6

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Thu Sep 11, 2008 11:07 am    Post subject: Sort an input dataset based on col 11 to lenght 6
Reply with quote

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.
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Sep 11, 2008 11:29 am    Post subject:
Reply with quote

Hi,

please post entire jobb especially all the SYSIN DD statements


Gerry
Back to top
View user's profile Send private message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Thu Sep 11, 2008 11:34 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Sep 11, 2008 11:35 am    Post subject:
Reply with quote

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'
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Sep 11, 2008 11:46 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Thu Sep 11, 2008 12:37 pm    Post subject:
Reply with quote

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 ?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Sep 11, 2008 12:44 pm    Post subject:
Reply with quote

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

should be

INCLUDE=(11,6,CH,LE,X'05700008691')
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Sep 11, 2008 12:47 pm    Post subject:
Reply with quote

Hi,

it shoud be 12 bytes of hex values and not 11


Gerry
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Sep 11, 2008 12:51 pm    Post subject:
Reply with quote

gcicchet wrote:
Hi,
it shoud be 12 bytes of hex values and not 11
Gerry


I should have gone to specsavers icon_sad.gif
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Sep 11, 2008 12:57 pm    Post subject:
Reply with quote

Hi,


Quote:
I should have gone to specsavers


maybe the big X took up the extra byte . icon_lol.gif


Gerry
Back to top
View user's profile Send private message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Thu Sep 11, 2008 12:59 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 11, 2008 7:53 pm    Post subject:
Reply with quote

Hello,

Your hex values only show 11 digits. For 6 bytes, you need 12 hex digits.
X'05700008691'
X'05700010727'
Back to top
View user's profile Send private message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Tue Nov 25, 2008 3:57 pm    Post subject:
Reply with quote

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

Thank you...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 25, 2008 10:55 pm    Post subject: Reply to: Sort an input dataset based on col 11 to lenght 6
Reply with quote

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

d
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 Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us